The Extract, Transform, and Load (ETL) process updates the data mart with new records from the source database. On the Reporting data mart page, you can monitor ETL activity, manually start an ETL refresh, reset the ETL process for a full refresh, and schedule queues to run before or after the ETL process. In addition, you can access KPI information about the data mart and the ETL process.
You can also deploy eligible smart fields to the OLAP cube and refresh the data in the cube after the ETL process updates the data mart. On the OLAP database roles tab, you can configure database roles to control access to the OLAP cube.
To keep the data mart up to date, we recommend that you schedule the ETL process to occur at regular intervals. You can create a queue process for the Data Mart Start ETL Refresh Job Business Process and schedule the queue process to run the ETL process at regular intervals.
For information about how to set up a queue process, see the Administration section of the help file.
For information about configuration options, see Data Marts Configuration.