Running ETLs and ODI Loads for P6 EPPM Data Sources
To bring data from P6 EPPM to CIC Advisor, you must run ETLs or ODI load plans from the Status page of the CIC Administration application.
To access the Status page for any data source:
- Sign in to the CIC Administration application.
http://<host>:<port>/cicadmin
- From the Home menu, select a data source.
Item | Description |
---|---|
1 | Navigation menu: Select the following icons in the sidebar to use the interface: Home: Shows currently running STARETL processes for all data sources and enables you to stop a currently running STARETL process. ML Workbench: Monitor and manage models for a P6 or Aconex data source. User Management: Setup and manage P6 and Aconex accessing CIC Advisor. Status: Manage and schedule ETL runs and ODI load plans, view ETL logs and status reports for a selected P6 or Aconex data source. Publication Status: View the status of recent publication runs for a selected P6 data source. Benchmark: Setup and manage the benchmark groups to compare P6 projects in CIC Advisor. Threshold Settings: Set up the acceptable range for project metrics displayed in CIC Advisor. Config: Configure the properties of the STARETL process for each P6 data source. |
2 | Add menu: Select this menu to select codes from an available list. Actions menu: Select this menu to schedule or run ETLs for the selected data source. Refresh: Select this button to renew the current view of the page. |
3 | ODI Agent Status: Displays the current status or mode of the ODI agent. |
4 | Load Plan Status: Displays the recent runs of ODI load plans that were run for this data source. Use this section to Start or Restart ODI load runs. |
5 | Recently Running ETLs: Displays the recent ETL runs for this data source. Select View log to review the log file for each ETL run. |
Last Published Thursday, December 7, 2023