Help & Documentation
Open Support Ticket

Sync Tableau User/Group Permissions with Metric Insights by Using Custom Script

There's a possibility to synchronize content access in Tableau with Tableau content that exists in Metric Insights by running a Custom Script. This way, users/groups who have access to content in Tableau will be given access to the same content in Metric Insights, provided that content is recreated in the system.

The high-level procedure is comprised of the following steps:

  1. Add New Autoimport
  2. Give the Workbook a Name target="_self" data-internal-anchor="">Add New Autoimport
  3. Select Location target="_self" data-internal-anchor="">Add New Autoimportto publish
  4. IMPORTANT: target="_self" data-internal-anchor="">Add New Autoimport Enable Embed password for data source target="_self" data-internal-anchor="">Add New Autoimport
  5. [Publish] target=" _self"="" data-internal-anchor="">Add New Autoimport

4. Create Permissions Dataset

Access +New > Dataset > Create Dataset

  1. Input a descriptive phrase in Name
  2. Specify Category to place the Dataset 
  3. Select the Tableau Data Source for which you want to sync Permissions
  4. Specify Data collection trigger that will be used to collect data for Dataset
  5. Select the Tableau Worksheet that that you have previously Dataset > Create Dataset

  1. Input a descriptive phrase in Name
  2. Specify Category to place the Dataset 
  3. Select "Dashboard DB" as Data Source
  4. Specify Data collection trigger that will be used to collect data for Dataset
  5. Input the custom SQL statement from the attachment below, where:
    • dashboard_dataset.dataset = Dataset ID from Step 4
  6. [Validate]

Note the Dataset ID to be used at Step 6.2.

attachment SQL_statement.txt

6. Configure Custom Script

NOTE: The Custom Script file must be requested at support@metricinsights.com.

  1. Enable the Custom Script
  2. Set Custom Script is to "enabled"
  3. Choose External Application
  4. Set Are Parameters Required to "Yes"

6.1. Add Parameters

Add Parameters according to the list specified in the Custom Script file (requested from our support).

6.2. Add Parameter Set

  1. [+Add Parameter Set]
  2. Input a descriptive phrase in Parameter Set Name
  3. Enter the Dataset ID from Step 5 in masterElementsDatasetID
  4. [Save]

6.3. Insert Script

  1. Insert the Custom Script from the file (requested from our support) under the Editor Tab
  2. [Run Script] to verify it executes successfully. This will also save your changes.

7. Create Notification Schedule for Custom Script

Access Admin > Distribution > Notification Schedules > [+New Notification Schedule]

  1. Set Frequency to "on certain days of the week".
    • It is recommended to set the Schedule to be executed daily, but you can choose your own frequency.
  2. Provide a descriptive Schedule name
  3. Set Notification Schedule is to "enabled"

7.1. Associate Script with Notification Schedule

  1. Under Run Scripts, click [+Add Script]
  2. Choose Script name
  3. Specify Parameter set
  4. [Save]
  5. [Save] all changes