Follow these steps to run the IWE Control Flows:
- In the IWE Design Studio Data Source Explorer window ensure that these 3 Database Connections are connected to their Databases:
- In the Data Project Explorer open the CuramBIWarehouse\Control Flows folder
- Run the Core Control Flows in this order - they will in turn run all of the Data Flows:
- CuramStagingCoreStaticFlow.cflowxmi
- CuramStagingCoreOperationalFlow.cflowxmi
- CuramWarehouseCoreStaticFlow.cflowxmi
- CuramWarehouseCoreLookupFlow.cflowxmi
- CuramWarehouseCoreOperationalFlow.cflowxmi
- CuramDatamartCoreStaticFlow.cflowxmi
- CuramDatamartCoreLookupFlow.cflowxmi
- CuramDatamartCoreOperationalFlow.cflowxmi
- CuramDatamartCoreMonthlyAggregateFlow.cflowxmi
- If you have CCS and IS then run the Control Flows in this order:
- CuramStagingCoreStaticFlow.cflowxmi
- CuramStagingCoreOperationalFlow.cflowxmi
- CuramStagingCCSOperationalFlow.cflowxmi
- CuramStagingISOperationalFlow.cflowxmi
- CuramWarehouseCoreStaticFlow.cflowxmi
- CuramWarehouseISStaticFlow.cflowxmi
- CuramWarehouseCoreLookupFlow.cflowxmi
- CuramWarehouseCCSLookupFlow.cflowxmi
- CuramWarehouseISLookupFlow.cflowxmi
- CuramWarehouseCoreOperationalFlow.cflowxmi
- CuramWarehouseCCSOperationalFlow.cflowxmi
- CuramWarehouseISOperationalFlow.cflowxmi
- CuramDatamartCoreStaticFlow.cflowxmi
- CuramDatamartCoreLookupFlow.cflowxmi
- CuramDatamartCCSLookupFlow.cflowxmi
- CuramDatamartISLookupFlow.cflowxmi
- CuramDatamartCoreOperationalFlow.cflowxmi
- CuramDatamartCCSOperationalFlow.cflowxmi
- CuramDatamartISOperationalFlow.cflowxmi
- CuramDatamartCoreMonthlyAggregateFlow.cflowxmi
The Data Warehouse Tables should now be populated with the data that was in the Source Application Database Tables.