Talend Data Quality SQL Server 2017 Metadata Connection Failure

Highlighted
Four Stars

Talend Data Quality SQL Server 2017 Metadata Connection Failure

Hi,

I'm trying to Talend DQ Tool with SQL Server 2017. But SQL Server connection failed as show below...

Kindly note, we also use Talend Data Integration Tool with SQL Server but we haven't face issues. Same Windows Machine I can't to connect to SQL Server using Talend DI Tool. There is no firewall issues. I'm using same SQL Server jdbc driver with Talend DI Tool.

 

Kindly help me SQL Server Metadata connection for SQL Server on Talend Data Quality.

 

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:209)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1133)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4207)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:125)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:150)
... 9 more

 

Talend_DQ_MSSQL_Error.jpg

Talend_DQ_MSSQL_Module.jpg

 

Highlighted
Moderator

Re: Talend Data Quality SQL Server 2017 Metadata Connection Failure

Hello,

Have you tried to copy the ntlmauth.dll into the usual folders to see if you are able to get the Microsoft SQL connections working in your talend data quality studio?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Four Stars

Re: Talend Data Quality SQL Server 2017 Metadata Connection Failure

Thanks for your reply!

Yes, did I copied file "ntlmauth.dll" into below path

C:\Program Files (x86)\Java\jre1.8.0_211\bin

I'm getting below error... Kindly help,

 

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:209)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1133)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4207)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:125)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:150)
... 9 more

 

Highlighted
Four Stars

Re: Talend Data Quality SQL Server 2017 Metadata Connection Failure

Hi,

Any help will be grateful, I tried with multiple version of jdbc driver but failed. Any guides will helpful.

Please I can able to connect via SQL Server Management Studio and Talend DI Tool but failed with Talend DQ Tool.

 

 

Highlighted
Employee

Re: Talend Data Quality SQL Server 2017 Metadata Connection Failure

Highlighted
Employee

Re: Talend Data Quality SQL Server 2017 Metadata Connection Failure

Hi, 

can you test again?

when create connection, there will popup the download jar dialog, and you need to click the "download and install"  or "download and install all modules available" button to download the jar and accept, then the connection will successfully.

 

you can refer to the attachment image

 

Regards
Jian
----------------------------------------------------------
Talend | Data Quality

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read