Quickbooks SQL dump Code from QODBC

Question

Hello, 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:

• MySQL Schema
• QuickBooks PHP Framework

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.