Start ETL Refresh

On the Reporting data warehouse page, you can manually start the ETL process independent of any job schedules. The ETL process extracts any changes or new records from the database, transforms them to meet your requirements, and loads them in the data warehouse.

The ETL process also updates the OLAP cube with the most recent data from the data warehouse. When you run the ETL process, it updates the data warehouse and then loads the data into the OLAP cube.

Under Refresh data, select Start ETL refresh. The the ETL refresh status page appears, and the process updates the data warehouse with data that was added or modified in the source database since the last ETL refresh.

For more information about the ETL refresh, see Refresh ETL Process.