QuickBooks Enterprise - What database does it use under the hood?

Question

The documentation makes note of a SQL database and database server. Is it a standard database, or a custom DB made by intuit? If it's a standard DB, what database and version?

Is it possible to connect to the database directly with a 3rd party application?

Answer 1

Company file is a sybase file. Using API, you can interact with the company file ( that is what we call sync)

Sync - [You App -> IDS Cloud -> Company File -> Upload data in persistent storage(cloud)]

Ref - https://developer.intuit.com/docs/0025_quickbooksapi/0050_data_services/v2/0500_quickbooks_windows/0400_data_synchronization

https://developer.intuit.com/docs/0025_quickbooksapi/0050_data_services/v2/0500_quickbooks_windows/0300_sync_manager

Thanks

Answer 2

No, you cannot connect directly to the underlying database.