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.
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.
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.
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.
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.
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).
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.
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.
Minimum CPU required: Pentium II processor 450 MHz or better
Minimum memory required: 64 MB
Minimum hard disk space required: 15 MB
Operating system version: Windows 98SE/2000/ME/NT 4.0/XP/Vista/Win7/Win8
QODBC Driver for QuickBooks Point Of Sale supports USA versions of POS 2013 back to v5.
Call 248-620-2400. Business hours are from 9am to 6pm Mon-Fri. EST.