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

  1. Hover your cursor over the icon and click Integrations.
    The Integrations page opens.
  2. In the upper right corner, click Add Integration.
    The Add New Integration wizard appears.
  3. On the Credentials tab, enter the required information.
  4. 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

  5. Click Next.
  6. The Connections tab opens.
  7. On the Connections tab, map your Collibra DQ connections to the appropriate database, schema, table, and column assets in Collibra Data Intelligence Cloud.
    1. From the Select Connection dropdown menu, select a Collibra DQ database to integrate into Collibra Data Intelligence Cloud.
    2. 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.
    3. database asset page uuid example screenshot
    4. From the Connections tab in Collibra DQ, paste the copied UUID from Collibra Data Intelligence Cloud, or enter the UUID manually.
    5. Click Run to create an automatic mapping between the schemas within your selected Collibra DQ database and the schemas within Collibra Data Intelligence Cloud.
    6. Important 
      Only schemas ingested in Collibra Data Intelligence Cloud return when you click Run.

    7. When the connection loads, click Show Full Mapping to expand the entire database mapping, including schemas, tables, and columns.

        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.

      1. In the DGC Name column, optionally click the dropdown menu and select a different schema ( schema icon ) to update the schema mapping.
      2. Note When a name match cannot be made, a "Not Configured" message displays.

      3. In the DQ Name column, click the schema name to expand the available tables.
      4. The selected schema expands to show the available tables, and their corresponding tables ( table icon ) appear across from them in the DGC Name column.
      5. In the DGC Name column, click the dropdown menu and select a different table to update the table mapping, if necessary.
      6. In the DQ Name column, click the table name to expand the available columns.
      7. The selected schema expands to show the available columns, and their corresponding columns ( column icon ) appear across from them in the DGC Name column.
      8. In the DGC Name column, click the dropdown menu and select a different column to update the column mapping, if necessary.
      9. schema, table, and column mapping example
    8. After you finish reviewing the mappings of your connection, click Save and Continue.
    9. Optionally click Add New to map another connection and then repeat this process.
  8. Click Next.
  9. The Tenants tab opens.
  10. On the Tenants tab, enter the required information.
    1. Optionally select whether to align your Collibra DQ tenant with an existing Collibra Data Intelligence Cloud community.
      1. If Yes,
        • Select a Collibra Data Intelligence Cloud community from the dropdown menu with which to align your tenant.
      2. If No,
        • Enter the name of a new community with which to align your tenant.
    2. tenant mapping screenshot

    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.

  11. Click Next.
  12. The Dimensions tab opens.
  13. On the Dimensions tab, enter the required information.
    1. 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.
    2. 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.

      dimension mapping screenshot
  14. Click Save.

What's next?

Enable a dataset for integration and start ingesting metadata from Collibra DQ into Collibra Data Intelligence Cloud.