Troubleshooting - QODBC Connection to Talend Open Studio

Note: The JDBC-ODBC bridge driver was removed in Java 8, preventing ODBC drivers from being usable in newer versions of Java or other Java-based applications.

Refer: Oracle JDBC-ODBC Bridge

How to Use QODBC with NetBeans

Problem Description:

QuickBooks Enterprise comes with a tool called QODBC that enables connecting to a QB database to read and write data. I have installed it and can successfully see QB data by connecting with Excel.

I am attempting to be able to read data in Talend Open Studio 5.4.1 by using the Generic ODBC connector. I can get a successful connection message when setting up the database connection, but retrieving the schema to see the tables shows no tables. There are no errors or any other indication - just no table listing.

Solutions:

Please query the table directly instead of loading tables. Use a tDBInput component, use a SELECT query & Click on "Guess Schema."

For Example:

Select * from the customer