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

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Linking Quickbooks to SQL Server

Author  Topic 

colinoster
Starting Member

1 Post

Posted - 2009-06-11 : 15:30:02
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?

DKidd
Starting Member

4 Posts

Posted - 2009-07-22 : 15:56:50
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:

http://www.qodbc.com/

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

http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=2&post_id=205
Go to Top of Page

estsolutions
Starting Member

1 Post

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

Regards,
Krish
rkrishest@gmail.com
Go to Top of Page

cutecub00
Starting Member

2 Posts

Posted - 2009-12-16 : 04:54:41
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=http://qualityconsultingandbilling.com/quickbooks_enterprise.htm]enterprise quickbooks 10.0[/url]
Go to Top of Page

behrman
Yak Posting Veteran

76 Posts

Posted - 2009-12-18 : 09:32:01
Hi.
Try
www.qodbc.com
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.
Regards,
behrman.

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

tomcrawf
Starting Member

1 Post

Posted - 2010-02-23 : 12:28:39
AcccessBooks RealTime provides a very was replication service between SQL Server and QuickBooks. It's from www.synergration.com
Go to Top of Page
   

- Advertisement -