Configuring Google Looker in Unica

You must configure Google Looker in Unica Platform to enable synchronization of data from Unica to Google Looker.

Before you begin

Ensure that:
  • Google Looker is up and running.
  • Within Google Looker shared folder, Unica folder and Unica-product sub-folders should exist. Examples for sub-folders can be Campaign and Deliver.
  • Looker dashboards must be available within the product-specific folder or its sub-folder.
  • Model name of dashboards must be the same as the parent folder name.

About this task

To configure Google Looker in Unica. complete the following steps;

Procedure

  1. Log in to Unica Platform.
  2. Access Settings > Configuration.
    The Configuration page appears.
  3. In the Configuration categories panel, expand Report > Integrations > Google Looker.
  4. Set the following properties:
    Enabled
    To enable Google Looker integration, set it to TRUE.
    Google Looker URL
    The Google Looker URL containing the host name and port number. For example, https://localhost:9999
    Google Looker API port
    As per Google Looker documentation, set the value to 19999.
    Google Looker secret holder
    User name having the required data sources created. Default is asm_admin.
    Google Looker embed secret datasource
    Data source name to hold Looker embed secret. Default name is EMBED_SECRET_DS. Create data source with this name for user specified in Google Looker secret holder property.
    Google Looker client secret datasource
    Data source name containing Google Looker's client ID and client secret. Default name is CLIENT_SECRET_DS. Create a datasource with this name for the user specified in Google Looker secret holder property.
    Generating client ID and client Secret in Looker
    Navigate to the Users page in the Admin section of Google Looker. Select a user with Admin role. Click New API3 Key. Google Looker will generate a new Client ID and Client Secret.
    Update client ID and client Secret to datasource
    After generating the client ID and client secret, update them against datasource specified in Google Looker client secret data source property. Add client ID as the datasource login ID and client secret as datasource password.
    Generating embed Secret in Looker
    Navigate to the Embed page in the Admin section of Google Looker. Click Reset to generate your embed secret. Ensure that you copy the secret to a secure location because you will not be able to retrieve it from Looker again without resetting Google Looker. Resetting the key will break any embeds that uses the old key.
    Update embed Secret to datasource
    Add embed secret against data source specified in Google Looker embed secret data source property. Add embedSecret as datasource login ID and the generated embed secret as the corresponding datasource password.
    Required roles
    Open Insights menu within the Analytics menu is visible only if the logged-in user has ReportsSystem or ReportsUser role assigned.

Results

This activates the Open Insights menu item within the Analytics menu in Unica Platform. You can access Open Insights within Unica.