Integration Configuration with SAP Business One 10.0 (HANA)

Integration Configuration with SAP Business One 10.0 (HANA)

Purpose 

The purpose of this document is to describe the configuration procedure, for iVend integration with SAP Business One 10.0 (HANA). 

Overview

The iVend Retail integrates seamlessly with SAP Business One 10.0 (HANA). This document discusses the Integration Service Configuration of SAP Business One. 

The Integration Configuration includes:
-- Add-on Configuration
-- SAP Business One Configuration
-- Integration Configuration 

 iVend Integration component must be installed in SAP Business One Environment. 

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


Please refer to the below screenshots.

 

 

 

Integration Configuration 

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

FROM SYS.M_SERVICES 

WHERE(SERVICE_NAME = 'indexserver'and COORDINATOR_TYPE = 'MASTER') 

or SERVICE_NAME = 'xsengine'


Click on Update Button to save and update the configurations.