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.
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?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.