Cognos Data Manager Catalog is an ETL project to create your enterprise database (Data Ware House) for Analysis and Reporting purpose. A catalog contains set of instruction to populate data from various type of sources and transform it as per business requirement and load the final data in Enterprise database. A Catalog contains Source connection definitions, contains builds to load data from one source to another, contains hierarchies to flatten the data, SCD to maintain history in dimension tables, look up to create fact table, pivoting and un-pivoting and user define the function to handle complex logic. Below image shows the role of Cognos Data Manager Catalog.
Cognos Data Manager Catalog can be saved in the following database.
For storing Cognos Data Manager catalog we need a working database server.
Create a new SQL Server Database for storing our Cognos Data Manager Catalog.
CREATE DATABASE MyFirstCognosCatalog GO
Following are the steps for creating a new Cognos Data Manager Catalog after we have a database.
1. Launch Cognos Data Manager
2. Click on Create a new Catalog. If the welcome dialog is not available for you can use (Ctrl+N) keyboard shortcut. On new dialog provide New Cognos Data Manager Catalog Information. Once done, click on Next Button.
On the next dialog, we need to provide our database information. Provide correct database information and click on Test Connection. If the connection is working fine Click on Finish. Once you clicked on Finish Cognos Data Manager is going to create tables in the database.
If Cognos Data Manager catalog is created successfully you can find some database tables in your "MyFirstCognosCatalog".
We will discuss more all these database tables in our this article.
Please login to post your valuable comments.
Get the latest vLemonn news first