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?
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:
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]
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.