Installing the SAP Java Connector

In order to retrieve data from SAP ERP (BAPI data sources) or from SAP BW / SAP BI (with multidimensional data sources with the BAPI adapter), install the SAP Java Connector 3.0 (SAP JCo).

SAP provides different JCo libraries for several operating systems and architectures. Download the 64-bit version for the operating system of the computer where Virtual DataPort runs.

Installing the Connector

Follow these steps to install the SAP JCo connector:

  1. Obtain the appropriate driver for your architecture. It can be downloaded from https://support.sap.com/connectors, section SAP Java Connector > Tools & Services.

  2. Decompress the downloaded package in a temporary directory.

  3. SAP JCo depends on the “Microsoft Visual C++ 2010 Redistributable Package” so you need to install it:

    1. Open the page to download the Microsoft Visual C++ 2010 Redistributable Package.

    2. Execute the file vcredist_x86.exe and follow the installation instructions.

    3. Execute the downloaded file and follow the installation instructions.

  4. Log in with the Administration Tool with an administrator account.

  5. Click the menu File > Extensions management.

  6. Click the tab Libraries and then, click Import.

  7. In the new dialog, in Resource type, select sapjco.

  8. In Version, select the version you are going to upload.

  9. Click Add and select these files:

    1. sapjco3.jar

    2. If Virtual DataPort runs on Windows, sapjco3.dll

    3. If Virtual DataPort runs on Linux, libsapjco3.so

    To select more than one file, hold the key Ctrl and select each file.

  10. Click Ok to upload the file(s) to Virtual DataPort.

Testing the Connector on Windows

To test that the JCo connector is properly installed on Windows, open a command prompt on the computer where Virtual DataPort runs and execute the following:

cd <DENODO_HOME>
cd extensions\thirdparty\sap-jco
..\..\..\jre\bin\java.exe -jar sapjco3.jar -stdout

You should see something like this:

Java Runtime:
 Operating System:         Windows 8.1 6.3 for amd64
 Java VM:                  1.7.0_80 Oracle Corporation
 Java Codepage:            Cp1252
Versions:
 JCo API:                  3.0.4 (2009-12-10)
 JCo middleware name:      JavaRfc
 JCo middleware:           2.2.1
 JCo middleware native:    720.29
Paths:
 JCo classes:              C:\Denodo\DenodoPlatform8.0\extensions\thirdparty\sap-jco\sapjco3.jar
 JCo library:              C:\Denodo\DenodoPlatform8.0\extensions\thirdparty\sap-jco\sapjco3.dll

In the last two lines, you should see the path to the files sapjco3.jar and sapjco3.dll. If you see something like “JCo library: not loaded, caused by java.lang.UnsatisfiedLinkError: … Can’t load IA 32-bit .dll on an AMD 64-bit platform” it means that the file sapjco3.dll is the 32-bit version of the file and you should copy the 64-bit one.

If you configured Virtual DataPort to run a Java Runtime Environment (JRE) that is not the one included out of the box, execute this command with that JRE to make sure that at runtime, the SAP JCo connector will work.

Testing the Connector on Linux

To test that the JCo connector is properly installed on Linux, open a command prompt on the computer where Virtual DataPort runs and execute the following:

cd <DENODO_HOME>
cd extensions/thirdparty/sap-jco
../../../jre/bin/java -jar sapjco3.jar -stdout

You should see something like this:

Java Runtime:
 Operating System:         Linux 2.6.32-358.el6.x86_64 for amd64
 Java VM:                  1.8.0_152 Oracle Corporation
 Java Codepage:            UTF8
Versions:
 JCo API:                  3.0.4 (2009-12-10)
 JCo middleware name:      JavaRfc
 JCo middleware:           2.2.1
 JCo middleware native:    720.29
Paths:
 JCo classes:              /opt/denodo/denodo-platform-8.0/extensions/thirdparty/lib/sap-jco-connector/sapjco3.jar
 JCo library:              /opt/denodo/denodo-platform-8.0/extensions/thirdparty/lib/sap-jco-connector/sapjco3.so

In the last two lines, you should see the path to the files sapjco3.jar and sapjco3.so. If you see something like “JCo library: not loaded, caused by java.lang.UnsatisfiedLinkError: … Can’t load IA 32-bit .so on an AMD 64-bit platform” it means that the file sapjco3.so is the 32-bit version of the file and you should copy the 64-bit one.

If you configured Virtual DataPort to run a Java Runtime Environment (JRE) that is not the one included out of the box, execute this command with that JRE to make sure that at runtime, the SAP JCo connector will work.