Skip to main content

ETL_Refresh

What is ETL?

ETL is the process in Blackboard which extracts, transforms, and loads reporting data into the BBLEARN_STATS schema. It takes data from Activity_Accumulator and various other Blackboard tables and processes them into ODS_XXX tables within the BBLEARN_STATS schema. The ETL process runs periodically throughout the day to keep these tables up to date. When you run Course/System Reports, the data is being pulled from these ODS_XXX tables. In order to have the latest data for a course report, the ETL process must be functioning as expected.

Troubleshoot ETL issues

If you notice Course Reports don't contain up-to-date data, it could be that ETL_REFRESHDATA is not functioning properly.

When these types of issues occur, create a Support Ticket via Anthology Global Support and together we can begin an investigation into the problem.