SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

colinoster
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?

DKidd
Starting Member

USA
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:

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

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

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

cutecub00
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=http://qualityconsultingandbilling.com/quickbooks_enterprise.htm]enterprise quickbooks 10.0[/url]
Go to Top of Page

behrman
Yak Posting Veteran

76 Posts

Posted - 12/18/2009 :  09:32:01  Show Profile  Visit behrman's Homepage  Reply with Quote
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 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 www.synergration.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.17 seconds. Powered By: Snitz Forums 2000