Jdbc - Driver and jdbc-Url

[tlongthuan]

Hi,

I work for the first time with teradata and try create a connect to the teradata Warehouse via EAI TIBCO.
In order to do so, I need to define the jdbc-url and driver.
For example for Oracle I use:

jdbc-url : "jdbcracle:thinhostort:instance_name
jdbc-Driver : oracle.jdbc.driver.OracleDriver

Can anybody tell me how the two strings looks like for Teradata?

 

[tdatgod]

Hi,
according to the JDBC manual

http://www.info.ncr.com/sd/sd-1.cfm?page=twotc

click on JDBC then on the version you have.

The manual can be reviewed for a complete list of Params.

-----------------

Enter the following URL to select a Teradata JDBC Type 2 Driver connection to a Teradata RDBMS:

//jdbc:teradata//DatabaseServerName/Param1,Param2,...

Enter the following URL to select a Teradata JDBC Type 3 Driver connection to a Teradata RDBMS:

//jdbc:teradata//GatewayServerNameortNumber/DatabaseServerName/Param1,Param2,...


-----------------


for the driver name.....

4 Use the following statement to load and register the Teradata JDBC Driver:

Class.forName(“com.ncr.teradata.TeraDriver”);



Hope this helps.