How to install and configure the QuickBooks Enterprise ODBC Driver
QODBC driver for QuickBooks Enterprise Solutions allows you to export data from your company file to programs like Microsoft Excel, Microsoft Access, Crystal Reports, Filemaker, Alpha, QlikView, Python, or .Net. to create custom reports.
How to Configure the ODBC driver
In QuickBooks, select File then Utilities > Set Up ODBC.
Go to the General tab.
Select Use the Company file that's now open in QuickBooks option.
In the Data Source Name, enter QuickBooks Data.
Click the Test Connection to QuickBooks button. Note: You must be signed in to your company file as "Admin" to be able to successfully run the test connection.
When the message "Test Connection to QuickBooks Successful" appears, click OK, then choose Apply.
Go to the Messages tab.
Clear the Detail Tracing (Slow) checkbox (if enabled).
Select the Display Optimizer Status Panel checkboxes (if disabled).
(Optional) To view details of what QODBC is working on, select the Display Driver Status Panel. Note: When selected, QODBC detailed information will appear on a window above the system tray. This will show information such as the number of records processed and the current running activity in QODBC. It will also provide assessment of speed using optimized and non-optimized data, which will serve as an indicator if troubleshooting steps for the software's performance need to be done.
Go to the Optimizer tab.
Select the Use Optimizer box (if disabled).
Default Optimizer file path is (%AppData%\QODBC Driver for QuickBooks\Optimizer). This is the recommended path to use.
Select The start of every query (if not selected), then click Apply. Note: 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.