test

Configuring JDBC/ODBC Drivers

OTD Wizard: Database Connection Information

To connect to Teradata, via the Teradata driver, use the information provided in Table 1–15 to complete the Connect to Database step of the JDBC/ODBC OTD Wizard.

Table 1–15 Teradata Driver Database Connection Information

Parameter 

Value 

Driver Jar Files 

teradata.jar

Driver Java Class Name 

com.ncr.teradata.TeraDriver 

URL Connection String 

jdbc:teradata://server-name:server-port/database-server-name

Note –

NOTE: Default server port is 6666 for the Type-3 driver Gateway.

User Name 

Login name of the account used to access the database. 

Password 

Password associated with the login account name used to connect to the database.