QODBC Driver Version 2020 for QuickBooks Online
QODBC is the ODBC driver for accessing the data in QuickBooks Online Accounting files.
QODBC is a fully functional ODBC driver for reading and writing QuickBooks Online Edition accounting data files by using standard SQL queries from your PC. It requires an ODBC compliant front-end application such as Microsoft Word, Microsoft Excel, Microsoft Access, Visual Basic, PowerBuilder or Delphi. Once installed, it will allow these applications to read and write QuickBooks Accounting files in the same fashion as other file formats installed on your computer. Using the official QuickBooks Online API (developers kit), we are able to offer our customers total compatibility with all QuickBooks Online file formats.
What is ODBC?
ODBC (Open Data Base Connectivity) is a specification designed by Microsoft to allow Windows applications to access multiple database systems through a single method with no regard for various file formats. SQL (Structured Query Language) is used as the method for accessing data through ODBC. Vendors of ODBC drivers (like this one) follow the specifications for ODBC so that any ODBC compliant application can access the data available through the driver. ODBC compliant applications include: Microsoft Access, Word, Excel, PowerBuilder, Borland Delphi, Crystal Pro Report Writer, Visual Basic and hundreds of others. Users of these applications do not need to learn SQL language to access these database files, they are simply presented on the desktop for the user to manipulate with wizards and icons.
What is QODBC?
QODBC is an ODBC driver (DLL) for QuickBooks Online Accounting format files. QuickBooks Online Accounting stores it’s data in it’s own proprietary file format in the cloud. This driver allows users of any ODBC compliant front end PC application to read and write data contained in QuickBooks Accounting database file similarly to any other ODBC enabled database and the same as our product for Desktop QuickBooks.
QODBC works by accepting SQL commands from applications through the ODBC interface, then converting those calls to navigational XML commands to the QuickBooks Online Accounting system and returning record sets that qualify for the query results. This driver is not a Client/Server product, but rather communicates directly with the QuickBooks Online web site as it runs. QuickBooks Online 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 API (developers kit) so customers can finally get at their QuickBooks Online data using standard database tools; speeding development time by using SQL commands rather than learning the complexities of the API.
What can I do with QODBC?
QODBC opens up the QuickBooks Online Accounting files created by thousands of custom programs to the new world of database connectivity. In the same way that Windows has created an environment where all applications have a similar look and feel, ODBC drivers make all database formats look the same.
- A user in Microsoft Office can use Excel to pull company accounting or invoice information directly into a spreadsheet and create a chart.
- Microsoft Word can do a customer mail merge directly from QuickBooks Online Accounting files.
- Crystal Pro Report writer can create multi-file reports from QuickBooks Online Accounting data.
- Microsoft Access or Borland Delphi can be used to merge QuickBooks Online Accounting data with other data sources to produce complex reports, or to run mass file updates based on multiple criteria.
Best of all, this driver is transparent and works in exactly the same fashion of ODBC drivers from other vendors. QuickBooks Accounting developers now can offer this driver to their customers to allow them direct access to their important data.
The Benefits of QODBC
- SQL and ODBC are the corporate data access standard
- Quick installation
- No training required
- Transparent operation
- ODBC level 2 support
- Read-only, Read-Write and Internet versions available
Note: QuickBooks Online Edition does not make all areas of the accounting database available through their API (developers kit).
Today’s end users are extremely sophisticated, requiring up-to-the-minute data to make a significant number of business decisions. Business people cannot afford to wait for their computer departments or CPA’s to service a request for accounting data. The data must be available on the desktop instantly. ODBC is the solution for all Windows applications, and QODBC is the solution for QuickBooks Accounting users and developers needing a standard way to access data in all of their applications.
Sharing Data with QuickBooks
All QuickBooks Online data elements supported by the QuickBooks API with Read and/or Write capabilities are supported by the QODBC Driver for QuickBooks Online.
Main Benefits of this Product
QuickBooks Pro Advisors and consultants can configure reports and spreadsheets with live QuickBooks Online data for their customers, increasing billing hours. Developers can create applications which use QuickBooks Online data with ease, using QuickBooks Online data via existing ODBC data controls and methods. End user customers can use wizards and mail merge capabilities in Windows standard applications to merge QuickBooks Online data in their daily routine with just a few mouse clicks.
Free Evaluation Version
We also offer a FREE QODBC trial copy of the software for download, the only limitations being 30 days of use and 20 write operations into QuickBooks per session.
A FAQ section and a free support knowledgebase is available for those evaluating QODBC. All customers can obtain free technical support via our Support Ticket System. Program anomalies will be addressed at no charge and updaters posted on our web site. Support issues specific to your application or requirements may be subject to a $75 per incident consulting fee.
Windows 7 SP1, Windows Server 2008 R2 SP1 (or above), Windows 8, Windows 8.1 and Windows 10.
QuickBooks Online Editions Supported
QODBC Driver for QuickBooks Online supports QuickBooks Online Simple Start, Essentials, Plus, and Advanced Editions.