Configure the CData Cloud Add-On for Google Sheets

Google Sheets allows you to create branded reports with data visualizations to share with your clients. When paired with CData Cloud, you get instant, cloud-to-cloud access to data from the supported SaaS, Big Data and NoSQL sources for visualizations, dashboards, and more. This article shows how to use the CData Cloud Add-On to connect to your CData Cloud instance from Google Sheets.

CData Cloud provides a live cloud-to-cloud interface for all of your data, allowing you to easily build reports from live SaaS, Big Data and NoSQL sources in Google Sheets. As you work with data, Google Sheets generates queries to gather data. Using optimized data processing out of the box, CData Cloud pushes all supported complexities (filters, JOINs, etc) directly to the underlying data source, leveraging server-side processing to quickly return the requested data.

User Guide

The CData Cloud Add-On gives you the ability to connect directly data to Google Sheets through CData Cloud.

Grant Access

Before using CData Cloud Add-On, you will need to grant access to your Google Account. If you see this prompt, please click "Allow".

Connect to CData Cloud

You will need your account name, username, and password to establish a connection to CData Cloud. The account name for your CData Cloud instance is found on the Clients page.

CData Cloud Users are created on the Users page.

Set Path to your account name and set Username and Password to the credentials for a CData Cloud user for your instance with appropriate roles and privileges to access the desired data. Click "CONNECT"

Select a Connection

After you've successfully established the connection to CData Cloud, click the "CREATE" button to import data.

Select a Connection you want to use.

Select a Table

After selecting a Connection, select a Table and select Columns. Alternatively, you can build a Custom SQL Query.

Modify the Query

After selecting a Table and Column(s), you can modify the query by adding filters, sorting, and by setting a limit. Once the query is complete, click "EXECUTE" to import data into the Google Sheet.

Explore the Data

Now you have imported data into your Google Sheet via CData Cloud and can work with it like any other Google Sheet, performing analytics, creating charts, and more.


If you have any questions regarding the usage of the CData Cloud Add-On for Google Sheets, please view our Support Page.


Terms of Use
Privacy Statement