QODBC Driver For QuickBooks Point Of Sale
QODBC is the ODBC driver for accessing the data in QuickBooks Point Of Sale Cash Register files.
QODBC Driver for QuickBooks Point of Sale version 18 is now released.
The Read Only edition of this driver will allow applications to extract the QuickBooks POS data for better reporting and analytics while the Read/Write edition will allow applications such as MS Access, Visual Basic, FileMaker Pro, Alpha 5, etc. to push externally stored data into the POS database.
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 for QuickBooks Point of Sale?
QODBC for Point of Sale is an ODBC driver (DLL) for QuickBooks POS format files. QuickBooks Accounting stores its data in its own proprietary DBMS file format. This driver allows users of any ODBC compliant front end application to read and write data contained in QuickBooks POS format files similarly to any other ODBC enabled database.
QODBC for POS works by accepting SQL commands from applications through the ODBC interface, then converting those calls to navigational XML commands to the QuickBooks POS DBMS and returning record sets that qualify for the query results. QODBC for POS acts as a ‘wrapper’ around the Intuit SDK so customers can finally get at their QuickBooks data using standard database tools; speeding development time.
What can I do with QODBC QuickBooks Point of Sale?
QODBC for POS opens up the QuickBooks Point of Sale data files to thousands of custom programs by 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 customer or sales information directly into a spreadsheet and create a chart.
Microsoft Word can do a customer mail merge directly from QuickBooks POS data files.
Crystal Pro Report writer can create custom reports from QuickBooks POS data.
Microsoft Access or Visual Basic can be used to merge QuickBooks POS 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 POS developers now can offer this driver to their customers to allow them direct access to their important data.
The Benefits of QODBC for Point of Sale
SQL and ODBC are the corporate data access standard
No training required
ODBC level 2 support
Read-only,Read-Write and Internet versions available
Note: QuickBooks does not support writing to all areas of the accounting database, some areas are protected.
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 for POS is the solution for QuickBooks Point of Sale users and developers needing a standard way to access data in all of their applications.
Sharing Data with QuickBooks
All QuickBooks POS data elements supported by the QuickBooks SDK are supported by the QODBC Driver for read and write capability (depending on the license of QODBC purchased).
Main Benefits of this Product
QuickBooks Pro Advisors and consultants can configure reports and spreadsheets with live QuickBooks POS data for their customers, increasing billing hours. Developers can create applications which use QuickBooks POS data with ease, using the 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 POS data in their daily routine with just a few mouse clicks.
We also offer a FREE QODBC for QuickBooks Point of Sale Read-Write trial copy of the software, limited to 30 days of use. A FAQ section and a free support knowledgebase is available for those evaluating QODBC for POS. 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.
QODBC is a Windows Driver (DLL) and has the same system requirements as the QuickBooks POS Desktop version it is communicating with.
QuickBooks Point Of Sale Versions Supported
QODBC Driver for QuickBooks Point Of Sale supports USA versions of POS Version 18 (year 2018) back to Version 5
Call 248-620-2400 Business hours are from 9am to 6pm Mon-Fri. EST.