topic Talend Data Quality SQL Server 2017 Metadata Connection Failure in Data Quality

Talend Data Quality SQL Server 2017 Metadata Connection Failure

Anonymous — Sat, 16 Nov 2024 04:40:08 GMT

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

Re: Talend Data Quality SQL Server 2017 Metadata Connection Failure

Anonymous — Tue, 17 Sep 2019 04:47:43 GMT

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

Re: Talend Data Quality SQL Server 2017 Metadata Connection Failure

Anonymous — Tue, 17 Sep 2019 09:56:52 GMT

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,

Re: Talend Data Quality SQL Server 2017 Metadata Connection Failure

Anonymous — Wed, 18 Sep 2019 09:35:49 GMT

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.

Re: Talend Data Quality SQL Server 2017 Metadata Connection Failure

msjian — Wed, 08 Jan 2020 08:02:05 GMT

the same issue with

https://community.talend.com/t5/Data-Quality-Preparation-and/I-am-not-able-to-connect-my-MSSQL-database-to-the-metadata-of/m-p/211004#M3598

Re: Talend Data Quality SQL Server 2017 Metadata Connection Failure

msjian — Wed, 08 Jan 2020 08:48:26 GMT

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