Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Linking Quickbooks to SQL Server
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 06/11/2009 :  15:30:02  Show Profile  Reply with Quote
Hello everyone!

I'm looking for an API or some other way to link the data in my SQL Database to Quickbooks autonomously. My company has a large base of customers and they sell equipment to some of the customers. The finance department wants to track what is sold through Quickbooks, but they don't want to 1) Have to enter all of our customers into quickbooks and 2) Have to update quickbooks every time a change occurs to our SQL database.

Anyone know of an API or some sort of program to handle this?

Starting Member

4 Posts

Posted - 07/22/2009 :  15:56:50  Show Profile  Reply with Quote
I am working on a similar project for my company and I spoke a technician I know at Intuit and he recommended the QODBC driver. One of the problems with working with Quickbooks is that it is a flat file database and not relational. This driver allows any program that is ODBC compliant to work with the Quickbooks data either in a read only or read/write capacity. You will probably have to do what we did and purchase the Server Edition of the Driver. Here is a link to the QODBC website:

Here is a link to another forum which discusses setting up the QODBC Driver for working with MS SQL Server:
Go to Top of Page

Starting Member

1 Posts

Posted - 08/24/2009 :  11:06:13  Show Profile  Reply with Quote
We are working with a similar requirements for our client.If you are interested please send a mail to learn more.

Go to Top of Page

Starting Member

2 Posts

Posted - 12/16/2009 :  04:54:41  Show Profile  Reply with Quote
Just check it may be helpful to you..You can use the Server version of QODBC for this issue resolvability.If you try to extract data from QB using an Open Query statement in a stored procedure using a linked server it runs just one time.
[url=]enterprise quickbooks 10.0[/url]
Go to Top of Page

Yak Posting Veteran

76 Posts

Posted - 12/18/2009 :  09:32:01  Show Profile  Visit behrman's Homepage  Reply with Quote
Suppose that I should mention: I've used the QODBC driver and it did what I needed.
By the way, if your company need a reporting tool, I advise you to have a try of RAQ Report, which I am using now, and it helps me a lot.

RAQ Report: Web-based Excel-like Java reporting tool
Go to Top of Page

Starting Member

1 Posts

Posted - 02/23/2010 :  12:28:39  Show Profile  Reply with Quote
AcccessBooks RealTime provides a very was replication service between SQL Server and QuickBooks. It's from
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000