Configuration in SAP Integration Framework 2.0 to connect SAP Businesss One for SAP ECC integration

Configuration in SAP Integration Framework 2.0 to connect SAP Businesss One for SAP ECC integration

For each SAP Business One company database you want to connect to, a system entry using DI API parameters must be available in the System Landscape Directory of SAP Integration Framework 2.0. 

Procedure

  1. To start SAP Integration Framework 2.0, choose Start  All Programs  Integration Framework for SAP Business One integration  Integration Framework.
  2. To log on, in the Administrative User interface, enter the user name and password.
  3. Choose SLD  Create System.
  4. In the General Information user window:
  1. In the System Type field, select the system type of your SAP Business One company database.

Use only B1.* system types.

     2.In the System Name field enter a description for your SAP Business One company database.
  1. Choose Create.
  1. In the B1DI section:
    1. In the b1Server field, enter the host name or IP address of the SAP Business One server for example wdfd00184848A.
    2. In the licenseServer field, enter the host name or IP address of SAP Business One license server. The default is 30000.
    3. In the company field, enter the technical name of the database instance for your SAP Business One company.
    4. If you use SAP MaxDB, enter the schema name.
    5. In the dbType field, select the database type of your SAP Business One database.
    6. In the dbUser field, enter the user of the SAP Business One database administrator.
    7. In the dbPassword field, enter the password of the SAP Business One database administrator.
    8. In the userName field, enter the user name of the technical user that retrieves and posts integration data in SAP Business One. The default user is B1i. It must be available in the SAP Business One company.
    9. In the password field, enter the password of the B1i user.
    10. In the language field, select the language to logon to SAP Business One.
    11. In the isTrust field, select true for a trusted connection to SAP Business One. SAP Integration Framework 2.0 uses the Microsoft Windows trusted database logon instead of the values of the dbUser and dbPassword fields. SAP recommends selecting false and providing dbUser and dbPassword values.
    12. In the jocPath field, enter the installation path of JCO, for example C:\Program Files\SAP\SAP Business One DI API\JCO\LIB.

NOTE

You can centrally provide the JCO path in the DI proxy property file for each SAP Business One server. We recommend this approach as it is less error prone. If you follow this approach, leave the field empty.

The DI-API version must be exactly the same version as your SAP Business One application.

Caution

The DI-API version must be exactly the same version as your SAP Business One application.

    1. In the diProxyhost field, enter the IP address of the server where the DI proxy runs.
    2. In the diProxyport field, enter the port of the DI proxy host, for example 2099.
    3. Optionally in the proxyHost field, enter the host name or IP address of the http proxy host. You can leave the field empty, if a proxy is not necessary.
    4. Optionally, in the proxyPort field, enter the port of the http proxy host. You can leave the field empty, if a proxy is not necessary.
  1. Request the driver and url information for the JDBC section from your database provider. Enter the following:
  1. In the driver field, enter the Java class of the JDBC driver.

For SAP MaxBD, enter for example: com.sap.dbtech.jdbc.DriverSapDB

For Microsoft SQL Server enter: com.microsoft.sqlserver.jdbc.SQLServerDriver

  1. In the url field, enter the path to the JDBC driver.

For SAP MaxDB, enter for example: jdbc:sqlserver://<ipaddress>;databaseName=<DatabaseName>

For Microsoft SQL Server, enter: jdbc:sqlserver://<ip address>;integratedSecurity=false;databaseName=<DatabaseName>;selectMethod=cursor

<ipaddress> is the IP address or name of the database server

<DatabaseName> is the name of the database

Use the same database name as in the company field of the B1DI section. For SAP MaxDB, provide here the name of the database (instance). In the B1DI field, you provide the schema name.

Use the same IP address as in the b1Server field of the B1DI section.

  1. In the username field, enter the user name for database access. 

Use the same user name as in the dbUser field of the B1DI section.

  1. In the password field, enter the password for database access. Use the same password as in B1DI section in the dbPassword field.
  1. Choose Save and in the B1DI and JDBC sections, choose Test connection.
    • Related Articles

    • Configuration in SAP Integration Framework 2.0 to connect SAP ECC

      To enable communication between SAP Integration Framework 2.0 and SAP ECC, do the following in SAP Integration Framework 2.0: Create a system landscape entry for SAP ECC with RFCA parameters in the System Landscape Directory Maintain connectivity ...
    • SAP ECC Integration with SAP Business One

      The integration package for integration with SAP ECC provides you with sample integration content and is addressing partners to rapidly build up their demo and development system. The sample integration content must not be applied as-is into the ...
    • Configuration in SAP ECC to connect with SAP Integration Framework 2 0

      In SAP ECC check whether there is a client and RFC destination available for the client you want to use for the connection to SAP Integration Framework 2.0. Create a logical system and an RFC destination for SAP Integration Framework 2.0 in SAP ECC. ...
    • Enabling SNC for SAP Integration Framework 2.0 for SAP ECC Integration

      In the following sections we assume that you run SAP Integration Framework 2.0 on a Microsoft operating system.  Downloading and Installing the SAP Cryptographic Library The SAP Cryptographic Library is the default security product delivered by SAP ...
    • Connecting SAP ECC to SAP Integration Framework 2.0

      SAP Integration Framework 2.0 uses RFC connections to connect to SAP ECC. To set up the connection, perform the following tasks: In SAP ECC: Check the logical system entry for the client to which you want to connect. Check the RFC destination and ...