QuickBooks ODBC Driver
Read, Write, and Update QuickBooks through ODBC
Easily connect live QuickBooks Desktop data with BI, ETL, Reporting, & Custom Apps.
The ODBC Driver for QuickBooks provides a robust solution for accessing live QuickBooks data directly from any ODBC-compatible application. It enables you to treat QuickBooks data as if it were a database, allowing for reading, writing, and updating elements such as Customers, Transactions, Invoices, and Sales Receipts via a standard ODBC Driver interface.
Features
- SQL-92 access to both local and remote QuickBooks company files
- Compatible with QuickBooks Premier, Professional, Enterprise, and Simple Start editions from 2002 onwards
- Supports the Canadian, New Zealand, Australian, and UK editions starting from 2003
- Enables connection to live QuickBooks Desktop data for real-time data access
- Fully supports data aggregation and complex JOIN operations in SQL queries
- Seamless integration with top BI, reporting, and ETL tools, as well as custom applications
Specifications
- Compatible with both 32-bit and 64-bit applications.
- Drivers based on native protocol that comply with ODBC 3.8.
- Extensive support for ANSI SQL-92.
- Full support for Unicode, accommodating any language and any data.
- Cross-platform ODBC compatibility, available for Windows, Linux, and macOS.
Where can I use the Intacct ODBC Driver?
BI, ETL, & Reporting Tool Integration
ODBC is the most widely supported interface for connecting applications with data. All kinds of BI, Reporting, ETL, Database, and Analytics tools offer the ability to read and write data via ODBC connectivity.
- Cognos BI
- FileMaker Pro
- Microsoft Access
- MicroStrategy
- Power Map
- QlikView
- Sharepoint Services
- Crystal Reports
- FoxPro
- Microsoft Excel
- Oracle DB
- Power Pivot
- SAP Business Objects
- Tableau (certified)
Custom Applications
Build Apps That Connect To QuickBooks Intacct
As the most widely used interface to relational data, ODBC interfaces are accessible from every major development technology, including PHP, Python, Delphi, Visual Basic, Labview, PowerBuilder, FoxPro, FileMaker Pro, and more.
Developers can use Intacct ODBC Driver to rapidly build Web, Desktop, and Mobile applications that interact with live Sage Intacct data!
Connect Office Tools with QuickBooks Intacct
Any application that can access data through ODBC, like Microsoft Excel, PowerPivot, or Word, can leverage our ODBC Drivers to connect to real-time data.
Through the Intacct ODBC Driver applications like Microsoft Word allow users to directly access live Sage Intacct data with powerful capabilities like ‘Mail Merge’, eliminating the need for complicated import/export procedures.
Robust ODBC Access to QuickBooks Desktop
Full-featured and consistent SQL access to any supported data source through ODBC
ODBC 3.8 compliant native protocol based drivers.
Support 32-bit and 64-bit applications and unicode ODBC APIs.
Available for Microsoft Windows, Unix, and Mac (macOS / OS X) platforms.
Our drivers undergo extensive testing and are certified to be compatible with leading analytics and reporting applications like Tableau, Microsoft Excel, and many more.
Our exclusive Remoting feature allows hosting the ODBC connection on a server to enable connections from various clients on any platform (Java, .NET, C++, PHP, Python, etc.), using any standards based technology (ODBC, JDBC, etc.). ODBC Remoting is enabled using the popular MySQL and SQL (TDS) wire protocol server.
The driver includes a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.
Our drivers enhance the data source’s capabilities by additional client-side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.
The data model exposed by our ODBC Drivers can easily be customized to add or remove tables/columns, change data types, etc. without requiring a new build. These customizations are supported at runtime using human-readable schema files that are easy to edit.
Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.
Our replication and caching commands make it easy to copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands include many features that allow for intelligent incremental updates to cached data.
Traditional methods of remote access can create performance bottlenecks that may severely impact applications. Whether for internal use, commercial projects, web, or mobile applications, slow performance can quickly result in project failure. Accessing data from any remote source can cause several common issues:
- Network Connections – Mobile applications often face slow network connections and latency issues.
- Service Delays – Interruptions due to server hardware or software updates can cause delays.
- Large Data – Requests for large data volumes, whether intentional or unintentional.
- Disconnects – Complete loss of network connectivity.
The ODBC Driver for Intacct addresses these problems with smart caching technology, significantly enhancing performance and minimizing application bottlenecks.
Smart Caching
Smart caching is a configurable feature that stores queried data in a local database. When enabled, it creates a persistent local cache database that replicates the data retrieved from the remote source. This cache database is small, lightweight, and extremely fast, allowing multiple connections to share it as persistent storage.
Caching options available with our ODBC Drivers include:
- Auto Cache – Automatically maintains a local cache for all data requests. Each time a SELECT query is executed, data is loaded into the cache database, updating the corresponding table as needed.
- Explicit Cache – Developers have full control, deciding what data is cached and when it is updated using explicit CACHE statements.
- No Cache – Data is accessed live without creating a local cache file.
This caching functionality boosts application performance, allowing applications to disconnect and continue limited operations without needing additional code for local storage or data serialization/deserialization.
For more details on ODBC Driver caching and best caching practices, consult the included help files.
MySQL/SQL Database Access for Sage Intacct Data
The ODBC drivers provide powerful, fully-integrated remote access capabilities, making Sage Intacct data accessible from virtually any location. These drivers include the SQL Gateway, which has the optional ability to accept incoming SQL and MySQL client connections and handle standard database requests.Versatile Access with the ODBC SQL Gateway
With the SQL Gateway, users can interact with Sage Intacct data from any client that supports SQL Server or MySQL. This includes web and mobile applications, CRM and CMS systems, BI tools like SQL Server Analysis Services, and popular management tools like MySQL Workbench. Essentially, any application capable of accessing external data can connect to Sage Intacct using this driver.Integration with BI Tools
Connect Sage Intacct data with popular business intelligence tools, such as SQL Server Analysis Services, to enable in-depth analysis and reporting.Enterprise Integration
Facilitate enterprise-level Sage Intacct data integration through SQL Linked Server connectivity, ensuring smooth data operations across systems.Support for MySQL and SQL (TDS) Protocols
The driver supports the MySQL and SQL (TDS) remote access protocols, along with advanced SSL security—industry-standard protocols for secure remote database connectivity.Code Integration
Easily connect to Sage Intacct from programming languages like PHP, Python, Ruby, Objective-C, and more using standard client libraries designed for SQL/MySQL access.
Frequently Asked QuickBooks ODBC Driver Questions
Learn more about QuickBooks ODBC drivers for data and analytics integration
QuickBooks does not offer native ODBC support. However, a third-party ODBC driver is available that enables connection to QuickBooks data from any ODBC-compliant application, similar to accessing a traditional database. This facilitates:
- Accessing QuickBooks data from applications like Microsoft Excel, Tableau, Power BI, and others.
- Working with live QuickBooks data for real-time reporting and analysis.
- Building data integrations between QuickBooks and other systems.
This third-party ODBC driver is compliant with ODBC 3.8 and supports ANSI SQL-92, allowing almost any ODBC-capable application to integrate in real-time. A fully functional trial version of the driver is available for download.
Yes, an ODBC driver for Sage Intacct is available, offering universal ODBC data connectivity for the platform. This driver provides a simple SQL-based abstraction layer, making real-time data access easier for users and applications. It allows communication with Sage Intacct using a standardized set of functions, enabling integration with virtually any application across platforms, including Windows, macOS, or Linux.
Yes, there is an ODBC driver that provides universal data connectivity for QuickBooks, simplifying real-time data access through a SQL-based layer. This driver ensures that nearly any application across different platforms such as Windows, macOS, or Unix can integrate with QuickBooks in real-time.
To connect to QuickBooks via ODBC, first download and install the ODBC driver suitable for your platform. Post-installation, detailed documentation is available providing instructions for creating a DSN and connecting to QuickBooks, along with comprehensive configuration details for integration with various applications and development tools.
The ODBC drivers, including the one for QuickBooks, are available for download online. Start with a free trial download of the QuickBooks ODBC driver.
Download the QuickBooks ODBC driver installer from the online platform. Select the appropriate installer for your operating system. The installer will setup all necessary components for using the driver on your system.
The QuickBooks ODBC driver comes in both 32-bit and 64-bit versions. During installation, you can choose the appropriate binary for your system.
Yes, the QuickBooks ODBC driver supports pyODBC connectivity. Additionally, native Python data connectivity solutions for QuickBooks are also available, enhancing integration capabilities.