Manage Data Marts

From Administration, you can access the Data Marts page to manage the data mart. On the Data Marts page, you can configure the Extract, Transform, and Load (ETL) process to copy new data from the source database and update the data mart. Also on the Data Marts page, you can access the Reporting data mart page to monitor ETL activity, schedule business processes to coincide with the ETL process, and manually start an ETL refresh. To access this page, go to Administration and click Data marts. The Data Mart page appears.

Note: Data mart options do not appear until you create the standard data mart. For information about how to deploy the data mart, see the Installation Guide.

From Administration, you access the Data Marts page to manage the data mart. From the Data Marts page, you open the Reporting data mart page to monitor ETL activity, schedule business processes to coincide with the ETL process, manually start an ETL refresh, or refresh the OLAP cube. To access this page, go to Administration and click Data marts. The Data Mart page appears.

Note: Data mart and OLAP options do not appear until you create the standard data mart. For information about how to deploy the data mart, see the Installation Guide.

On the Data Marts page, the grid displays all data marts that are available as record sources in the program. Currently, the standard data mart for The Raiser’s Edge is the only available data mart type. You can use this standard data mart to access to your Raiser’s Edge records for complex reporting and analysis.

On the Data Marts page, the grid displays any data mart that is available as a record source in the program. You can use the data mart and its OLAP cube to conduct complex reporting and analysis on your data.

To monitor the ETL process and configure settings for the data mart, select it and click Go to data mart. The Reporting data mart page appears.

To configure the settings for the ETL process, click ETL configuration under Tasks. The ETL Configuration page appears.