How to use tQuickBooksAdvanced / QBXML commands

Highlighted
One Star

How to use tQuickBooksAdvanced / QBXML commands

Hi, I have been asked to connect to a QuickBooks system with Talend and I have found two options:
1. QOBDC (link)
2. tQuickBooksAdvanced (link)
Using option number 2 seems tempting but I am not sure how to approach the component - it only gives me a qbXmlResp column as output and this code in the QB XML field of the component:
"<?xml version=\"1.0\" ?><?qbxml version=\"2.0\" ?>\n<QBXML>\n<QBXMLMsgsRq
onError=\"stopOnError\">\n<CustomerQueryRq
requestID=\"my_1234\">\n</CustomerQueryRq>\n</QBXMLMsgsRq>\n</QBXML>"

Does anyone have any experience of using either option to communicate with, and extract data from, QuickBooks?
One Star

Re: How to use tQuickBooksAdvanced / QBXML commands

Trying to run just a very simply job (directing the input from the tQuickBooksAdvanced component via a tMap to a tLogRow) renders this error message:
 connecting to socket on port 3491
connected
<ERROR>Could not determine the version of the QuickBooks company data file, or the data file has been modified and requires a newer version of QuickBooks.</ERROR>
disconnected

Does anyone know if this component is written for a specific version of QuickBooks?
One Star

Re: How to use tQuickBooksAdvanced / QBXML commands

I would like to know how to use an ODBC connection string like this (see link) to connect in Talend - would I use a Generic ODBC connection? How do I specify the exact connection string? Or how do I go about it?
http://support.flexquarters.com/esupport/index.php?loginresult=1&group=default&_m=knowledgebase&_a=v...
One Star

Re: How to use tQuickBooksAdvanced / QBXML commands

May be easier way is to connect to QuickBooks Online via this Talend connector http://cloudbee.com/quickbooks-talend-component/

Re: How to use tQuickBooksAdvanced / QBXML commands

I would like to know how to use an ODBC connection string like this (see link) to connect in Talend - would I use a Generic ODBC connection? How do I specify the exact connection string? Or how do I go about it?
http://support.flexquarters.com/esupport/index.php?loginresult=1&group=default&_m=knowledgebase&_a=v...

Were you able to figure out any solution to QB ?
One Star

Re: How to use tQuickBooksAdvanced / QBXML commands

I just got QODBC to work last night.
The problem you run into is QODBC being 32bit. The 64Bit option with QRemote does not work.
You need to install the 32bit JRE and the 32bit version of Talend and then use the Generic ODBC connector to connect : jdbcSmiley SurpriseddbcSmiley Very Happyatasourcename. I selected the MSODBC mapping.
Cheers

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 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog