Quickbooks QODBC Connection to Talend

Six Stars

Quickbooks QODBC Connection to Talend

Hi all,
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.

  
Has anyone used TOS with QODBC, and if so, how I can I retrieve the schema to be able to use tables in a Talend job?
Thanks in advance,
HL                     
 
One Star

Re: Quickbooks QODBC Connection to Talend

Hi,
I would suggest you to please query table directly instead of loading tables.
For Example:
select * from customer
FAQ : http://support.qodbc.com
Raise a support ticket : http://support.flexquarters.com/esupport/index.php?/Tickets/Submit
Six Stars

Re: Quickbooks QODBC Connection to Talend

Hi Jack,
Thank you - that did it!  I created the database connection, but couldn't retrieve the schema.  Used a tDBInput component, and used a SELECT query.  Clicked on "Guess Schema", and it brought it in just fine.
I appreciate your help.
HL

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads