Installing the SAP JCo 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.1 (SAP JCo).

You can do this at another time; you do not need to do it right after installing the Denodo Platform.

The following subsections explain:

Installing SAP JCo on Windows

Follow these steps to install the SAP JCo connector on Windows:

  1. SAP JCo requires you to install the Visual Studio 2013 C/C++ runtime libraries on the computer in which the Denodo Platform is installed.

    If this library is not present or you are unsure, follow these steps:

    1. Go to https://support.microsoft.com/en-us/help/4032938 to download the Microsoft Visual C++ Redistributable Package.

    2. In this page, download the file: vcredist_x64.exe. Select the version for the language of your operating system.

      This is the file for 64-bit operating systems and applications that run with the 64-bit version of the Java Virtual Machine (the one included with the Denodo Platform).

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

  2. Create the directory sap-jco-connector inside <DENODO_HOME>\extensions\thirdparty\lib\.

  3. Go to https://support.sap.com/en/product/connectors/jco.html and download the version for Microsoft Windows and Windows Server - 64-bit x86 processor.

  4. Decompress the downloaded file and copy the following files to <DENODO_HOME>\extensions\thirdparty\lib\sap-jco-connector\

    • sapjco3.jar

    • sapjco3.dll

  5. Execute the following commands from a command prompt. This is to test that the JCo connector has all the dependencies it needs.

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

    Check that at the beginning of the output, you see something like this (the output is very long):

    Java Runtime:
     Operating System:    Windows 10 10.0 for amd64
     Java VM:             1.8.0_162 Oracle Corporation
     Default charset:     windows-1252
    Versions:
     JCo API:             3.1.3 (2020-09-18)
     JCo middleware:      JavaRfc 2.10.1
     JCo library:         753.710
    Library Paths:
     JCo archive:         C:\Denodo\Denodo Platform-7.0\extensions\thirdparty\lib\sap-jco-connector\sapjco3.jar
     JCo library:         C:\Denodo\Denodo Platform-7.0\extensions\thirdparty\lib\sap-jco-connector\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.

    Note that you are launching the Java Runtime Environment installed along with the Denodo Platform. If you are going to launch the Denodo Platform with another JRE, execute this command with that JRE to make sure that at runtime, the SAP JCo connector will work.

Installing SAP JCo on Linux

Follow these steps to install the SAP JCo connector on Linux:

  1. Create the directory sap-jco-connector inside <DENODO_HOME>/extensions/thirdparty/lib/

  2. Go to https://support.sap.com/en/product/connectors/jco.html and download the driver for your operating system.

  3. Decompress the downloaded package and copy the following files to the directory <DENODO_HOME>/extensions/thirdparty/lib/sap-jco-connector/

    • sapjco3.jar

    • libsapjco3.so

  4. Execute the following commands from a command prompt. This is to test that the JCo connector has all the dependencies it needs. .. code-block:: batch

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

    You should see something like this:

    Java Runtime:
     Operating System:    Linux 4.14.186-110.268.amzn1.x86_64 for amd64
     Java VM:             1.8.0_162 Oracle Corporation
     Default charset:     UTF-8
    Versions:
     JCo API:             3.1.3 (2020-09-18)
     JCo middleware:      JavaRfc 2.10.1
     JCo library:         753.710
    Library Paths:
     JCo archive:         /opt/denodo/denodo-platform-7.0/extensions/thirdparty/lib/sap-jco-connector/sapjco3.jar
     JCo library:         /opt/denodo/denodo-platform-7.0/extensions/thirdparty/lib/sap-jco-connector/libsapjco3.so
    

    Note that 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.sp is the 32-bit version of the file and you should copy the 64-bit one.

    Note that you are launching the Java Runtime Environment installed with the Denodo Platform. If you are going to launch the Denodo Platform with another JRE, you have to execute this command with that JRE to make sure that at runtime, the SAP JCo connector will work.

    If the library is properly installed, this command runs without error and provides information about the installed JCo libraries.

Installing an Older Version of SAP JCo

We do not recommend using the previous version of the SAP JCo (i.e. JCo 3.0) because SAP ended the maintenance and support period for SAP JCo 3.0 on October 31, 2020.

In case you need to use it anyway, the version 3.0 of this connector requires the Microsoft Visual C++ 2010 Redistributable Package, not the 2013 one.