Configuring a new integration
This section shows you how to use the Integration configuration wizard to set up a new integration of Collibra Data Quality & Observability metadata from profile findings, rules, and alerts into Collibra Data Intelligence Cloud.
Important If you have multiple integrations set up, only one can be active at a given time.
Note This is a one-time configuration per environment.
Prerequisites
For the Integration API to run successfully, ensure that you review and meet the following criteria.
- Your Collibra DQ version is 2023.07 or later and Collibra Data Intelligence Cloud version is 2023.05 or later.
- You have an Admin role in Collibra Data Quality & Observability to use the configuration wizard.
- You have an Admin or Dataset Manager role in Collibra Data Quality & Observability to enable or disable individual datasets for integration.
- Your Collibra Data Intelligence Cloud profile must have Sysadmin and DataSteward global roles to manage all assets and objects of the integration.
- You have an aggregation path set for your Data Quality Rule in Collibra Data Intelligence Cloud Settings Operating model Data quality rules.
- React MUI is turned on.
Steps
- Hover your cursor over the icon and click Integrations.
The Integrations page opens. - In the upper right corner, click Add Integration.
The Add New Integration wizard appears. - On the Credentials tab, enter the required information.
- Click Next. The Connections tab opens.
- On the Connections tab, map your Collibra DQ connections to the appropriate database, schema, table, and column assets in Collibra Data Intelligence Cloud.
- From the Select Connection dropdown menu, select a Collibra DQ database to integrate into Collibra Data Intelligence Cloud.
- In yourCollibra Data Intelligence Cloud environment, open the asset page of the database you intend to map, then copy the URL from the UUID of the database asset from the URL.
- From the Connections tab in Collibra DQ, paste the copied UUID from Collibra Data Intelligence Cloud, or enter the UUID manually.
- Click Run to create an automatic mapping between the schemas within your selected Collibra DQ database and the schemas within Collibra Data Intelligence Cloud.
- When the connection loads, click Show Full Mapping to expand the entire database mapping, including schemas, tables, and columns.
- In the DGC Name column, optionally click the dropdown menu and select a different schema ( ) to update the schema mapping.
- In the DQ Name column, click the schema name to expand the available tables. The selected schema expands to show the available tables, and their corresponding tables ( ) appear across from them in the DGC Name column.
- In the DGC Name column, click the dropdown menu and select a different table to update the table mapping, if necessary.
- In the DQ Name column, click the table name to expand the available columns. The selected schema expands to show the available columns, and their corresponding columns ( ) appear across from them in the DGC Name column.
- In the DGC Name column, click the dropdown menu and select a different column to update the column mapping, if necessary.
Important
It is critical that you expand all schemas, tables, and columns you intend to map. If you do not expand each item down to the column level, your table and column relations will not be present in your integration.Note When a name match cannot be made, a "Not Configured" message displays.
- After you finish reviewing the mappings of your connection, click Save and Continue.
- Optionally click Add New to map another connection and then repeat this process.
- Click Next. The Tenants tab opens.
- On the Tenants tab, enter the required information.
- Optionally select whether to align your Collibra DQ tenant with an existing Collibra Data Intelligence Cloud community.
- If Yes,
- Select a Collibra Data Intelligence Cloud community from the dropdown menu with which to align your tenant.
- If No,
- Enter the name of a new community with which to align your tenant.
- If Yes,
- Click Next. The Dimensions tab opens.
- On the Dimensions tab, enter the required information.
- Select a dimension from the dropdown menu of the DIC Dimension column that corresponds with the DQ Dimension you want to identify as a match.
- Click Save.
Option | Description | Required |
---|---|---|
Service Type |
The application with which to integrate Collibra Data Quality & Observability metadata. This value is always Data Intelligence Cloud. |
Yes |
Service URL |
The URL of the Collibra Data Intelligence Cloud environment to send Collibra DQ metadata. For example, "https://dg-example.collibra.com". |
Yes |
Authentication Mode |
The method of authenticating the API call to Collibra Data Intelligence Cloud. This value is always basic. |
Yes |
Service Account | The username of your Collibra Data Intelligence Cloud environment. For example, "integration.user" or "Admin". |
Yes |
Password |
The password of your Collibra Data Intelligence Cloud environment. |
Yes |
Important
Only schemas ingested in Collibra Data Intelligence Cloud return when you click Run.
Note Beneath each tenant-level community, a sub-community is created for each Business Unit that has datasets assigned to it in Collibra Data Intelligence Cloud. If a dataset is not assigned to a Business Unit, it is added to a community called Unassigned DQ Job by default.
Note All DQ Dimensions, from your Collibra Data Intelligence Cloud environment are available to map to DQ Dimensions in Collibra DQ, including custom dimensions. However, DQ Dimensions from Collibra DQ are not customizable at this time.
What's next?
Enable a dataset for integration and start ingesting metadata from Collibra DQ into Collibra Data Intelligence Cloud.