Learn how to install and set up the QuickBooks Desktop Enterprise ODBC Driver.
The QuickBooks Open Database Connectivity (ODBC) driver from FLEXQuarters allows you to export data from your company file so you can create custom reports. Once you export a report, you can view it in programs like Microsoft Excel, Crystal Reports, QlikView, Python, or .Net. Here’s what to do.
- How to download and install the ODBC driver
- Run the file you just downloaded and follow the onscreen instructions
- In QuickBooks, go to File then Utilities, then select Configure ODBC.
- Go to the General tab.
- Select Use the Company file that's now open in QuickBooks.
- In the Data Source Name, enter QuickBooks Data.
- Select Test Connection to QuickBooks. Note: You must be signed in to your company file as "Admin" to be able to run the test connection.
- When you see Test Connection to QuickBooks Successful, select OK, then select Apply.
- Go to the Messages tab.
- Clear the Detail Tracing (Slow) checkbox.
- Select the Display Optimizer Status Panel checkbox.
- (Optional) To view details of what ODBC is working on, select Display Driver Status Panel. This will show the number of records processed and the current running activity in ODBC. It’ll also provide assessment of speed using optimized and non-optimized data, which will let you know if troubleshooting steps for the software's performance need to be done.
- Select Apply.
- Go to the Optimizer tab.
- Select the Use Optimizer checkbox.
- Default Optimizer file path is (%AppData%\ODBC Driver for QuickBooks\Optimizer). This is the recommended path to use.
- Select The start of every query, then select Apply. Note: The initial optimization time may vary depending on the file size. It usually takes 24 hours. The more transactions are made, the longer optimization will take. Once completed, data connections with QuickBooks will run faster.
- Select OK to exit the Configure ODBC Driver window.
The read-only ODBC driver is provided for QuickBooks Desktop Enterprise 8.0 and later. Need to write back into QuickBooks Desktop Enterprise? Here’s how to upgrade to the Read/Write version of the ODBC driver.
How to set up the ODBC driver
Here’s how to set up the ODBC driver and for retrieving your data with 3rd party ODBC compliant applications (e.g. Microsoft Excel, Access or Crystal Reports).
- View Setup Instructions for ODBC Driver
- View Setup Instructions for 3rd Party ODBC Compliant Applications
How to use the ODBC driver
Here’s how to use the ODBC driver and data schema.
For help with OBDC, contact FLEXquarters or QuickBooks Support.
Note: Report writing services are not provided for 3rd party applications (e.g. Microsoft Excel, Access or Crystal Reports). If you have any connection errors, here’s what to do.