CODEWITHSUNDEEP
muledatabase-connectionteradataanypoint-studio
Sravan Yadav Lingam
Sravan Yadav Lingam

Reputation: 33

How to Configure Teradata Database in Anypoint Studio Mule

How to Configure Teradata Database in Mule. The Settings using Generic Databse confiiguration..I have username,password and server name with me.. using these how can i connect succesfully. Ans also what is the connector to be used and what is Driver Class name.

Upvotes: 0

Views: 792

Answers (2)

Anirban Sen Chowdhary
Anirban Sen Chowdhary

Reputation: 8311

The correct way to connect Teradata from Generic Databse confiiguration is as following:- 

<db:generic-config name="Generic_Database_Configuration" url="jdbc:teradata://<your_Ip address of the db_host>/DBS_PORT=1025,DATABASE=<db_name>,USER=<user_Name>,PASSWORD=<password>,CHARSET=UTF8"  
 driverClassName="com.teradata.jdbc.TeraDriver" doc:name="Generic Database Configuration" />

Which is in the form of
jdbc:teradata://<your_Ip address of the db_host>/DBS_PORT=1025,DATABASE=<db_name>,USER=<user_Name>,PASSWORD=<password>,CHARSET=UTF8

and yes terajdbc4.jar and tdgsscconfig.jar are required. Also make sure you are able to connect the Teradata DB if it is hosted in VM so that it is accessible fro Mule application. That's it requires :)

Upvotes: 0

Raj Mevada
Raj Mevada

Reputation: 21

1st Download terajdbc4.jar and tdgsscconfig.jar(optional) and add to your project build path in referenced libraries. Then goto Database connector. Click Generic Database Connector. enter under Dtabase URL:

URL: jdbc:teradata://databaseServername/USER=username,PASSWORD=password DriverClass Name: com.teradata.jdbc.TeraDriver(click search button and add which comes in drop down list)

If you want to add any parameters in URL.. just add it by separating with comma(,)

Test the connection. It will be successful.

Upvotes: 0

Related Questions