Connect/Disconnect the QuickBooks Online Products

In this entry you will learn to use the CData Excel Add-In for QuickBooks Online or the CData Sync Application for QuickBooks Online to connect to or disconnect from your QuickBooks Online data.

Date Entered: 3/21/2016    Last Updated: 7/27/2016

It is worth noting that the CData Excel Add-In and Sync Application for QuickBooks Online do not establish a true persistent connection, but instead perform the OAuth flow as defined by QuickBooks Online and securely stores the relevant credentials on your machine. These credentials are encrypted and can be generated or removed using the steps described below.



CData Excel Add-In

Connect to QuickBooks Online

To connect the CData Excel Add-In for QuickBooks Online to your QuickBooks Online data, you can do the following:

  1. Open Excel and click on the "CDATA" ribbon.
  2. Click on the "From QuickBooks Online" button.
  3. Create a new connection or edit the existing connection.
  4. Click "Connect" and follow the instructions on the web page that opens.
You are now connected to your QuickBooks Online data!

Disconnect from QuickBooks Online

To disconnect the CData Excel Add-In for QuickBooks Online from your QuickBooks Online data, you can do the following:

  1. Open Excel and click on the "CDATA" ribbon.
  2. Click on the "From QuickBooks Online" button.
  3. Edit the existing connection.
  4. Click "Disconnect" and the relevant OAuth credentials will be removed, disabling the connection to QuickBooks Online.
You are now disconnected from your QuickBooks Online data!



CData Sync Application

Connect to QuickBooks Online

To connect the CData Sync Application for QuickBooks Online to your QuickBooks Online data, you can do the following:

  1. Open the Sync Application and click on the Connection tab.
  2. Click "Connect" and follow follow the instructions on the web page that opens.
You are now connected to your QuickBooks Online data!

Disconnect from QuickBooks Online

To disconnect the CData Excel Add-In for QuickBooks Online from your QuickBooks Online data, you can do the following:

  1. Open the Sync Application and click on the Connection tab.
  2. Click "Disconnect" and the relevant OAuth credentials will be removed, disabling the connection to QuickBooks Online.
You are now disconnected from your QuickBooks Online data!


We appreciate your feedback.  If you have any questions, comments, or suggestions about this entry, please contact our support team at support@cdata.com.