What to do if after upgrading the TIBCO Data Virtualization Server, an error pops up when a test connection to the SAP ( SAP, SAP BW and SAP BWEX) data sources is tested?
book
Article ID: KB0070454
calendar_today
Updated On:
Products
TIBCO Data Virtualization
Description
The error "Unable to initialize SAP JCo. Verify that SAP JCo 3.0.9 or higher is properly installed" is seen when the SAP drivers are not configured correctly. The steps to do so are mentioned below.
Issue/Introduction
This article will provide a guide for Windows on what are the steps to follow, to solve the "Unable to initialize SAP JCo. Verify that SAP JCo 3.0.9 or higher is properly installed" error?
Environment
Windows
Resolution
Please follow the below steps: -------------------------- 1. Unzip the SAP JCo zip file for your machine into a temporary directory.
2. Execute the command to create jre folder under <TDV_install_dir>/jdk: — ./bin/jlink --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 and sapjco3.dll to below location of <TDV_install_dir>/ where <TDV_install_dir> is the root directory of your TDV Server. -- <TDV_install_dir>/jre/lib/ext -- <TDV_install_dir>apps\dlm\app_ds_sap\lib --For SAP adapter connectivity -- <TDV_install_dir>apps\dlm\app_ds_sapbw\lib -- For SAP BW adapter connectivity -- <TDV_install_dir>apps\dlm\app_ds_sapbwbex\lib -- For SAP BW Bex adapter connectivity
4. Add the path in system environment variables to point to the directory where the library files have been placed in the previous step. -- <TDV install dir>\apps\dlm\app_ds_sap\lib
5. Restart TDV monitor service
6. Open TDV Studio and establish a connection to your SAP instance using the SAP adapter. --------------------------