Skip to main content

Using AtScale with Google Sheets

You can connect to your AtScale models from Google Sheets with the AtScale Connector add-on.

tip

For a demo of how to connect to an AtScale model with the AtScale Connector, see the AtScale Connector - Demo video on YouTube.

Prerequisites​

This procedure assumes you have the following:

  • A deployed catalog in AtScale.
  • A Google account.

Add a client for Google Sheets​

First, you need to add a client for Google Sheets in the Identity Broker:

  1. In Design Center, in the left-side navigation, click Security. The Identity Broker opens.

  2. In the left-side navigation, click Clients.

  3. Click Create client.

  4. On the General settings tab, complete the following fields, then click Next:

    • Client type: Select OpenID Connect.
    • Client ID: Enter an ID for the client.

  5. Click Next, then click Save.

  6. Open the new client. On the Settings tab, under Access settings, edit the following fields:

    • Root URL: Enter your AtScale URL.
    • Valid redirect URIs: Enter <atscale_url>/gsheet/callback.
    • Web origins: Enter <atscale_url>/*.
    • Admin URL: Enter your AtScale URL.

  7. Under Capability config, enable the Client authentication toggle.

  8. Click Save.

Install the AtScale Connector​

Next, you must install the AtScale Connector:

  1. Go to the AtScale Connector page on the Google Workspace Marketplace.
  2. Click Install.
  3. Select the Google account you want to connect with, then click Continue.
  4. In the AtScale Connector wants to access your Google Account screen, click Allow.
  5. Click Done.

The next time you log in to Google Sheets, the AtScale Connector will appear in the Extensions menu:

The Extensions menu in Google Sheets, with the AtScale Connector option highlighted.

Next, you must connect to an AtScale model.

Connect to a model with the AtScale Connector​

To connect to an AtScale model with the AtScale Connector:

  1. Obtain the connection string for your model. You can use either of the following:

  2. In Google Sheets, open a new spreadsheet.

  3. At the top of the page, select Extensions > AtScale Connector > AtScale GSheet.

    The Extensions menu in Google Sheets, with the AtScale Connector and AtScale GSheet options highlighted.

    The AtScale GSheet panel opens.

    The AtScale GSheet panel.

  4. In the AtScale Server field, enter the connection string you want to use, then click Connect to Server.

  5. If you are not currently logged in to AtScale, sign in when prompted.

  6. In the New Pivot Table section, complete the following fields:

    • Pivot Table Name: Enter a name for your table.
    • Catalog: Select the catalog that contains the model you want to connect to.
    • Model: Select the model you want to connect to.

    The New Pivot Table section of the AtScale GSheet panel.

  7. Click Create Pivot Table.

The AtScale GSheet panel loads your model's metrics and other attributes. From here, you can create your table by clicking and dragging attributes from the list to the categories at the bottom of the panel. Click Update Table to load your changes.

The AtScale GSheet panel, populated with attributes from the connected model.