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

database intuit-partner-platform ipp-qbd-sync
Brian picture Brian · Sep 20, 2013 · Viewed 9.1k times · Source

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

Manas Mukherjee picture Manas Mukherjee · Sep 20, 2013

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

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More