Installing the SAP Java Connector Library

You must install the SAP Java Connector Library (SAP JCo), version 3.1.5 or higher, on the same computer as TDV. SAP JCo is available at:

https://support.sap.com/en/product/connectors/jco.html

You need to be a registered customer to download the connector. Go to the Download tab on the SAP Java Connector page and click on the appropriate operating system download link for your TDV platform.

It is best not to install the SAP Adapter on the same machine as the SAP GUI, to avoid a possible conflict between JCo versions.

• SAP JCo and Large Volumes of Data
• Installing SAP JCo on Windows
• Testing the SAP JCo Installation on Windows
• Installing SAP JCo on UNIX
• Testing the SAP JCo Installation on UNIX

SAP JCo and Large Volumes of Data

JCo has known memory limitations when processing queries. Severe cases can affect the main TDV Java process. In such cases, we recommend that large queries be divided into small queries.

Installing SAP JCo on Windows

You need to obtain the SAP Java Connector (version 3.1.5 or higher) for your machine from SAP.

To install SAP JCo on Windows

1. Unzip the SAP JCo zip file into a temporary directory.
2. Execute the command to create jre folder under <TDV_install_dir>/jdk:
— ./bin/jlink.exe --module-path jmods --add-modules java.desktop --output ../jre
— create a folder named as ext under <TDV_install_dir>\jre\lib
3. Copy sapjco3.jar to <TDV_install_dir>\jre\lib\ext and <TDV_install_dir>\apps\dlm\app_ds_sap\lib
4. Copy sapjco3.dll to the directory <TDV_install_dir>\apps\common\lib\win64
5. Add a system PATH variable to point to the directory where you put your library files in the previous step.
6. Verify that the Windows system directory includes the files MSVCR71.DLL and MSVCP71.DLL.

These DLLs are the Shared C Runtime (CRT) Components required by SAP JCo but are not shipped with it. If these DLLs are missing, install the Microsoft .NET Framework SDK Version 1.1. Microsoft .NET Framework SDK is available from the Microsoft Developer Network (MSDN) download site.

Testing the SAP JCo Installation on Windows

Be sure to test that the SAP JCo installation works correctly before using TDV.

To test the installation of SAP JCo on Windows

  1. Run the sapjco3.jar Java executable using one of these commands:

Platform

Command

64-bit

 
<TDV_install_dir>/jdk/bin/java
-Djava.library.path="<TDV_install_dir>\apps\server\lib\svn\win64" -jar
"<TDV_install_dir>\apps\dlm\app_ds_[sap|sapbw|sapbwbex]\lib\sapjco3.jar"

  1. Verify that running sapjco3.jar results in a screen that looks like this.

If an error message appears instead, SAP JCo needs to be re-installed.

Installing SAP JCo on UNIX

Follow the instructions to install SAP JCo based on the type of UNIX system you have. You need to obtain the SAP Java Connector (version 3.1.5 or higher driver) for your machine from SAP.

To install SAP JCo (Linux and AIX):

  1. Unzip the SAP JCo tgz file for your machine into a temporary directory.

  2. Copy the jar file to the following location:

cp sapjco<version>.jar ./<TDV_install_dir>/apps/dlm/app_ds_[sap|sapbw|sapbwbex]/lib, where <TDV_install_dir> is the root directory of your TDV Server.

  1. Copy libsapjco<version>.so into one of these directories:

— Linux 64: <TDV_install_dir>/apps/server/lib/svn/lib64
— AIX 64: <TDV_install_dir>//apps/server/lib/svn/aix64

Note: Create the subfolders if they do not exist. In the Linux 64 platform for example, create the folder lib64 under <TDV_install_dir>/apps/server/lib/svn if it does not exist.

  1. (For Linux) Add a system LD_LIBRARY_PATH variable to point to the directory where you put your library files in the previous step. For example, run the following command:

export LD_LIBRARY_PATH=apps/server/lib/svn/lib64

  1. (For AIX) Add a system LIBPATH variable to point to the directory where you put your library files in the previous step. For example, run the following command: 

export LIBPATH=<TDV_install_dir>/apps/server/lib/svn/aix64

Testing the SAP JCo Installation on UNIX

It is critical to verify that SAP JCo is working before you attempt to connect to SAP using TDV.

To test the UNIX installation

From the command line, run the following command:

./<TDV_INSTALL_DIR>/jdk/bin/java -jar <TDV_INSTALL_DIR>/apps/dlm/app_ds_[sap|sapbw|sapbwbex]/lib/sapjco<version>.jar

The above command should run without any errors. Now you are ready to introspect your SAP datasource.