Configuring Talend Administrtion Center (5.3) for MS SQL

One Star

Configuring Talend Administrtion Center (5.3) for MS SQL

While configuring Talend Administration Center for MS SQL database, instead of using jtds driver i.e. net.sourceforge.jtds.jdbc.Driver, how to configure Microsoft JDBC driver for MS SQL.

Re: Configuring Talend Administrtion Center (5.3) for MS SQL

i would not even try using MSSQL for that.
and instead use MySQL/MariaDB
good luck
Not applicable

Re: Configuring Talend Administrtion Center (5.3) for MS SQL

Hi nicolas,
We had faced the same issue and opened a ticket.
They have sent us a jtds-1.2.5.jar file and told us to put it into <TOMCAT_HOME>/lib and restart Tomcat.
After we had done that, it worked with MSSQL.
Best regards,
Marco

Re: Configuring Talend Administrtion Center (5.3) for MS SQL

living and learning..
thanks for posting back the requirements for working with MSSQL.
even though i will never use it.
Smiley Wink

Re: Configuring Talend Administrtion Center (5.3) for MS SQL

Marco, Sushshah - I don't understand what database you're talking about here - databases used by your jobs, or are you not using the H2 database that backs TAC itself? I'm Just curious, sounds like Marco's post is probably the solution.
Not applicable

Re: Configuring Talend Administrtion Center (5.3) for MS SQL

As i understood right , sushshah talked about using MSSQL as TAC Admin DB.
We have figured out, that in Version 5.3.1 no driver is encluded for MSSQL DB.
Therefore we have opened a Ticket at Talend Support and they have told us that solution i mentioned.
We dont use H2 DB for TAC, we are sucessfully using MSSQL DB.
Hope i could help.
Best regards,
Marco

Re: Configuring Talend Administrtion Center (5.3) for MS SQL

Thank you.