Page Comparison

Canvas Sigma enables the users to connect with the Google sheet data using Connectors in Canvas Sigma Studio.

Prerequisites
To create Google sheet connections, make sure that the provided GSheet_jars folder is present within the ModelHouse Sigma and the Studio war.

Sample File Location for Canvas Sigma Studio in Tomcat Server:
<Tomcat-Installed-Folder> \webapps\expertctstudio\WEB-INF\lib
Sample File Location for ModelHouse Sigma in Tomcat Server:
<Tomcat-Installed-Folder> \webapps\modelhouse\WEB-INF\lib

...

1. Go to the following URL link:
   https://console.developers.google.com
   
    
2. Click Enable APIS and Services.
   
   
3. Search for Google Sheets API in the search box and select it.
   
   
4. Click Manage.
   
   
5. Click Credentials option from the menu on the left-hand side of the page.
   
   
   
6. Click Create Credentials and select OAuth Client ID from the drop-down list.
   
   
7. Click the Application Type drop-down and select Web Application.
   
   
8. Enter the web application name in Name field. Here, Web client is provided as the name.
   
   
9. Click ADD URI in Authorized JavaScript origins field and provide https://console.developers.google.com as the URI.
   
   
10. Click ADD URI in Authorized redirect URIs field and provide https://developers.google.com/oauthplayground as the URI.
    
    
11. Click Create.
    
    
12. Make note of the Client ID and the Client Secret information from the pop up that appears once the OAuth client is created.

...

Perform the following steps in order to create a connection and a datasource for the Google sheet:

1. In Canvas Sigma Studio, click Create > ConnectorsManage > Connection.
   Image Removed
   Image Added
   The Connectors Create New Connection page appears as shown in the following screenshot:
   Image Removed
   Image Added
2. Click OTHERS and select the Google Sheets.
   Image Removed
   Image Added
3. Enter a unique name for the connection in the Connection Name field.
4. Provide the obtained client ID in Client ID field.
5. Enter the obtained client secret in Client Secret field.
6. Similarly, provide the access and the refresh tokens in their respective fieldsthe Access Token and Refresh Token fields respectively.
   Image Removed
   Image Added
7. Image Removed

   Click Submit to save the connection.

   
   

   
   

   Warning
   When you try to exit the Connectors screen, before saving the configured Google Sheets connection, a warning pop-up message appears, as shown in the following screen shot: Image Added Click Cancel, if you do not want to exit the Connectors screen. Click Ok, if you want to exit the Connectors screen.

   
   
   Image Added
   A success message for creating a connection appears as shown in the following screenshot:
   

   Image Removed

   
   Image Added

8. Click Ok.
9. Now, right-click the created connection and select Create Data Source.
   Image RemovedClick the Data Source Image Added icon on the existing Google Sheets connection.
   
   Image Added
   The Create Request page appears.
   Image Removed
   Image Added
10. In the Create Request page, enter a unique data source name in the Data Source Name field.
    Image Removed
    Image Added

11. Provide the Google spread sheet ID in Spreadsheet ID field.
    Image Removed
    Image Added

    Note
    You can identify the spread sheet ID from your Google sheet URL.

    
    

12. Provide the spread sheet range in Range field.
    Image Removed
    Image Added

13. Enter the column name and its ID on the Column Name and Column ID field. Here, Name and Task is  are provided as the column name Column Name and column Column ID.
    Image Removed
    Image Added

    Note
    Click plus ( Image Removed Image Added ) icon to add column(s) and minus ( Image Removed Image Added ) icon to delete the column(s).

    
    

14.  Click Save.
    

    Warning
    When you try to exit the Data Source screen, before saving the configured Google Sheets data source, a warning pop-up message appears, as shown in the following screen shot: Image Added Click Cancel, if you do not want to exit the Data Source screen. Click Ok, if you want to exit the Data Source screen.

    
    
    Image Added
    A success message for creating a datasource appears as shown in the following screenshot:
    

    Image Removed

    
    Image Added

15. Click Ok.