Topic:   How to configure a connection to Terra data database from webMethods
Jul 30, 2012 15:50 2 Replies 1326 Views Hawk
Prev Next
Topic Replies (2)
  1. 1
    idnkx user

    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.

    1
    idnkx user

    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

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.


Let`s Connect