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.
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 |
|
|
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,Krishrkrishest@gmail.com |
|
|
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] |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2009-12-18 : 09:32:01
|
Hi.Trywww.qodbc.comSuppose 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 |
|
|
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 |
|
|
|
|
|