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
- 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
- Log in to Unica Platform.
-
Access
.The Configuration page appears.
- In the Configuration categories panel, expand .
-
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
orReportsUser
role assigned.