Setting up reporting for Watson Knowledge Catalog

By configuring Watson Knowledge Catalog for reporting, chief design officers and analysts are able to gain insights into their data governance platform. The insights allow them to efficiently allocate stewards and foster maximum benefits. Users can generate reports on governance artifacts, catalog assets, and more with BI tools such as Cognos Analytics and Tableau that are connected to a user-accessible data mart in Watson Knowledge Catalog.

Types of Watson Knowledge Catalog data for which you can generate reports
Permissions that you need for this task
Procedure

To create the reports, use an SQL query over the external relational database.

You can connect to a reporting tool to generate reports, for example to Cognos Analytics. Sample queries are provided in the Sample reporting queries for Watson Knowledge Catalog.

To ensure that sensitive data is protected, you can send data to various schemas on the database, and restrict access to these schemas.

Only top-level categories can be enabled for reporting. Subcategories use the same schema as their top-level categories.

You can generate reports on the following information:

Data quality rules (definition, binding, and execution)
Data quality problems (asset and column problems)
Custom properties in governance artifacts
Custom category roles
User profiles (name and email)
Workflows for governance artifacts
Metadata imports
Metadata enrichments (artifact assignment)

Types of Watson Knowledge Catalog data for which you can generate reports

Catalogs

Catalog and asset metadata information, for example tags and description
Asset to asset relationship
Asset to governance artifact relationship
Data quality score with data quality problems

Projects

Project and asset metadata information, for example tags and description
Asset to asset relationship
Asset to governance artifact relationship
Data quality score with data quality problems

Governance artifacts

Metadata of all the governance artifacts
Associations between all governance artifacts
Associations between data protection rules and governance artifacts
Metadata of category with custom role

Permissions that you need for this task

Supported database types

Db2 on Cloud with a Standard or Enterprise plan
PostgreSQL version 12, and later

Prerequisites A nonvaulted connection to a supported type of database is required. If no connection is defined in the platform connections, contact your administrator to configure at least one. See Creating the catalog for platform connections.

Required permissions To configure the reporting, you must have the following user roles: - Reporting Administrator - Manager

If you have the Administrator role for the IBM Cloud account, you have permissions to generate reports.

Procedure

To set up the reporting:

Go to Administration > Configurations and settings > Report setup.
Select a connection to a database.
Select the default schema. All data is written to the selected schema by default, but you can edit the schema for a particular catalog, project, or category. Make sure that the database users have write access to the selected schemas.
Enable the catalogs, projects, categories, or data protection rules for which you want to run the reports.
Click Save settings.

Next steps

To better understand the replationships between the SQL tables that store the reporting data, see Data model for Watson Knowledge Catalog reporting.

You can modify the settings e.g. change the schema, enable or disable data for reporting. After you save the new settings and update the reporting, the reports are updated.

Learn how to handle synchronization failures in Starting, stopping, pausing, and resuming reporting for Watson Knowledge Catalog.

Learn more

Waston Data APIs

Parent topic: Administering a catalog