This article explains the steps to install SAP / SAB BW / SAP BW BEx drivers in the TDV container and test the installation.

The SAP JCo drivers can be downloaded from the SAP Support Portal.

Note: SAP account is required to download these drivers.

Steps to Install SAP / SAP BW / SAP BW BEX driver

-> Install steps for DV container:

// copy required jar file
cp sapjco3.jar /var/lib/docker/volumes/tdv8.4-vol/_data/TDV_Server_8.4/apps/dlm/app_ds_sap/lib/ // this is for SAP driver.

cp sapjco3.jar /var/lib/docker/volumes/tdv8.4-vol/_data/TDV_Server_8.4/apps/dlm/app_ds_sapbw/lib/ // this is for SAPBW driver.

cp sapjco3.jar /var/lib/docker/volumes/tdv8.4-vol/_data/TDV_Server_8.4/apps/dlm/app_ds_sapbwbex/lib/ // this is for SAPBWBEX driver.

Note to use the actual location of docker volume in client setup

// copy required lib .so file...
cp libsapjco3.so /var/lib/docker/volumes/tdv8.4-vol/_data/TDV_Server_8.4/apps/server/lib/svn/lin64/ // this is common library required for SAP or SAPBW or SAPBWBEX

// restart container...
docker container restart tdv8.4

// login to the container using docker exec command...
docker exec -it tdv8.4 /bin/bash

// check server logs and verify no errors...
cd /opt/TIBCO/TDV_Server_8.4
tail -f logs/cs_server.log

// Test Driver
export LD_LIBRARY_PATH=/opt/TIBCO/TDV_Server_8.4/apps/server/lib/svn/lin64

Choose SAP ds to test (#1 SAP, #2 SAPBW, #3 SAPBW Bex):
1) ./jdk/bin/java -jar apps/dlm/app_ds_sap/lib/sapjco3.jar -Djava.library.path=$LD_LIBRARY_PATH // for SAP driver
2) ./jdk/bin/java -jar apps/dlm/app_ds_sapbw/lib/sapjco3.jar -Djava.library.path=$LD_LIBRARY_PATH // for SAPBW driver
3) ./jdk/bin/java -jar apps/dlm/app_ds_sapbwbex/lib/sapjco3.jar -Djava.library.path=$LD_LIBRARY_PATH // for SAPBWBEX driver

Note: Output from the tests  #1, #2 or #3 should correctly load the jar and so library files. Otherwise TDV will not work with SAP, SAPBW or SAPBW Bex connectivity.

// unset Env variable after the test is complete...
   unset LD_LIBRARY_PATH

After executing the above steps, try connecting to the SAP BW, SAPBW BEx data sources now using TDV Studio.