topic Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality? in Data Quality

Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Sat, 16 Nov 2024 11:11:09 GMT

Hi all data gurus,
I have finally installed Talend Open Studio for Data Quality and got it running (after a lot of confusions on JDK and Environment Variables ).
Now I am really finding it difficult to figure out how to make a connection to an excel spreadsheet or a CSV file to do some data checking. Can someone please shade some light into it? I mean is there any way I can import an excel file and do some data quality analysis please? I read somewhere that it requires some ODBC connection, but there are no instructions in that.
Thanks in advance.
Cheers.

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

hmassy — Tue, 16 Jun 2015 13:56:54 GMT

Hi DeepData
I suggest that you:
-first read: https://help.talend.com//pages/viewpage.action?pageId=260877733 in order to connect the studio to the file you want to profile.
-second start profiling your csv or excel file following the procedures at https://help.talend.com/display/TalendOpenStudioforDataQualityUserGuide56EN/5.4+Analyzing+data+in+a+file
Then you can check https://help.talend.com//pages/viewpage.action?pageId=260877717 to have a global idea about what types of profiling analyses are supported in the studio. Individual chapters in the documentation give detail information about each type of analysis.
Hiyam MASSY
Documentation team

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Wed, 17 Jun 2015 12:24:17 GMT

Hi Hiyam,
Thanks for all the above links. I have successfully created the ODBC_Excel DataSource as suggested. But unfortunately I get an error while trying to make a database connection in Talend under MetaData DB Connections. Screenshot attached. Can you please help? Thanks.

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Thu, 18 Jun 2015 03:59:09 GMT

Can someone please find a fix for it? Or is there anyone who is getting it work? Generic ODBC Connection?

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Thu, 18 Jun 2015 04:20:35 GMT

Hi,
Below are the error details I see:

Thanks.

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Thu, 18 Jun 2015 06:57:25 GMT

Hi DeepData,
A ODBC connection can be established using the Java ODBC bridge.
Is your ODBC well configured? Did you have the right Driver installed on your computer? This driver installed successfully should be listed in the Odbc Manager of your OS?
Best regards
Sabrina

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Thu, 18 Jun 2015 07:11:09 GMT

Hi DeepData,
A ODBC connection can be established using the Java ODBC bridge.
Is your ODBC well configured? Did you have the right Driver installed on your computer? This driver installed successfully should be listed in the Odbc Manager of your OS?
Best regards
Sabrina

Hi Sabrina,
Please find below the image for the confirmation of my ODBC Configuration. Do you have a detail instructions somewhere?

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Thu, 18 Jun 2015 07:14:44 GMT

I hope you guys will find an appropriate solution to this issue. This is going on for a while and you guys always come back with the same old answer without a valid solution. Thanks.

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Fri, 19 Jun 2015 01:25:14 GMT

Is there anyone listening please? Thanks.

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Fri, 26 Jun 2015 03:02:26 GMT

Hi, Has anyone been able to find a solution to this error please? Especially with Excel ODBC connection. Thanks.

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Sebastiao_Qlik — Tue, 30 Jun 2015 11:28:50 GMT

ODBC connections will not be supported anymore with Java 8: https://blogs.oracle.com/Lance/entry/removal_of_the_jdbc_odbc
Java 7 is getting at its end of life: https://www.java.com/en/download/faq/java_7.xml
I advise that you export your data in csv file or, even better in a database, and that you profile this file/table.

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Sat, 25 Jul 2015 01:03:42 GMT

Hi
Is it possible to analyse data from an XML file , using Talend's Open Studio for Data Quality ?
Regards

Re: Connect to an Excel / CSV file in Talend Open Studio for Data Quality?

Anonymous — Mon, 04 Jun 2018 11:10:24 GMT

links are not working..