[QODBC ALL] How QODBC talks to QuickBooks SDK to get safe/encrypted/balanced data from QuickBooks preventing data corruption.
Posted by Rajendra Dewani (QODBC Support) on 17 September 2018 01:47 PM
How QODBC talks to QuickBooks SDK to get safe/encrypted/balanced data from QuickBooks preventing data corruption.
QODBC works as a Windows ODBC driver (DLL) for accessing the data contained in QuickBooks. QuickBooks Accounting stores its data in its own proprietary encrypted file system.
Due to the nature of accounting systems, balancing, and transaction integrity, the QuickBooks system prevents all external applications from directly accessing the data files used by QuickBooks, however, Intuit created a workaround called the QuickBooks SDK (software development kit) which resides inside the QuickBooks application interface.
QODBC allows users of any ODBC compliant front-end application to read and write data contained in the QuickBooks system similarly to any other ODBC enabled database by processing commands via the QuickBooks SDK interface in the desktop application, so QODBC will not run if QuickBooks is not installed on the same machine or a connected machine (see: QRemote) because the SDK resides in the application
QODBC works by accepting SQL (structured query language) commands from applications through the ODBC interface, then converts those calls to navigational XML commands, passing them to the QuickBooks SDK for processing and then returning recordsets that qualify for the query results.
This driver is not a Client/Server product, or a direct database access tool because that method is prohibited by Intuit, but rather communicates directly with the QuickBooks application as it runs.
QuickBooks is a flat file database, and this driver will not change it into a relational database, so keep that in mind when developing with this driver.
QODBC acts as a 'wrapper' around the Intuit SDK so customers can finally get at their QuickBooks data using standard database tools; speeding development time.
QODBC does not write to the QuickBooks company file directly, QODBC is writing through the QuickBooks SDK, which follows all business rules & validation.
Note: QuickBooks requires you to approve the security settings for QODBC to allow it to access the data in QuickBooks one time for each application/company file combination. After this step, the connection to data in QuickBooks can be fully automated and not require user input.
Tags : QuickBooks start, QuickBooks autostart, QuickBooks startup, QuickBooks connect, Hidden QuickBooks,Quiet QuickBooks, Silent QuickBooks, Background QuickBooks, How to setup QODBC for Auto-login into QuickBooks, process for automatically start of QuickBooks, QuickBooks auto matic, automatic quick books, autostart QuickBooks,automatically start of Quickbooks, running QuickBooks automatic, autologin, Connection to data does not work unless Quickbooks is running even though I have that option turned on in the QODBC control panel, how to run without QuickBooks