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. |
Use Table 1–16 to configure the environment properties for the specified JDBC/ODBC driver.
Table 1–16 Teradata Driver Environment Properties
Parameter |
Value |
---|---|
Description |
JDBC Connection Pool Datasource |
ClassName |
com.ncr.teradata.TeraConnectionPoolDataSource |
ClassNamefor OtherInterfaces | |
ServerName |
Server name of the machine hosting the database. |
PortNumber |
server-port Note – NOTE: Default server port is 6666 for the Type-3 driver Gateway. |
DatabaseName |
database-name |
User |
Login name of the account used to access the database. |
Password |
Password associated with the login account name used to connect to the database. |
DriverProperties |
setURL#jdbc:teradata://server-name:server-port/database-server-name ##setDSName#database-server_name## |
Delimiter |
The default is #. |
DataSourceName | |
MinPoolSize |
The default is 2. |
MaxPoolSize |
The default is 10. |
MaxIdleTime |
The default is 0. |