Configuring JDBC/ODBC Drivers

Attunity Driver Configuration Properties

OTD Wizard: Database Connection Information

To connect to Attunity, use the information provided in Table 1–3 to complete the Connect to Database step of the JDBC/ODBC OTD Wizard.

Table 1–3 Attunity Driver Database Connection Information


Parameter	Value
Driver Jar Files	nvjdbc2.jar
Driver Java Class Name	com.attunity.jdbc.NvDriver
URL Connection String	jdbc:attconnect://`server-name`;DefTdpName=`database-logical-name`; OneTdpMode=1 Note – The `database-logical-name` is created in the Attunity server.
User Name	Leave password field blank. Value configured when the database entry is created in the Attunity Server.
Password	Leave password field blank. Value configured when the database entry is created in the Attunity Server.

Use Table 1–4 to configure the environment properties for the specified JDBC/ODBC driver.

Table 1–4 Attunity Driver Database Environment Properties


Parameter	Value
Description	JDBC Connection Pool Datasource
ClassName	com.attunity.jdbc.NvXADataSource
ClassNamefor OtherInterfaces
ServerName	Server name of the machine hosting the database.
PortNumber	`server-port` Note – NOTE: Default server port is 2551.
DatabaseName	<database-name>
User	Leave user field blank. Value configured when the database entry is created in the Attunity Server.
Password	Leave password field blank. Value configured when the database entry is created in the Attunity Server.
DriverProperties	setDefTdpName#`database-logical-name`##setWorkspace#Navigator##
Delimiter	The default is #.
DataSourceName
MinPoolSize	The default is 0.
MaxPoolSize	The default is 10.
MaxIdleTime	The default is 0.