ODBC Driver for QuickBooks

ODBC Driver for QuickBooks is a connector that enables users to establish connections between ODBC-based applications and QuickBooks cloud databases from Windows. It features support for both 32- and 64-bit systems. .NET Framework is required for this driver to run as intended.

All standard ODBC API functions and data types are supported and implemented in the driver. This driver can help users connect to their cloud databases directly via HTTPS. It is also possible to connect via Proxy by providing the Username, Password, Host and Port parameters in case users can't access QuickBooks via HTTPS.

Users can handle QuickBooks objects in a similar manner to SQL tables. There is a wide variety of SQL-92 compatible SELECT statements such as ORDER statements, subqueries, GROUP statements, complex JOINs, aggregation functions and WHERE conditions.

DML (Data Manipulation Language) support is also a feature of ODBC Driver for QuickBooks. This makes it possible for users to modify data in QuickBooks databases in a similar manner to SQL databases with "INSERT," "UPDATE" and "DELETE" commands.

The driver is capable of performing bulk QuickBooks updates by bundling SQL statements into batches, saving precious time spent manually processing each command. Common ODBC interface is fully supported, making any ODBC-friendly web or desktop application able to connect to QuickBooks.