Background

This sample was developed in cooperation with Collibra (https://www.collibra.com/) and aims to export classification data for Collibra to import.

Example output

The script creates a community in Collibra called "RedgateSqlDataCatalog", into which it imports all instances and databases that have been registered in SQL Data Catalog. For each column, the script also imports:

• all tags assigned to the column;
• the "Personally Identifiable Information" Collibra attribute, if "Confidential - GDPR" or "Highly Confidential - GDPR" tags are assigned to the column;
• the "Security Classification" Collibra attribute, again depending on the value of the "Sensitivity" tag category.

Sample export script

The sample script is available on Github.

The parameters you'll need to configure are:

• "serverUrl": the URL of your installed SQL Data Catalog server.
• "authToken": an auth token generated in SQL Data Catalog. It is recommended to generate a new auth token rather than reuse an existing one.
• "collibraAPI": the URL of your Collibra instance.
• "collibraUserName": the username of the Collibra account the script should use
• "collibraPassword": the password of the Collibra account