topic Re: teradata connection failed in Talend Studio

teradata connection failed

Anonymous — Mon, 10 Dec 2018 14:18:40 GMT

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.

Re: teradata connection failed

ankit7359 — Tue, 11 Dec 2018 04:13:12 GMT

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

Re: teradata connection failed

Anonymous — Tue, 11 Dec 2018 16:56:25 GMT

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

Re: teradata connection failed

ankit7359 — Wed, 12 Dec 2018 04:25:06 GMT

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

Re: teradata connection failed

Anonymous — Wed, 12 Dec 2018 05:19:36 GMT

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

Re: teradata connection failed

Anonymous — Thu, 13 Dec 2018 19:10:35 GMT

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