beautypg.com

A.8 teradata driver, A.8.1 otd wizard: database connection information, A.8.2 environment properties – Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 128: Teradata driver, Otd wizard: database connection information, Environment properties

background image

Appendix A

Section A.8

JDBC/ODBC Drivers

Teradata Driver

JDBC/ODBC eWay Adapter User’s Guide

128

Sun Microsystems, Inc.

Note:

It is not mandatory to enter driver properties in the Outbound JDBC eWay
Environment properties for Sequelink DataDirect MS Access ODBC.

A.8

Teradata Driver

Configuration Properties:

ƒ

OTD Wizard: Database Connection Information

on page 128

ƒ

Environment Properties

on page 128

A.8.1

OTD Wizard: Database Connection Information

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

A.8.2

Environment Properties

Use Table 39 to configure the environment properties for the specified JDBC/ODBC
driver.

MaxIdleTime

The default is 0.

Table 38 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://:/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.

Table 39 Teradata Driver Environment Properties

Parameter

Value

Description

JDBC Connection Pool Datasource

ClassName

com.ncr.teradata.TeraConnectionPoolDataSource

Table 37 MS Access ODBC Driver Environment Properties (Continued)

Parameter

Value