Terradata is a Database and we can user JDBC Adapter to connect to Terradata. Please find the configuration details which we applied while configuring JDBC Adapter connection to Terradata Database:
[b]Connection Type JDBC Adapter Connection[/b]
Package Name TerraData_Example
[b]Connection Properties[/b]
Transaction Type LOCAL_TRANSACTION
DataSource Class com.teradata.jdbc.TeraDataSource
serverName terradata.xyz.com
user tera_user_wm_tst
password ******
databaseName dbase_terra_wm_tst
portNumber 1025
networkProtocol tcp
Other Properties DSName=100.00.75.900
[b]Connection Management Properties[/b]
Enable Connection Pooling true
Minimum Pool Size 0
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10
Leave a Reply
Guest User
Not sure what course is right for you?
Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.
Hawk
Hi Experts,
How to configure a connection to Terra data database from webMethods, is there any Adapter available ?
Let me know your thoughts on this.
Neelima
Terradata is a Database and we can user JDBC Adapter to connect to Terradata. Please find the configuration details which we applied while configuring JDBC Adapter connection to Terradata Database:
[b]Connection Type JDBC Adapter Connection[/b]
Package Name TerraData_Example
[b]Connection Properties[/b]
Transaction Type LOCAL_TRANSACTION
DataSource Class com.teradata.jdbc.TeraDataSource
serverName terradata.xyz.com
user tera_user_wm_tst
password ******
databaseName dbase_terra_wm_tst
portNumber 1025
networkProtocol tcp
Other Properties DSName=100.00.75.900
[b]Connection Management Properties[/b]
Enable Connection Pooling true
Minimum Pool Size 0
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10