Knowledgebase: Tutorials
[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.

Problem Description

  • How does QODBC validates all the business logic which are part of the QuickBooks application?
  • Can QODBC read or write directly to the QuickBooks company file (.QBW or . QBB)?

Solution

QODBC works as a Windows ODBC driver (DLL) to access the QuickBooks data. 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 similar 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
itself.

QODBC accepts 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 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; 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 once 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, a process for automatically start of QuickBooks, QuickBooks automatic, 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

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).