I am totally new to the Talend platform, I am still in the learning process.
Everything was working well til I had tried to connect into SQL Server database. I don't have experience with Java environments at all. I tried using M$ JDBC and Open Source JTDS drivers.
Talend Open Studio and SQL Server instance running in the same machine. For the SQL side, everything is ok.
Could anyone help me?
SQL Server 2017 express edition
Talend Open Studio 6.5
It looks like your connection details are incorrect. To solve this you need to give us....
1) Your DB configuration details. Host, port, database name, username, password (you can hide but be aware it needs to be set).
2 Show us how you have tried to set it up
Could be problem with credintials or Sql server Jar issue.
Here is online document about:TalendHelpCenter: Supported systems, databases and business applications by Talend components for V 6.5
MS SQL Server
Thank you for the prompt answers.
@xdshi , I think it is not working because I tried with SQL Server 2017 edition. After that, I tried in a different server that is SQL Server 2016 and now, no more issues with connections!
So far, SQL Server 2017 edition is not list on the supported databases platform.(v 6.5.1)
In the documentation we provide a list of databases that are supported, in the sense that we do provide an SLA and technical support for them. This doesn't mean other (non-listed) databases will not work but simply we won't necessarily be equipped to help you with any issue you may face with them.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema