If you want to create an IDE connection in Jdeveloper IDE and pointing to Teradata database, the below are the steps.
- Download the latest jdbc drivers from Teradata website https://downloads.teradata.com/download/connectivity/jdbc-driver
- Open the menu option Application ---> Default Project Properties in Jdev
- Libraries and Classpath tab ---> click on Add Library --> New
- Give a name 'Teradatalibs' to the library and select Classpath, then click on Add Entry and choose both the jars terajdbc4.jar and tdgssconfig.jar from the earlier downloaded zip. So far we have created a new project library with jdbc drivers required for making a connection to the Teradata DB.
- Navigate to IDE Database Navigator and right click IDE connection and + icon there.
- Click New for Driver class, give the class name as com.teradata.jdbc.TeraDriver and browse for the library 'Teradatalibs' created in the step 4.
- Give User name & password, and need to enter the JDBC url something like jdbc:teradata://<DB HOST NAME>
- Test for connection, it will be success if the details entered are correct.
Screen shot below.
Hope it helps.
Hi Sathish,
ReplyDeleteI tried above steps. I downloaded two jars and placed them at location C:\Oracle\Middleware\jdeveloper\jdev\lib. Then added these to library. But when i am doing test connection getting below error:
Test Failed:Driver class not found.
Verify the driver location.
Please help.
Thanks
Ritika
The above mentions only to add the library to Jdeveloper for design time only! But for running the application , you need to the same to your Weblogic sever class-path.
DeleteThis comment has been removed by the author.
ReplyDeleteGood one Sathish.. If we have LDAP as authentication in Teradata, we can use connection string as jdbc:teradata://DB HOST NAME/LOGMECH=LDAP
ReplyDeleteThanks for this Sathish...
ReplyDelete