When setting up a connection between the data governance software and Metric Insights, it is important to properly introduce all the Metadata from tool's database to the MI interface.
This article describes in details all the steps that need to be performed to sync data governance tool's Metadata with Metric Insights Objects.
1. Establish Connectivity
All the external BI tools are represented in Metric Insights by Data Sources. So, you have to create a Data Source using a corresponding plugin.
For detailed instructions, see this articles for data governance tools that Metric Insights has plugins for:
- Establish Connectivity to Alation
- Establish Connectivity to Atlan
- Establish Connectivity to Collibra
- Establish Connectivity to Databricks Unity Catalog
- Establish Connectivity to Microsoft Purview
If you can't find the tool your organization uses in the list above, check this chapter.
2. Collect the Data
To collect data from Collibra and bring it to Metric Insights, you have to create a Dataset.
Make sure that Dataset contain the following columns:
- Report ID;
- Glossary Term;
- Section;
- Definition;
- Owner;
There also has to be a column for each other metadata field that has to be synchronized with Metric Insights.
3. Import Glossary
In this step you are going to bring Glossary terms from the data governance tool to Metric Insights via Autoimport functionality.
Use the Dataset, created in Step 2, to Automatically Import Glossary Terms.
4. Synchronize Glossary with Elements
Glossary Autosync allows synchronization of Glossary Terms you brought in Step 3 with Metric Insights Elements. To accomplish this, create a Dataset to pair Elements to Glossary Terms and use it for Glossary Autosync. The system will look up the Element by its ID and "tag" it with the corresponding Glossary Term, making the definition visible on the Report tile.
For more plugin-specific details, see the following articles:
5. Create Custom Fields
For every Metadata column that is not related to Glossary, you will have to create a separate Custom Field. Those are needed to contain metadata and will be paired with metadata columns later, for Auto Synchronization.
6. Synchronize Metadata with Custom Fields
Custom Field Autosync allows updating of Custom Field values based on Dataset information, whenever the Dataset is updated.
Using the Dataset, created in Step 2, synchronize the Metadata columns with Metric Insights Custom Fields.
For more plugin-specific details, see the following articles:
7. Optionally, Configure Search to Include Metadata from the Tool
In Metric Insights, you can also search for tools' and database table assets without leaving the Metric Insights UI and without recreating them as objects in Metric Insights. Global Search will return the assets with the list of the available metadata and links to proceed to the asset in the data catalog tool.
To achieve that, see the following plugin-specific articles:
- Configure Search to Include Reporting Asset Metadata from Atlan
- Configure Search to Include Table and Column Metadata from Atlan
- Configure Search to Include Reporting Asset Metadata from Collibra
- Configure Search to Include Table and Column Metadata from Collibra
- Configure Search to Include Table and Column Metadata from Databricks Unity Catalog
8. Optionally, Associate Metadata to Elements Based on Lineage
Using Metadata Propagation you can propagate metadata changes to Elements in Metric Insights. Metadata associated with a table or table-column combination is propagated to all Elements that utilize that table in their Lineage.
To achieve that, follow the steps described in Configure Metadata Propagation Rules article.