Integration Configuration with SAP Business One 10.0 (HANA)
Purpose
Overview
Add-On Configuration
To successfully connect the iVend add-on in SAP Business One, the below configuration must be done in HANA.
For every SAP Business One company database, there is a user created in HANA. For example, if the Company database name is ‘SBODEMOUS’ then the HANA user name would be ‘SAPB1_DB_USER_SBODEMOUS’.
This user must have the Roles granted as ‘CONTENT_ADMIN’ and the Object Priviledges granted to ‘SBOCOMMON’ as per the below screenshots.
NOTE: If the add-on still does not connect with the above configuration then user must check the add-on log file and if there is any error wrt the privileges (i.e [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;258 insufficient privilege: Detailed info for this error can be found with guid '351784BE296A2C4E88969F6EBF81CC57') User can pass the guid from the above error and execute the below statement in HANA studio to find the missing privileges.
call SYS.GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS ('351784BE296A2C4E88969F6EBF81CC57', ?)
SAP Business One Configuration
The following information is required for the SAP Business one Configuration
Field Name | Description |
Company Name | Name of your company |
Server Type | HANA |
Server Name | HANA Server Name : Port |
License Server Name | SAP License Server : Port |
SLD Server Name | SLD Server : Port |
Database Name | SAP Database name |
DB User ID | Database User ID |
DB Password | Corresponding Password |
User ID | SAP Business One id ( CXSiVend ) mandatory |
Password | Password for CXSiVend |
The following information is required for Integration Configuration
Field Name | Description |
Server Name | SAP Business One Server Address |
Database Name | CXSIntegration (Mandatory) |
UserID | HANA User ID |
Password | Corresponding Password |
Auto Retry | For Auto retry of failed transaction |
Auto Retry Interval (Minutes) | Auto retry interval of failed transaction in Minutes |
Please refer to the below screenshots.
Note: The below query can be executed on ‘SYS’ database to find the Port address for configuring the Integration Tab.
SELECT SERVICE_NAME, PORT, SQL_PORT, (PORT + 2) HTTP_PORT
WHERE(SERVICE_NAME = 'indexserver'and COORDINATOR_TYPE = 'MASTER')
Related Articles
SAP Business One - iVend Retail Integration Points
Introduction SAP Business One software is created specifically for small and midsized businesses. It is a powerful application and iVend Retail seamlessly integrates with it to help retailers better manage every aspect of their daily retail ...General Settings in SAP Business One
Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...SAP Business One Integration
Introduction iVend Retail-SAP Business One Integration Extensibility is used for writing add-on application to customize integration logic. Integration extensibility Add-on allows to write business logic for orchestration of scenarios for new objects ...SAP Business One Integration - Videos
iVend Addon Installation SAP Business One - iVend Integration Service Configuration Manager Retail Warehouse Accounting Setup Retail Settings Initialisation Retail Transactions in SAP Business One SAP Business One - PO and SO Integration With IVend ...Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer"
*****************For Internal purpose********************* Product Version: iVend 6.6 Issue: Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer": Integration Error: System.Data.SqlClient.SqlException (0x80131904): ...