Cognos data model for replicating data
To help you manage a replicated database that can be used to run the Cognos® reports and dashboards, CDC Replication scripts are provided. If you don't want to use these CDC Replication scripts, you can use your own replication tools to manage the replicated database. The following information is needed to set up your own replication.
The archive file names, package names, report names, and data sources for the FTM
NACHA
Cognos sample reports are shown in the following table.
| Cognos archive file name | Cognos package name | Report names | Data source name | Data source type |
|---|---|---|---|---|
| ACH_NOC.zip | pkg_ach_noc |
rpt_ach_noc_all_by_period
rpt_ach_noc_by_originator rpt_ach_noc_rejected_by_date |
ftmdb_source | CQM |
To run the Cognos dashboards and reports against a replicated database, it must have all of the views and tables that are used by the dashboards and reports. Your custom replication scripts need to replicate the data from the database tables and views that are shown in the following table.
| Cognos package name | Database public views | Database tables to replicate |
|---|---|---|
| pkg_ach_noc |
BUSINESS_DAY_VIEW
CORE_PROPERTIES_DATA GET_OPERATIONAL_TZ_TIME_NOW_V INBOUND_CASHLETTER_DATA ITEM_V J_GET_OPER_TS_WITH_TZID (UDF) NOC_ITEM_V PAYMENT_DATA PRES_PRES_XREF_V REASON_CODES_V |
BANK
BUSINESS_DAY CASH_LETTER CORE_PROPERTIES DEPOSITOR_PRODUCTS ITEM NOC_ITEM PARTNER_GENERAL PAYMENT PAYMENT_MESSAGE_TYPE PAYMENT_STANDARD_TYPE PRES_PRES_XREF PRESENTMENT PRESENTMENT_GROUP PRESENTMENT_TYPE PROCESSING_WINDOW REASON_CODES |