Topics in this part: This part describes how you can extract key information from CWSerenade toward building and maintaining a data warehouse, which provides the ability to perform powerful, efficient analysis, monitor trends, and help you make strategic business decisions.
• CWData Overview introduces data warehousing concepts, describes the process of building and maintaining a data warehouse, provides examples of its use, and presents the key table relationships within the data warehouse.
• Working with the Data Warehouse Integration in CWSerenade describes the screens you use to perform an initial load of data from CWSerenade to build a data warehouse, as well as how to perform periodic updates and review the DW Transaction table.
• Relic Processing describes the steps performed by the Relic job to extract data from the DW Staging tables in the CWSerenade database to the tables in the cwi_staging database on the CWData server.
