verifying-the-extract-transform-and-load-process.adoc

permalink	sidebar	keywords	summary
install-windows/verifying-the-extract-transform-and-load-process.html	sidebar		After you upgrade, you should ensure that the Extract, Transform, and Load \(ETL\) process is retrieving data from the OnCommand Insight databases, transforming the data, and saving it into the data marts.

Verifying the Extract, Transform, and Load scheduling

After you upgrade, you should ensure that the Extract, Transform, and Load (ETL) process is retrieving data from the OnCommand Insight databases, transforming the data, and saving it into the data marts.

Steps

1. Log in to the Data Warehouse portal at https://fqdn/dwh.

2. From the navigation pane on the left, click Schedule.

3. Click Edit schedule.

4. Select Daily or Weekly from the Type list.

   It is recommended to schedule ETL to run once a day.

5. Verify that the time selected is the time at which you want the job to run.

   This ensures that the build job runs automatically.

6. Click Save.