Integrating with Looker

  • Release version: Yokohama
  • Updated January 30, 2025
  • 4 minutes to read

    • Integrating your Software Asset Management application with the Looker, a Google Cloud application enables you to track your software subscriptions and to reclaim unused licenses.

    Important:
    Minimize security risks and protect information by granting access only to the necessary user or API permissions.
    Table 1. Minimal user permissions
    Process Required user role in the Box application Authentication scopes
    Download subscriptions User with see_users permission None
    Pull user activity User with see_users permission None
    Reclaim subscription admin None

    Configure Looker API key settings

    Configure API key settings to manage and retrieve Looker API keys.

    Before you begin

    Looker Role required: admin

    Procedure

    1. Log in to your Looker (https://<instancename>.looker.com/) instance.
    2. Select the gear icon to open Admin settings.
    3. Select Users > Open the admin user account.
    4. Select Edit API3 Keys under the Profile tab.
    5. Select New API3 Key.
    6. Copy the Client ID and Client secret for later use.

    Create a Looker integration profile

    Create a Looker integration profile to track software subscriptions and optimize licensing for your Looker solutions.

    Before you begin

    The Software Asset Management - SaaS License Management plugin (sn_sam_saas_int) must be installed from the ServiceNow Store.

    ServiceNow Role required: admin or sam_integrator

    Important:
    You must select the Looker Spoke check box for this integration while installing optional features on the Application Manager page. For more information about choosing the required SaaS applications, see Request SaaS License Management.

    About this task

    If you’re using Software Asset Workspace, the option to create the Looker integration profile in Core UI is inactive.

    Procedure

    1. Navigate to the integration profile.
      InterfaceAction
      Core UI
      1. Navigate to All > Software Asset > SaaS License > Direct Integration Profiles.
      2. Select New.
      3. Select Looker Integration Profile.
      Software Asset Workspace
      1. Navigate to License operations > User Subscriptions > Direct integration profiles.
      2. Select New.
      3. Select Looker from the drop-down list.
      4. Select Continue.
    2. On the form, fill in the fields.
      Table 2. Integration profile form
      Field Value
      Display name Name of the integration profile. For example, Looker integration.
      Status Status of the integration profile.
      • If you have not published the integration profile, this field is automatically set to  Draft.
      • If you have already published the integration profile, this field is automatically set to  Published.
      Profile type Type of integration profile. This field is automatically set to Looker Subscription.
    3. Review the required user roles or API permissions specified in the Vendor configuration field for each process to minimize security risks and optimize SaaS licenses.
      Note:
      For more information, see Minimal user permissions table.
      1. In the Download Subscription Subflow section, verify that the Subflow field is set to Looker Download Subscriptions.
        Note:
        The Download subscriptions check box is selected by default and you can't clear it.
      2. In the Reclaim Subscription Subflow section, verify that the Subflow field is set to Looker Reclaim Subscription.
        Note:
        The Reclaim subscriptions check box is selected by default. If you don't want to reclaim subscriptions, you can clear this check box. If you clear it, the removal candidates are created but the reclaim subscription subflow isn't triggered or the reclamation process isn't initiated.
    4. Select Save.
      A draft integration profile is created.

      The Connection & Credential field appears and is automatically set to sn_looker_spoke.Looker.

    5. Open the connection & credential aliases record by selecting the preview icon (Preview icon.) next to the Connection & Credential field and then selecting Open Record in the record preview.
    6. On the Connection & Credential Aliases form, select the Create New Connection & Credential related link.
    7. In the Create Connection and Credential dialog box, fill in the fields.
      Table 3. Create Connection and Credential dialog box
      Field Description
      Connection Information
      Connection Name Name of the Looker connection. This field populates automatically.
      Connection URL Looker base URL for the API. This field is automatically set to https://<instance_name>.looker.com.
      Credential Information
      OAuth Client ID Client ID that is assigned to your Looker application.
      OAuth Client Secret Client secret that is assigned to your Looker application.
      OAuth Redirect URL https://<instance name>/oauth_redirect.do, where instance name is the name of your ServiceNow instance.
    8. Select Create and Get OAuth Token.
      Note:
      For the role required to perform this step, refer to the Minimal user permissions table.
      The dialog box closes and you automatically return to the integration profile form.
    9. On the integration profile form, select Validate Connection to verify the connection and credential details of this integration.

      Validating the connection verifies the Download Subscriptions APIs, but not the Reclaim Subscriptions APIs.

    10. After the connection is verified, select Publish.
    11. In the Publish Confirmation dialog box, select OK.

    What to do next

    After the integration connects, your ServiceNow instance automatically creates software models, reclamation rules, and software subscriptions that are refreshed daily.

    If you want to set up multiple integration profiles with unique connections, create child aliases to manage different configurations and settings for each integration profile. For more information, see Create a child alias to set up multiple integration profiles.

    Review all automatically generated reclamation rules to reclaim user subscriptions. For more information, see Review a software reclamation rule.

    Create software entitlements for the automatically generated software models to track used software against owned software.
    Reconciliation also runs on your subscriptions as a scheduled job or on-demand. You can view your reconciliation results in the License Workbench (Software Asset Management classic application) or the License usage view (Software Asset Workspace). Use these results to determine your license compliance position and to remediate any non-compliance.