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
- To start SAP Integration Framework 2.0, choose Start → All Programs → Integration Framework for SAP Business One integration → Integration Framework.
- To log on, in the Administrative User interface, enter the user name and password.
- Choose SLD → Create System.
- In the General Information user window:
- 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.
- Choose Create.
- In the B1DI section:
- In the b1Server field, enter the host name or IP address of the SAP Business One server for example wdfd00184848A.
- In the licenseServer field, enter the host name or IP address of SAP Business One license server. The default is 30000.
- In the company field, enter the technical name of the database instance for your SAP Business One company.
- If you use SAP MaxDB, enter the schema name.
- In the dbType field, select the database type of your SAP Business One database.
- In the dbUser field, enter the user of the SAP Business One database administrator.
- In the dbPassword field, enter the password of the SAP Business One database administrator.
- 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.
- In the password field, enter the password of the B1i user.
- In the language field, select the language to logon to SAP Business One.
- 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.
- 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.
- In the diProxyhost field, enter the IP address of the server where the DI proxy runs.
- In the diProxyport field, enter the port of the DI proxy host, for example 2099.
- 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.
- 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.
- Request the driver and url information for the JDBC section from your database provider. Enter the following:
- 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
- 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.
- 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.
- In the password field, enter the password for database access. Use the same password as in B1DI section in the dbPassword field.
- Choose Save and in the B1DI and JDBC sections, choose Test connection.