Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - QODBC Connection to Talend Open Studio
Posted by Jack - QODBC Support on 08 October 2015 08:58 AM

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 I 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 when retrieving the schema to see the tables, it shows with no tables. There are no errors or any other indication - just no table listing.


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

For Example:

select * from customer

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).