topic Re: How to use tQuickBooksAdvanced / QBXML commands in Talend Studio

How to use tQuickBooksAdvanced / QBXML commands

Anonymous — Sat, 16 Nov 2024 13:03:03 GMT

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?

Re: How to use tQuickBooksAdvanced / QBXML commands

Anonymous — Tue, 08 Mar 2011 16:40:23 GMT

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?

Re: How to use tQuickBooksAdvanced / QBXML commands

Anonymous — Wed, 09 Mar 2011 10:48:16 GMT

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=viewarticle&kbarticleid=10665&nav=0,58,63

Re: How to use tQuickBooksAdvanced / QBXML commands

peeterm — Tue, 09 Oct 2012 18:38:33 GMT

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

Anonymous — Mon, 06 Jan 2014 16:33:03 GMT

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=viewarticle&kbarticleid=10665&nav=0,58,63

Were you able to figure out any solution to QB ?

Re: How to use tQuickBooksAdvanced / QBXML commands

Anonymous — Fri, 17 Jan 2014 18:30:39 GMT

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