Setting up reporting for Watson Knowledge Catalog

Configure reporting to query metadata from Watson Knowledge Catalog and generate dashboards and reports by using BI tools such as Cognos Analytics and Tableau. The insights allow your data and governance teams to predict the platform's performance, identify data issues, and efficiently allocate resources.

Types of data you can query and report
Permissions that you need for this task
Procedure to set up and configure reports

To create a report, use an SQL query to pull the data to a supported external relational database of your choice. Then, connect to a reporting tool like Cognos Analytics to generate reports, see 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.

Types of data you can query and report

Catalogs

Catalog and asset metadata information (e.g. tags and description)
Asset to asset relationship (e.g. child-parent relationship)
Asset to governance artifact relationship
Data quality rules (e.g. definition, binding, and execution)
Data quality problems (e.g. asset and column problems)

Projects

Metadata imports
Metadata enrichments (e.g. artifact assignment)
Asset to asset relationship
Asset to governance artifact relationship
Data quality rules (e.g. definition, binding, and execution)
Data quality problems (e.g. asset and column problems)

Governance artifacts

Admin

Workflows for governance artifacts (e.g. workflow for creating a business term)

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 role: - Reporting Administrator For custom user roles, use the following permissions to access the Report Setup: - Manage Reporting - Manage Projects

Procedure to set up and configure reports

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 relationships between the SQL tables that store the reporting data, see Data model for Watson Knowledge Catalog reporting.

You can modify the settings for example 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

Watson Data APIs

Parent topic: Administering a catalog