Running 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. Initially, you must run the ETL after installing the Community Manager Reports plugin.

Fastpath: Admin Console: System > Settings > Analytics and then the Data Load tab

To run the ETL process:

  1. In the Admin Console, go to System > Settings > Analytics, and then select the Data Load tab.
  2. Click Run to begin the ETL process.

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

After you've run the ETL process for the first time, you can begin using the reports. For more on using Community Manager Reports, see Using Jive Analytics.