Migrating Data into HyperStage

Migrate Data into HyperStage

About This Task

This topic describes how to migrate Work History family data from a source family in APM into the HyperStage PostreSQL database. You can then create visualization on the data.

To migrate the data, an ETL tool named the Advanced Visualization Data Migrator tool is used.

Procedure

  1. Access the Advanced Visualization page.
  2. Select , and then select Prepare and Manage Data.
    The SERVER page appears.
  3. Under Applications, select meridium > work-history > flows.
  4. In the Application Directories section, right-click the flow whose data you want to migrate, and then select Submit.
    The job ID appears in the Submit section.
  5. In the File Panel section, right-click the flow that you have submitted, and then select Logs > Statistics.
    The status of the flow appears (for example, pending, running, done).
  6. Repeat the aforementioned steps for all the flows.
  7. In the Application Directories section, right-click global_flow whose data you want to migrate, and then select Schedule and E-mail > Manage
  8. Select the E-Mail On Start, E-Mail On Failure, and E-Mail On Completion check boxes, and enter the email ID. For multiple email IDs, separate them using a semi-colon.
  9. Select SetOK.
  10. Right-click global_flow, and select Submit.
    An email notification appears on the flow start, failures, and completion.
  11. To check the flow status in the interim, in the File Panel section, right-click the flow that you have submitted, and then select Logs > Statistics.
  12. For scheduling the flow, say weekly: select Schedule and E-mail > Manage
    1. In the Schedule Type box, select Recurring.
    2. In the Interval Type box, select Weekly.
    3. In the Special date/time ranges box, select On Days of Week.
    4. Select the start date and start time as required, and select Set.

What To Do Next

After you submit the global_flow and the status changed to done, create visualizations on the data via HyperStage.