Resolution:
TIBCO ActiveMatrix BusinessWorks 5.x currently does not support Teradata. We have an enhancement request for Teradata support.

********
BW-8034 jdbc activity support for Teradata database
********

Although Teradata is not officially tested nor supported by Tibco. Simple JDBC activities like "Query", "Update" etc,. work fine. "Call Procedure" activity cannot show the "IN/OUT" parameter defined in the procedure as we do not have code in place to pull relevant metadata for tera data database.

If you have to use "Procedures" in Teradata Database, we would suggest the following:

1).  TIBCO Adapter for Teradata. i.e, KB29223 .
2).  Otherwise, use pure Java code. 

If you would still use a TeraData JAR in BW for simple "Query/Update", Designer will not show the driver name in the drop down list. Provide the driver name instead of selecting any driver (the JDBC connection activity does not ask for a driver selected once the right driver name is there). Note that it is better to put the JARs in the "tpcl_home/jdbc" folder which is for JDBC driver JARs, instead of other places in the classpath.