Teradata Driver Configuration Properties

OTD Wizard: Database Connection Information
Environment Properties

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 - The 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.

Environment Properties

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 - The 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.

Skip Navigation Links
Exit Print View
	Configuring JDBC/ODBC Drivers for Oracle Java CAPS Java CAPS Documentation