MicroStrategy ONE

Configure the Platform Analytics Daily ETL

The Platform Analytics Daily ETL is a process triggered by the Platform Analytics Consumer to execute certain aspects of data processing that only need to occur once a day. The process can be configured to execute at any user-defined time using the PAConsumerConfig.yaml configuration file.

It's recommended to schedule the Daily ETL during off hours.

Before configuring the Daily ETL, you must have MicroStrategy and Platform Analytics fully installed and configured. For more information, see Installing Platform Analytics.

How to Configure the Daily ETL

  • Windows
  • Linux
  1. Open Windows Services, right-click MicroStrategy Platform Analytics Consumer and select Stop.
  2. In the Platform Analytics directory, located at C:\Program Files (x86)\MicroStrategy\Platform Analytics, open the conf folder.
  3. Edit the PAConsumerConfig.yaml file.
  4. Under the dailyETLConfiguration heading, replace the value after scheduleHour: and scheduleMin: with the hour and minute you want the daily ETL to be triggered.

    The time configuration references UTC time zone in a 24 hour format.

    For example, if your server is set to UTC time zone, and you want to schedule the Daily ETL to run at 11:05 pm, you would set the values as:

    Copy
    dailyETLConfiguration:
    scheduleHour: 23
    scheduleMin: 05
  5. Save the file.
  6. Open Windows Services, right-click MicroStrategy Platform Analytics Consumer and select Start.

If you have more questions about Daily ETL, see Commonly Asked Questions and Troubleshooting.

  1. In the Platform Analytics directory, located at /opt/MicroStrategy/PlatformAnalytics/, open the bin folder and run the command:
    Copy
    ./platform-analytics-consumer.sh stop
  2. Still in the Platform Analytics directory, open the conf folder.
  3. Edit the PAConsumerConfig.yaml file.
  4. Under the dailyETLConfiguration heading, replace the value after scheduleHour: and scheduleMin: with the hour and minute you want the daily ETL to be triggered.

    The time configuration references UTC time zone in a 24 hour format.

    For example, if your server is set to UTC time zone, and you want to schedule the Daily ETL to run at 11:05 pm, you would set the values as:

    Copy
    dailyETLConfiguration:
    scheduleHour: 23
    scheduleMin: 05
  5. Save the file.
  6. In the Platform Analytics directory, open the bin folder and run the command:
    Copy
    ./platform-analytics-consumer.sh start

If you have more questions about Daily ETL, see Commonly Asked Questions and Troubleshooting.