Configure the CData 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 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 Partner Connector to connect to your CData Cloud instance from Google Data Studio.

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 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 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 Partner Connector gives you the ability to connect directly data to Google Data Studio through CData Cloud.

Grant Access

Before using CData Cloud Partner Connector, 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 "SUBMIT."

Select a Connection

After you've successfully established the connection to CData Cloud, select a Connection you want to use and click "NEXT."

Select a Table

Then, select a table, and click "NEXT."

Explore the Data

If you see the message "Click "CONNECT" to continue," it means the configuration information is correct. You can hit the "CONNECT" button at the top right of the screen. You should not modify any configuration information at this time, or it may cause a connection error.

At this step, you can set the fields and their metadata. Common data types are automatically detected, but you can also 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 Cloud Partner Connector for Google Data Studio, please view our Support Page.

Links