How can we connect to Teradata Database using Tibco BW or Designer?
Before we start, please note that Tibco does not officially support connection to a Teradata database from BW. The ADB Adapter officially supports Teradata and TIBCO suggest using it for your business solution. Note that the ADB Adapter 7.x is written in pure Java and it supports Teradata in a much more consistent way.
If you are still looking for an option to connect Teradata from BW or designer, follow the below steps.
As you know, we need to install DBDrivers in order to connect any database from BW. The database drivers are dependent on TIBCO Runtime Agent version 5.7.x and above. If you have installed TIBCO Runtime Agent 5.7.4 or above, version 2.0.4 of TIBCO Database Drivers will get installed in TIBCO_HOME/tpcl/5.x/jdbc.
Now to configure Teradata connection we need to place the Teradata JAR files (terajdbc4.jar & tdgssconfig.jar) under the same directory. Download the JAR files from Teradata website http://downloads.teradata.com/download/connectivity/jdbc-driver. You can use a Teradata JAR in BW for simple Query or Update, but “Call Procedure” activity cannot show the IN & OUT parameter defined in the procedure as TIBCO does not have code in place to pull relevant metadata for Teradata database.
Also, the Designer will not show the driver name in the drop down list. We have to provide the driver name as “com.ncr.teradata.TeraDriver” instead of selecting any driver.
After copying the JAR files, you need to restart the BW or the Designer to load the teradata drivers.
Hope this help you. Let me know your doubts and feedback in the comment section below.