One Star

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

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 Smiley Tongue ). 
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.

11 REPLIES
Employee

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

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+...
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
One Star

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

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.
One Star

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

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

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

Hi,
Below are the error details I see:

Thanks.
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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?
One Star

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

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.
One Star

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

Is there anyone listening please? Thanks.
One Star

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

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

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

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.
One Star

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

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