Running the ETL

Running the extract, transform and load (ETL) process pulls data from Jive and stores it in the Analytics database.

The ETL process puts additional load on the core database and may affect the performance of your community, especially when run during peak usage hours. The ETL process runs nightly, so you may prefer waiting instead of initiating it manually.

Fastpath: Admin Console: System > Settings > Analytics > Data Load

Click Run to begin the ETL process.

When enabled, the Data Load settings provide a way to purge old data from your Analytics database. Just choose how long you want to keep data around and click Enabled. This affects how far back you can see report data. Clearing out old data improves database performance.