I am not able to connect my MSSQL database to the metadata of Talend Data Quality

Highlighted
Five Stars

I am not able to connect my MSSQL database to the metadata of Talend Data Quality

But this same database worked fine with Talen Data Integration

error.PNGCapture.PNG

Highlighted
Community Manager

Re: I am not able to connect my MSSQL database to the metadata of Talend Data Quality

Not sure if it was a bug, I will test and come back to you asap!

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Highlighted
Five Stars

Re: I am not able to connect my MSSQL database to the metadata of Talend Data Quality

Hi,i wanted to ask if this error would show up,if i have missed installing some modules?
Highlighted
Employee

Re: I am not able to connect my MSSQL database to the metadata of Talend Data Quality

there will popup a dialog to download jtds driver file

for example: jtds-1.3.1.jar 

do you do that?

 

Highlighted
Five Stars

Re: I am not able to connect my MSSQL database to the metadata of Talend Data Quality

Ya ,i have installed that
Highlighted
Employee

Re: I am not able to connect my MSSQL database to the metadata of Talend Data Quality

hi

not sure whether this issue has been fixed by

https://jira.talendforge.org/browse/TDQ-17308

 

and the workaround  is you can try to select another Microsoft official driver

DB version:  select Microsoft

 

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

Highlighted
Five Stars

Re: I am not able to connect my MSSQL database to the metadata of Talend Data Quality

Actually,i even tried doing that still i am not able to connect to a BD ,
will i am easily able to connect to a MySQL DB
Highlighted
Employee

Re: I am not able to connect my MSSQL database to the metadata of Talend Data Quality

Hi, 

can you test again?

open the create connection wizard, click the "Test connection" button, 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

Highlighted
Five Stars

Re: I am not able to connect my MSSQL database to the metadata of Talend Data Quality

NO i am not getting any popups
Highlighted
Employee

Re: I am not able to connect my MSSQL database to the metadata of Talend Data Quality

Hi
I just test on 721 it works.

can you open the connection wizard to check again?

or re-unzip a studio to test again?

 

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

Highlighted
Five Stars

Re: I am not able to connect my MSSQL database to the metadata of Talend Data Quality

Hi,I am still getting the same error

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