Configure the CData Connect Cloud Partner Connector for Google Data Studio

Google Data Studio allows you to create branded reports with data visualizations to share with your clients. When paired with CData Connect 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 Connect Cloud Partner Connector to connect to your CData Connect Cloud instance from Google Data Studio.

CData Connect 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 Data Studio — without replicating the data to a natively supported database. As you build visualizations, Google Data Studio generates queries to gather data. Using optimized data processing out of the box, CData Connect 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 Connect Cloud Partner Connector gives you the ability to connect directly data to Google Data Studio through CData Connect Cloud.

Grant Access

Install the Add-On

Before using the CData Connect Cloud Connector, you need to install the Connector to your Google Account.

1. Navigate to the Clients page in CData Connect Cloud and click on Google Data Studio.
2. Click the CData Connect Cloud Partner Connector in the Data Studio page that opens.
3. Click Authorize and allow access to your Google account.

Connect to CData Connect Cloud

Once the Connector is authorized, you can access your CData Connect Cloud instance from within Google Data Studio.

1. Click Authorize to authenticate with your CData Connect Cloud instance

Connect to External Cloud Data

With the Add-On authorized, you are ready to connect to external cloud data from Google Data Studio.

1. In the CData Connect Cloud Connector in Google Data Studio select a Connection and click Next
2. Select a Table (or use a Custom Query) and click Connect to continue

Explore the Data

After selecting a Connection and Table, you can select and modify the fields and their metadata. Common data types are automatically detected, but you can change them to something else. When you are content with the schema, you can start generating your report.

Support

If you have any questions regarding the usage of the CData Connect Cloud Partner Connector for Google Data Studio, please view our Support Page.

Links