Auto-matching in the BI tools

When configuring Collibra Browser Extension extension, you can add domains of BI tools or web applications such as Power BI, SAP Analytics Cloud, and Tableau. The extension then automatically detects the pages you visit in these applications to retrieve the corresponding assets from the connected Collibra environment. The Collibra icon appears as an overlay on the page. Clicking the overlay shows the Collibra asset that corresponds to the data on the page.

In this topic

Supported assets for auto-matching

Collibra Browser Extension supports auto-matching for the following Collibra assets:

  • Power BI: Dashboards, reports, and workbooks
  • SAP Analytics Cloud: Models and stories
  • Tableau: Dashboards

Examples

  • When viewing a report in Power BI, clicking the Collibra Browser Extension overlay shows information about the equivalent Power BI Report asset from Collibra.
    Browser extension showing PowerBI report information
  • When viewing a story in SAP Analytics Cloud, clicking the Collibra Browser Extension overlay shows information about the equivalent SAC Story asset from Collibra.
    Browser extension showing PowerBI report information
  • When viewing a dashboard in Tableau, clicking the Collibra Browser Extension overlay shows information about the equivalent Tableau Dashboard asset from Collibra, including responsibilities, report attributes, and related assets.
    Browser extension tableau dashboard

How auto-matching works

For auto-matching to work on an application, the corresponding web domain should be first added as part of the configuration. For example, if you want auto-matching to work on a Tableau dashboard, ensure that you have selected Tableau in the drop-down list box and entered the required Tableau URL.
Image showing the addition of a Tableau domain

Auto-matching on a Power BI dashboard

When you work on a Power BI dashboard, the extension extracts the title displayed on the browser tab and the universally unique identifier (UUID) of the dashboard from the page address (URL).

Example Power BI title on browser tab

The extension then searches the Power BI Dashboard asset in Collibra to identify a URL attribute that contains the UUID from the Power BI URL. If no match is found, the extension searches for an asset whose name is the same as the name found in the browser tab title of the Power BI dashboard.

Tip If auto-matching fails, the extension searches for the name of the dashboard with the Power BI Dashboard asset type as a filter.

Auto-matching on an SAP Analytics Cloud model or story

When you work on an SAP Analytics Cloud model or story, the extension uses the page URL to identify the corresponding asset in Collibra. Due to variations in SAP Analytics Cloud URLs for a single object, the extension uses the following regular expressions for auto-matching.

^<SAP instance URL>\/sap\/fpa\/ui\/(tenants\/[^\/].+\/)?app\.html[^#]*#\/?((story\d?&\/s\d?\/)|(modeler&\/m\/model\/))([^\/]+)(\/.*)?

^<SAP instance URL>\/sap\/fpa\/ui\/(tenants\/[^\/].+\/)?app\.html#.*;view_id=story\d?;resource_id=([^;]+);.*

If a URL matches one of these regular expressions, the extension extracts the asset ID or asset unique name from the URL. Then, the extension builds a version of the URL that is ingested into Collibra to search for the corresponding asset using the URL.

For models, the extension builds a URL in the following format: <SAP instance URL>/sap/fpa/ui/app.html#/modeler&amp;/m/model/<asset unique name>

For stories, the extension builds a URL in the following format: <SAP instance URL>/sap/fpa/ui/app.html#/story2&amp;/s2/<asset ID>/?mode=view

Auto-matching on a Tableau dashboard

When you work on a Tableau dashboard, first, the extension searches for the following pattern in the page URL to determine if the current page is a dashboard.

<tableau url>/#/site/<path or uuid>/views/<path or uuid>
Note In this pattern:
  • The content within the angle brackets (<>) may match any string.
  • /site refers to the workbook or site name and is optional for auto-matching.
  • path or uuid isn't used for auto-matching.
Tip 

The following image shows a Tableau page URL that meets the required pattern.

Example of a Tableau page address

Next, the extension compares the page URL of the Tableau dashboard with the URL attribute of Tableau Dashboard assets in the connected Collibra environment for a match. If this method returns no results, the extension extracts the following information from the breadcrumb on the current page:

  • Tableau project
  • Tableau workbook
  • Tableau dashboard or report

If the page URL meets the required pattern and if the extension can extract the required information from the breadcrumb, the extension automatically identifies the dashboard in the connected Collibra environment.

Tip If auto-matching fails, the extension searches for the name of the dashboard with the Tableau Dashboard asset type as a filter.