Quickbooks integration

Rails
1

Does anyone out there have experience integrating with QuickBooks
using qbXML, the QuickBooks Web Connector (QBWC), and
ActionWebService? I’m going to write an integration soon and was
looking for any war stories, hints, or advice.

Thanks,
Zack C.
http://depixelate.com

2

I will be needing to do this a couple of months from now for a project
I am working on. I’d love to hear about your experiences. Sorry won’t
be able to contribute anything right now.

-bakki

PS: Co-incidentally the customer I am working for also is a Zack :slight_smile:

3

I’ve done this before using a combination of Perl, SQL, and qODBC (
http://www.qodbc.com ) – not the most “open” solution and not without
its
problems, but qODBC provides great support and it’d be easy in my mind
to
extend ActiveRecord to interface with it.

I can provide some more details on implementation if you like.

D. Taylor S.,
Reality Technician
http://www.realitytechnicians.com

On 12/6/06, Bakki K. [email protected] wrote:

On 12/5/06, Zack C. [email protected] wrote:

–
D. Taylor S.
Reality Technician
“Look at my hair; like the design.” – David Byrne

4

On 12/7/06, Zack C. [email protected] wrote:

http://www.realitytechnicians.com

PS: Co-incidentally the customer I am working for also is a Zack :slight_smile:

http://depixelate.com

http://depixelate.com
http://trackplace.com

The first article in the series is up:
http://depixelate.com/2006/12/7/rails-and-quickbooks-integration-part-1

–
Zack C.
http://depixelate.com
http://trackplace.com

5

On 12/6/06, D. Taylor S. [email protected] wrote:

http://trackplace.com
–
D. Taylor S.
Reality Technician
“Look at my hair; like the design.” – David Byrne

Thanks for the ideas. QODBC looks interesting put won’t work for my
situation because the integration will happen with a web app.

Since posting my original question I’ve done quite a bit of research
into the QuickBooks SDK and am confident that the integration can be
done the way I want it.

Since there seems to be some interest on this topic I’ll post an
article on the integration within the next few days on my blog at
www.depixelate.com.

–
Zack C.
http://depixelate.com
http://trackplace.com

6

I just finished moving a long time client away from quickbooks to
Netsuite. We did his quickbooks integration with straight qbxml as
that was all they had available at the time. The Netsuite stuff is
very nice, with a very complete soap interface. It’s not cheap, but
then again the main reason our client left quickbooks was because it
has hard limits on the number of customers which he hit.

Chris

7

Thanks a million for that! I can see the pain coming my way in the
not so far future :slight_smile:

-bakki

8

When you did the integration did you use the QuickBooks Web
Connector to sync with the desktop versions? Did you integrate with
QuickBooks online by any chance?

They didn’t have the web connector at the time, it was just raw qbxml.
Never touched quickbooks online.

Chris

9

On 12/8/06, snacktime [email protected] wrote:

Chris,
I’ve looked at NetSuite and it looks nice. I’ll probably integrate
with them in the future. QuickBooks is very popular with small
service-based businesses so this is a priority.

When you did the integration did you use the QuickBooks Web
Connector to sync with the desktop versions? Did you integrate with
QuickBooks online by any chance?

Zack C.
http://depixelate.com
http://trackplace.com