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.

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

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.

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

• sapjco3.jar

• sapjco3.dll

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.

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

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

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

• sapjco3.jar

• libsapjco3.so

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.