Collibra Rule to Pandora Alert - experianplc/experian-data-studio-connector-mulesoft GitHub Wiki

Below the mapping between Collibra Rule attributes and columns in the Pandora Alerts table.

Collibra Rule Attribute	Alerts Table Attribute
id	id
createdBy	created_by
createdOn	created_by (see [1])
lastModifiedBy	last_modified_by (see [2])
lastModifiedOn	last_modified_on
name	name
domain.id	domain_id
domain.name	domain_name

[1] The template will take the createdBy ID and fetch the user's email address. So in the table created_by will be the user's email in Collibra.

[2] The template will take the lastModifiedBy ID and fetch the user's email address. So in the table last_modified_by will be the user's email in Collibra.

Below is an example of what's returned by the Collibra RESTv2 API

 {
      "id": "aa585408-d344-42aa-bd3d-aba4596e94ef",
      "createdBy": "00000000-0000-0000-0000-000000900002",
      "createdOn": 1544027819901,
      "lastModifiedBy": "00000000-0000-0000-0000-000000900002",
      "lastModifiedOn": 1544027819931,
      "system": false,
      "resourceType": "Asset",
      "name": "Collibra Rule",
      "displayName": "Collibra Rule",
      "articulationScore": 5,
      "excludedFromAutoHyperlinking": false,
      "domain": {
        "id": "e918b17f-32b9-4e53-9b9a-35f3d1ae2940",
        "resourceType": "Domain",
        "name": "Data Quality Rules"
      },
      "type": {
        "id": "00000000-0000-0000-0000-000000031205",
        "resourceType": "AssetType",
        "name": "Data Quality Rule"
      },
      "status": {
        "id": "00000000-0000-0000-0000-000000005008",
        "resourceType": "Status",
        "name": "Candidate"
      },
      "avgRating": 0,
      "ratingsCount": 0
    },