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

...

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

1. In Canvas Sigma Studio, click Create > Manage > Connectors.
   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. Click Submit to save the connection.
   Image Removed
   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 the Create Data SourceSource option.
   Image Removed
   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.
    
    Image Added
    A success message for creating a datasource appears as shown in the following screenshot:
    Image Removed
    Image Added
15. Click Ok.