Data model for IBM Knowledge Catalog reporting

You can use the data model to create SQL queries to generate reports on IBM Knowledge Catalog data.

Using the data model

The following image shows the reporting data model to generate reports on IBM Knowledge Catalog data. To explore the relationships in the data model, you can create an interactive Entity Relation Diagram (ERD file). Relation diagrams represent the actual state of databases and you cannot save any changes that you make. The reporting data mart is created in the database that you specify for reporting. To create an ERD file, connect this data mart to a database tool of your choice and follow the tool's instructions. Consult your database administrator to get more details.

Reporting data model to use for creating SQL queries to generate reports on IBM Knowledge Catalog data. The reporting tables are described in another topic. The sample SQL queries are listed in another topic.

Learn more

Parent topic: Setting up reporting for IBM Knowledge Catalog