This page outlines the steps to install and configure the CData Connect Cloud connector for Looker Studio. After installation, Looker Studio will be able to pull data from sources that you have connected to your CData Connect Cloud account.

Note: Before you can configure and use Looker Studio with CData Connect Cloud, you must first connect a data source to your CData Connect Cloud account. See Connections for more information.

1. Sign in to Looker Studio using your Google account.

2. Click here to search for the CData Connect Cloud connector.
   Alternatively, from the Looker Studio dashboard, click + Create, then click Data Source and search for CData Connect Cloud.

3. Click CData Connect Cloud to install the connector.

4. When prompted, click Authorize to allow Looker Studio to use the connector.

5. Another Authorize button appears to connect to CData Connect Cloud. Click this to open a login window.

6. Enter your CData Connect Cloud login credentials and click Continue.

7. Close the authorization window when prompted.

8. Open the Connection drop-down menu, select a connection, and click Next.

   

9. Use the Table drop-down menu to select the table you want to import.

10. (Optional) By default, all data in the table will be imported. If you want to use a custom query for the data instead of retrieving all data, check the Use custom query box and enter the parameters in the Custom Query box.

    

11. (Optional) If you want to use the current user’s email within a custom query, use the parameter token @DS_USER_EMAIL in the query, as follows:

    Select * from Sales WHERE sales-rep-email = @DS_USER_EMAIL;

    CData Connect Cloud replaces the parameter with the current user’s email address.

12. Click Connect in the top-right corner of the page. Looker Studio opens an overview of the imported data.

    

You can now sort, filter, and explore your data and generate reports. For more information about using Looker Studio, please see Google’s help topics.