Skip to main content

System and System Line Configuration

This section provides details about how to create a System Line and a System for a SAP Business One. Details on how to create a specfic Function is provided separately.

System Line​

For the System Line the configuration is straightforward and equivalent to the other kinds of System Line configurations:

  • Kind: SAPBusinessOne

  • Authentication: Enabled

  • Short Name: As usual a descriptive and identifying name

System​

The configuration for a specific SAP Business One is similar to the configuration to a ODBC connection to a SQL Server. As usual information for "System data", "Authentication Configuration" and "Technical parameters" have to be provided.

System data​

  • Short Name: A descriptive and identifying name

  • Location: Assign the System to a Location (has to be created and enabled before)

  • Authentication: Here several opportunities are available, it also depends it enabled on System Line level

    • Delegated: The authentication is specified on the individual Function
    • Shared Basic Auth (User and Password): Define a user and a password which is used for all Functions of this System.

After providing the system data information and saving additional information might be required:

Authentication Configuration​

In case of Shared Basic Auth (User and Password): Define the User Name and the Password which should be used

Technical parameters​

  • CONNECTION_STRING: The connection string to the underlying relational database. Please do not insert authentication details (e.g. username or password). This parameter is required. An example (here for an underlying HANA database system) is given as follows: serverNode=sid-hdb:30013;databaseName=HDB;CS=SBODEMOGB;. Be aware that the "CS" (for "current schema") parameter might be required.
info

If the default schema of the authentication user is not the default organization-schema, the default organization-schema needs to be selected in the connection string. Be aware that the parameter name for schema selection depends on the underlying database system (e.g. CS for HANA systems).

  • DB_TYPE: The type identifier of the underlying type of the database. For example 9 if it is SAP HANA, 15 if it is a MS SQL Server 2019.

  • DRIVER_NAME: Provide the name of the relational database driver of the underlying database. For example HDBODBC in case of SAP HANA.

note

Please do not forget to enable the Function by checking the "enabled" box in the System data window. Otherwise the Function will not be available.