How to use tQuickBooksAdvanced / QBXML commands

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