Configure Data Source With 3rd party JDBC Driver (type 3)

TDV Data sources may require 3rd party JDBC drivers (type 3). This section describes how to install such drivers in your TDV Docker container.

Example (install SAP JCo 3rd party JDBC type 3 driver for linux x64 platforms:

1. Find latest SAP JCo JDBC type 3 driver download from SAP.

See the TDV User Guide Chapter “Configuring Advanced Adapters” section “Installing the SAP Java Connector Library” for more details on where to download SAP JCo connection library and how to install it.

2. Install SAP JCo JDBC type 3 driver (linux x64) from SAP in your TDV Container. Refer to the TDV User Guide “Installing SAP JCo on UNIX” section for more details on how to install the linux x64 version of this driver.
sudo cp <sap-cjo-tgz-file> /var/lib/docker/volumes/<tdv-container-volume-name>/_data/TDV_Server_<tdv-version>/tmp

Note: The above example expects a valid tdv-vol, default docker network bridge works on your Docker host, and that you already have a valid TDV Docker Server container that exists and is running.

See References: for more details regarding <tdv-container-volume-name>.

3. Stop your TDV container.
4. Run the following commands:
$ cd TDV_Server_<Version>

$ cp sapjco<version>.jar apps/dlm/app_ds_[sap|sapbw|sapbwbex]/lib

$ cp libsapjco<version>.so apps/server/lib/svn/lib64
5. Restart your TDV container
6. Run the following commands:
$ docker exec -it <TDV container name> /bin/bash

$ cd TDV_Server_<version>

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

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

This command should have no errors.

7. Now you are ready to introspect your SAP datasource.