Configuring Talend Administrtion Center (5.3) for MS SQL

[Anonymous]

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.

[Anonymous]

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

[_AnonymousUser]

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

[Anonymous]

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

[Anonymous]

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.

[_AnonymousUser]

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

[Anonymous]

Thank you.