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 Digital Payments 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 |
| TCH Reports.zip | pkg_tch |
rpt_avg_response_time
rpt_network_txns rpt_number_of_rejected_payments rpt_number_of_txns_over_sla rpt_outgoing_transactions_by_client rpt_request_for_return_of_funds rpt_tch_part_disconnect_time rpt_txns_by_fi |
pfs_digital_pmts_source | DQM |
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 |
| pkg_tch |
BASIC_INB_TRANSMISSION_DATA
BASIC_INBOUND_BATCH_DATA BUSINESS_DAY_VIEW CORE_PROPERTIES_DATA GET_OPERATIONAL_TZ_TIME_NOW_V IN_REQ_CORREL_PFS_V J_GET_OPER_TS_WITH_TZID (UDF) OBJ_BASE_PFS_V OBJ_OBJ_REL_V OUT_REQ_CORREL_PFS_V PAYMENT_DATA TCH_PART_CONN_STATUS_PFS_V TRANSACTION_RPT_V TRANSMISSION_RPT_V |
APP_VERSION
APPLICATION BANK BUSINESS_DAY CASH_LETTER CHANNEL CLASSIFICATION CORE_PROPERTIES FILE FILE_TYPE H_OBJ_BASE IN_REQ_CORREL OBJ_BASE OBJ_VALUE OUT_REQ_CORREL PARTNER_GENERAL PAYMENT_MESSAGE_TYPE PAYMENT_STANDARD_TYPE PRESENTMENT PRESENTMENT_GROUP PRESENTMENT_TYPE SCHEDULER_TASK_BASE TRANSACTION_BASE TRANSMISSION_BASE TXN_PAYMENT_BASE |