Key Details of QuickBooks ODBC Driver (32/64 bit)
- Connect ODBC-based applications to access QuickBooks cloud databases
- Last updated on 08/26/20
- There has been 1 update within the past 6 months
- The current version has 0 flags on VirusTotal
Developer’s Description
Connection to QuickBooks
Our data connector enables various ODBC-aware applications to connect to QuickBooks directly via HTTPS. If you have no direct access to QuickBooks via HTTPS, you have the option of establishing a connection through a proxy server.
Extended SQL Syntax
Our ODBC driver provides an unrivalled 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
- and many more.
Cost-Effective Deployment
Our ODBC driver is a standalone installation file that doesn’t require the user to deploy and configure any additional software such as a database client or a vendor library. Deployment costs are reduced drastically, especially when using the silent install method with an OEM license in large organizations that have hundreds of machines.
DML Operations
Devart ODBC Driver for QuickBooks provides support for DML:
- INSERT
- UPDATE
- DELETE
which allows you to modify data in QuickBooks the same way as in SQL databases.
What are some reasons to choose Devart ODBC Driver for QuickBooks?
Platforms Variety
ODBC driver for QuickBooks can be used with 32-bit and 64-bit applications on both x32 and x64 platforms, so there is no need to additionally configure the driver, applications or environment.
Integration
The driver is compatible with third-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc.
For the complete list of compatible tools and environments visit the Compatibility page.
Fully Unicode-Compliant Driver
With our fully Unicode-compliant driver, you can properly retrieve and modify any data in multilingual QuickBooks databases, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment.
Advanced Data Conversion
We have implemented advanced Data Conversion mechanisms that provide bi-directional mapping between any QuickBooks and ODBC data types.
Devart ODBC Driver for QuickBooks provides a high-performance and feature-rich connectivity solution for ODBC-compliant applications to access QuickBooks data from Windows, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your application with QuickBooks fast, easy and extremely handy. Available in both installer formats, MSI and EXE. Connection to QuickBooksOur connectivity solution enables various ODBC-aware applications to connect to QuickBooks directly via HTTPS. If you have no direct access to QuickBooks via HTTPS, you have the option of establishing a connection through a proxy server. Devart ODBC Driver for QuickBooks provides high-performance and feature-rich connectivity solution for ODBC-based applications to access QuickBooks cloud databases from Windows, both 32-bit and 64-bit. |
QuickBooks ODBC Driver (32/64 bit) Publisher’s Description
Devart ODBC Driver for QuickBooks provides high-performance and feature-rich connectivity solution for ODBC-based applications to access QuickBooks cloud databases from Windows, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with QuickBooks fast, easy and extremely handy.
Key features:
*Connection to QuickBooks
Driver provides capabilities to establish connections to QuickBooks cloud databases directly via HTTP. If you have no access to QuickBooks via HTTP directly, you have also an ability to connect via Proxy using the options: Host, Port, Username, Password.
*Extended SQL Syntax
ODBC driver provides an unrivalled 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.
*DML Operations
Devart ODBC Driver for QuickBooks provides support for DML (INSERT, UPDATE, DELETE), which allows you to modify data in QuickBooks 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
*QuickBooks Compatibility
ODBC driver has full support for QuickBooks Field data types and, moreover, the driver is compatible with the QuickBooks API itself.
*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. Thus allowing any desktop and web applications to connect to QuickBooks from various environments and platforms, that support ODBC
*Advanced Data Conversion, Fully Unicode Driver, Integration, Platforms Variety
Improved compatibility with MS Visual Studio, MS Fox Pro, MapInfo, Libre Office, Qlik, Delphi & C++Builder, MS Access.
The QuickBooks ODBC Driver is a powerful tool that allows you to connect with live data from QuickBooks directly from any applications that support ODBC connectivity. Access QuickBooks data like you would a database – read, write, and update Customers, Transactions, Invoices, Sales Receipts, etc. through a standard ODBC Driver interface.
Features
- SQL-92 access to local and remote QuickBooks company files
- Compatible with QuickBooks Premier, Professional, Enterprise, and Simple Start edition 2002+
- Supports the Canada, New Zealand, Australia, and UK editions from 2003+
- Connect to live QuickBooks Desktop data, for real-time data access
- Full support for data aggregation and complex JOINs in SQL queries
- Seamless integration with leading BI, reporting, and ETL tools and with custom applications
Specifications
- Supports 32-bit and 64-bit applications.
- ODBC 3.8 compliant native protocol based drivers.
- Comprehensive ANSI SQL-92 support.
- Full Unicode Support – any language, any data.
- Cross-platform ODBC. Available for Windows, Linux and macOS.