How to use tQuickBooksAdvanced / QBXML commands

[Anonymous]

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?

[Anonymous]

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?

[Anonymous]

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...

[peeterm]

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

[Anonymous]

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 ?

[Anonymous]

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 : jdbc dbc atasourcename. I selected the MSODBC mapping.
Cheers