Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 0683p000009MAB6.png ). 
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.

Labels (3)
12 Replies
Sebastiao_Qlik
Employee
Employee

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.
Anonymous
Not applicable
Author

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

links are not working..