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

The CData Cloud Hub 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 SQL queries to gather data. Using optimized data processing out of the box, the CData Cloud Hub pushes all supported SQL operations (filters, JOINs, etc) directly to the underlying data source, leveraging server-side processing to quickly return the requested data.

User Guide

The CData Cloud Hub Connector gives you the ability to connect directly data to Google Data Studio through the CData Cloud Hub.

Grant Access

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

Connect to the Cloud Hub

You will need your instance name, username, and password to establish a connection to the Cloud Hub. Your instance name is found in the web UI address or MySQL/SQL Server host address for your Cloud Hub instance. For example, if your web UI address is https://www.cdatacloud.net/my_instance and MySQL/SQL Server host address is my_instance.cdatacloud.net, your instance name is my_instance.

Set username and password to the credentials for a Cloud Hub user for your instance with appropriate roles and privileges to access the desired data.

When finished setting up credentials in the Cloud Hub, enter your credentials information in the connector authentication panel.

The format for Username here should be [instance name]/[user name]. For example, if your instance name is ustest1, and you have the user admin set in the Cloud Hub, you should enter ustest1/admin. Password is be the user's password.

When you finish entering the information, click "SUBMIT."

Select a Database

After you've successfully established the connection, select a database 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 Cloud Hub Connector for Google Data Studio, please view our Support Page.

Links

Terms of Use
Privacy Statement