Question

I need to extract Quickbooks SQL structure to make a Diagram about the tables that I need to work with. Could this be possible ? I think QODC could solve my connection issue but I don t know how to extract SQL dump from it.

Thanks in advance

Answer 1

You can t directly access the QuickBooks SQL structure, so you re out of luck. Most versions of QuickBooks are not even based on an SQL backend (only Enterprise edition is), so it s not even applicable to those versions.

QuickBooks provides an XML-based API to adding/modifying/querying/deleting data within it, but does not provide direct SQL access. QODBC is a wrapper around the XML-based API which simply transforms XML requests into SQL requests, and vice versa. It is not reverse-engineering anything, it s simply transforming data from one format/protocol, into another.

You choices are to either use the XML API as is, use QODBC, or use the XML API and do something similar to what QODBC is doing by transforming the XML into an SQL-friendly format. I ve done something similar with my PHP code, schema and code linked below:

Answer 2

You can install QODBC, then setup a linked table in Sql Server Mgmt Studio. From there, you can more or less query the tables out of QuickBooks into tables in a SQL Svr database.

Answer 3

With QuickBooks Enterprise 2011 this changed, and you can have real ODBC access (although with limited rights and to a limited amount of tables) and then use an SQL tool to map via the ODBC access.

Answer 4

QODBC publishes data layouts for all of the tables it exposes here. The format is really nice if you want to correlate a field on the QuickBooks screen to a table, which is usually what you need in a QuickBooks integration design process.

友情链接