How to create or configure a QODBC Online DSN

Problem Description:

I have one QuickBooks Online login, which provides access to multiple QuickBooks Online companies.

When I initially configured the connection, I selected one of the clients to that I have access (Company A). The connection worked great, and I got the data I needed. Now I want to export data for another client of mine (Company B), but I'm unsure how to reconfigure it to pull from their database, not Company A's. 

Solution:

You can create a new DSN company-wise & authorize your company file and use it in your configuration.

For Example, Create New DSN for Company A & use Company A's DSN for accessing Company A's data.

In the same way, you can create DSN for Company B & use Company B's DSN to access Company B's data.

You can repeat this for multiple company files.

Please refer to the below example, which shows creating QODBC Online DSN company-wise.

Launch QODBC Online Data Source Configuration

      Locate the QODBC Driver for the QuickBooks Online program group on your desktop. Click on the Configure QODBC Online Data Source icon to create or configure a QODBC Online Data Source Name (DSN).

Create a New DSN

      Click on the System DSN tab to create a DSN that both Windows applications and services can call. Click on the Add button to create a new DSN.

       Select the QODBC Driver for QuickBooks Online option and click on the Finish button.

Configure the Created DSN

      Enter the Data Source Name as CompanyA and click Apply.

Click Connect To QuickBooks

You need to authorize your company file to work with QODBC Online.

During the authorization, select your Company file. 

For more details, please refer to How to Connect QODBC Online with QuickBooks Online Edition.

Once connected, You can use Excel or Access or QODBC Online Test Tool or any other application, and use "CompanyA" instead of "QuickBooks Online Data." You should be able to connect and fetch data from QuickBooks Online.

You can repeat the above steps for another company file (i.e., CompanyB, CompanyC, etc..).

Tags: QuickBooks Online, QBO, Configure online DSN, QODBC Online, connect company files, multiple