teradata connection failed

Highlighted
Five Stars

teradata connection failed

I cannot connect to Teradata database. getting message "Connection Failure. You must change the Database Settings." sometime ago I was using Talend Open Studio for Data Quality without any problem when I upgraded to 7.1 connection failed. Now i cannot even use 6.5 because i am getting the same error message

failure is due to

tdgssconfig-15.10.00.14.jar

terajdbc4-15.10.00.14.jar

see attached.


Accepted Solutions
Nine Stars

Re: teradata connection failed

Hi @mkebede,

Where you would like to place your Jar Files it is upto you.. but i strongly recommend you create new folder/directory in your Talend Folder/My Documents/Desktop etc... 

If your query is answered then pls mark the topic as resolved.

Pls reach out to the Community,if necessary.

Thanks,

Ankit


All Replies
Nine Stars

Re: teradata connection failed

Hi @mkebede,

Greetings of the day,

i see that you are facing issues with your Talend, well considering the screenshot attached and the problem you are facing it is most likely that the jar files are not installed in your system and even if they are installed in your system you have to point your Talend to the components destination.

Well if the first case is true,where you dont have the components then you can download them from Teradata Website : https://downloads.teradata.com/download/connectivity/jdbc-driver or 

https://sourceforge.net/directory/development/database/os:windows/

and if it is the second case where the components exist in the system then open your Open Studio and click on Windows(in the Menu bar)----->>>>>Preferences----->>>>>Talend-------->>>>>Talend Component ------>>> shows the default directory---change it to the directory where the components are existing.

Pls try above and if you are facing any issues, Pls get back to the Community.

Thanks,

Ankit

 

Five Stars

Re: teradata connection failed

Thanks! Where is the correct directory to place the files?
Nine Stars

Re: teradata connection failed

Hi @mkebede,

Where you would like to place your Jar Files it is upto you.. but i strongly recommend you create new folder/directory in your Talend Folder/My Documents/Desktop etc... 

If your query is answered then pls mark the topic as resolved.

Pls reach out to the Community,if necessary.

Thanks,

Ankit

Employee

Re: teradata connection failed

Hi,

 

     There are changes in the way tDB component work from version 7 onwards.

 

     Did you try to open the tDB component in a new job and check whether all the associated jars are automatically installed ? Sometimes the jars will be missing and the component will prompt to install the missing jars. Once you install them through the download path given in the popup, the component will start working in normal fashion.

 

Warm Regards,

 

Nikhil Thampi

Five Stars

Re: teradata connection failed

Thanks. downloaded the .jar files from Teradata website. installation is complete

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch