Consume data - Connector for SAP Business One
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.
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.
# Java Classpath (include wrapper.jar) Add class path elements as
# needed starting from 1
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.
# Java Library Path (location of Wrapper.DLL or libwrapper.so)
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.
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.
The name of the connection
is shown here.
The name or IP of the server is shown here.
Name of database column
The name of the connected database is shown here.
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.