Consume data - Connector for SAP Business One

Installation

Please note that Intrexx is only delivered as a 64 bit system. For writing communication to SAP Business One the DI API should also be installed in 64 bit.

Modifying portal.wcf

The "portal.wcf" file can be found in the portal directory internal/cfg. Add the directory for the classpath where the JAP JCO libraries (*.jar) are stored.

Example

# Java Classpath (include wrapper.jar) Add class path elements as
# needed starting from 1
wrapper.java.classpath.1=C:\intrexx\lib\update
wrapper.java.classpath.2=C:\intrexx\lib\*.jar
wrapper.java.classpath.3=C:\intrexx\lib\remote\*.jar
wrapper.java.classpath.4=C:\Program Files\SAP\SAP Business One DI API\JCO\LIB\*.jar

Please make sure the storage location is entered correctly to the path and that the numbers in the Classpath elements are numbered correctly and sequentially. The Java Library Path is also located in the "portal.wcf" file. Add to this path to include the directory where the SAP JCP dll files are located.

Example

# Java Library Path (location of Wrapper.DLL or libwrapper.so)
wrapper.java.library.path.1=C:\intrexx\bin\windows\amd64
wrapper.java.library.path.2=C:\Program Files\SAP\SAP Business One DI API\JCO\LIB

Save your changes and restart the portal server afterwards.

New data source

Selecting Data source menu / New data source will open a wizard where a connection to your SAP Business One system can be created. This option is available if the Connector for SAP Business One is selected under Consume data on the left-hand side. In each configuration dialog, you can reach the corresponding Intrexx Help by pressing F1 or by clicking on the "Help" button.

Edit connection

Every connection created by you is listed in the right-hand area. All of the functions available for editing a connection can be reached via the Data source menu, when an existing connection has been selected on the right.

Name column

The name of the connection is shown here.

Server column

The name or IP of the server is shown here.

Name of database column

The name of the connected database is shown here.

Troubleshooting

It is not recommended to use a 64-bit Windows Server with a 32-bit SAP Business One Server in combination with Intrexx, because Intrexx will always install the 64-bit version of the software by default. If no connection to the SAP Business One Server is possible, despite having installed the JCO and SAP DI API, the problem may resolve itself after installing the SAP Business One Client.