Knowledgebase: Tutorials
[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 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.

http://support.flexquarters.com/esupport/newimages/Talend/step1.png

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

(0 vote(s))
Helpful
Not helpful

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