Devart ODBC Driver for QuickBooks is a high-performance connectivity tool with enterprise-level features for accessing QuickBooks from ODBC-compliant reporting, analytics, BI, and ETL tools on 32-bit and 64-bit Windows. Our ODBC driver fully supports standard ODBC API functions and data types and enables easy access to live QuickBooks data from anywhere.
Key features:
* Connection to QuickBooks
Our connectivity solution enables various ODBC-aware applications to connect to QuickBooks directly via HTTPS. If you have no direct access to QuickBooks, you have the option of establishing a connection through a proxy server.
* Extended SQL Syntax
Our ODBC driver provides an unrivaled opportunity to work with QuickBooks objects just as with SQL tables. The extended SQL syntax allows you to use all the SQL benefits in SQL-92 compatible SELECT statements:
- Complex JOINs
- WHERE conditions
- Subqueries
- GROUP statements
- Aggregation functions
- ORDER statements, etc.
* DML Operations
Devart ODBC Driver for QuickBooks provides support for DML (INSERT, UPDATE, DELETE) operations, which allows you to modify data in QuickBooks in the same way as in SQL databases.
* Bulk Updates
Moreover, with our driver you can perform bulk updates to QuickBooks by combining SQL statements into batches, thus simplifying and speeding up large data modification with QuickBooks.
* ODBC Conformance
The driver provides full support for common ODBC interface:
- ODBC API Functions support
- ODBC Data Types support
In addition, we provide support for Advanced Connection String parameters.
* QuickBooks Compatibility
Our ODBC driver fully supports all data types defined in the QuickBooks API.
Moreover, the driver is compatible with the QuickBooks API itself.
You can always find the latest version of the product on the official Devart website.
Comments