How to Install and Configure the QuickBooks Enterprise ODBC Driver?

how to use the ODBC Driver in QuickBooks configure and what is the way of use it?

Add Comment
2 Answer(s)

ODBC Driver is Open Database Connectivity Driver. QuickBooks provides a wide range of powerful reporting tools that can give you a better view of almost every financial aspect of your business. You may still rarely want to export data into a Microsoft Office application in order to create additional reports or data models. QuickBooks ODBC driver 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 for QuickBooks Enterprise Solutions.

let’s start to Configure the ODBC driver step by step:

  1. Open QuickBooks.
  2. Choose the File menu.
  3. Select Utilities > Set Up ODBC.
  4. Click on the General
  • Choose to Use the Company file that’s now open in QuickBooks option.
  • EnterQuickBooks Data in the Data Source Name.
  • Click on the Test Connection to QuickBooks button.
  • Important: You must be signed in to your company file as “Admin” to be able to successfully run the test connection.
  1. When the message “Test Connection to QuickBooks Successful” appears on the screen, click on OK, then select Apply.
  2. Click on the Messages
  • Clear the Detail Tracing checkbox (if enabled).
  • Choose the Display Optimizer Status Panel checkbox (if disabled).
  • Optional: To view details of what QODBC is working on, select the Display Driver Status Panel then QODBC detailed information will appear on a window above the system tray.
  • Click on Apply.
  1. Click on the Optimizer
  • Choose the Use Optimizer box (if disabled).
  • The default recommended the path of Optimizer file path is (%AppData%\QODBC Driver for QuickBooks\Optimizer).
  • Choose the start of every query (if not selected), then click on
  1. Click on OK to exit the ODBC Driver setup.

Additional Details: https://www.wizxpert.com/quickbooks-enterprise-odbc-driver/

After configuring the driver by following all these steps, you can export data to Office applications such as Access, Excel, and Word. Hope this answer will be helpful.

Answered on August 1, 2017.
Add Comment
  1. In QuickBooks, select the File menu, then choose Utilities > Set Up ODBC.
  2. Click the General tab.
    1. Select Use the Company file that’s now open in QuickBooks option.
    2. In the Data Source Name, enter QuickBooks Data.
    3. Click the Test Connection to QuickBooks button.
    4. Note: You must be signed in to your company file as “Admin” to be able to successfully run the test connection.
  3. When the message “Test Connection to QuickBooks Successful” appears, click OK, then choose Apply.
  4. Choose the Messages tab.
    1. Clear the Detail Tracing (Slow) checkbox (if enabled).
    2. Select the Display Optimizer Status Panel checkboxes (if disabled).
    3. Optional: To view details of what QODBC is working on, select the Display Driver Status Panel.
    4. 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.
    5. Click Apply.

 

  1. Click the Optimizer tab.
    1. Select the Use Optimizer box (if disabled).
    2. Default Optimizer file path is (%AppData%\QODBC Driver for QuickBooks\Optimizer). This is the recommended path to use.
    3. Select The start of every query (if not selected), then click Apply.
    4. 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.
  2. Click OK to exit the ODBC Driver setup.

 

For more detail about QuickBooks Enterprise ODBC driver then visit our online support link QuickBooks online support or Dial +1-844-551-9757. Our support team will happy to help you.

 

Answered on July 26, 2017.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.