Performing initial loads through manual execution of load queries

To perform initial loads through manual execution of load queries:

  1. Go to EPM Administration > Dashboards > Data Integrations > Relational Modeling.
  2. From the Relational Database Structure menu, select Staging target connection and click Staging Tables.
  3. Go to Schema tab, select any redundant data from the Data Preview table and click Delete Data.
  4. Go to Load Queries tab, and click Load Data from the Load drop-down menu.
  5. Verify if data has been loaded to Staging Tables.
  6. From the Relational Database Structure menu, select EPM Integration target connection and click Integration Tables.
  7. Go to Schema tab, select any redundant data from the Data Preview table and click Delete Data.
  8. Go to Load Queries tab, and click Load Data from the Load drop-down menu.
  9. Verify if data has been loaded to Integration Tables.