teradata connection failed

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
Eight 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
Eight 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?
Eight 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


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)
Five Stars

Re: teradata connection failed

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

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.