Skip to content

Running a Flow

In this step you can start the execution of the ETL package associated with a Flow to either load initial data from the source to the target database or to load incremental data to maintain databases aligned.

Important recommendation

It is strongly recommended that you monitor flow execution using the tools made available by SQL Server (see https://learn.microsoft.com/en-us/sql/integration-services/performance/monitor-running-packages-and-other-operations?view=sql-server-ver16 ). This is particularly important when the Context Manager has been activated, because if flow execution is delayed (for example for more than one day), contextualization may temporarily or permanently fail.

Prerequisites

  • When you run a Flow, you must check that no other operation, such as a purge database or a deploy, is running at the same time. If that is the case, wait for this operation to end before running the Flow.
  • Before running a Flow, you must have deployed the Environment at least once.
  • It is recommended that you stop the source system before running an initial Flow when you cannot determine the adequacy of the system hardware to support the production activities generated by the Flow.
  • If the selected source is Opcenter Execution Foundation, Opcenter Execution Process, SIMATIC IT Unified Architecture Foundation or SIMATIC IT Unified Architecture Process Industries, only the following format is supported for datetime fields: yyyy-mm-dd hh🇲🇲ss. Any other format is discarded from the system. Non-standard formats can however be loaded by overriding the contract layer.

Running an initial Flow

  1. On the "Flows" page, select the flow you want to run.
  2. Click "Run Flow".
  3. On the "Execute Flow" page, select the Environment where you want to execute the Flow to load your data.
  4. In the "Load Mode" drop-down list, select "Initial".
  5. Click the "Configuration Type Advanced" checkbox and select one of the following options:
    • Rebuild Indexes after the Flow has finished running.
    • Enable Schedules after the Flow has finished running.
    • Execute Project Synchronization after the Flow has finished running.
  6. Select the "Start Mode", which can be either of the following:
    • "Autodetect". If you select this option, the system considers as initial date the oldest date in the production database.
    • "Manual". If you select this option, you can set the loading time interval by browsing for the Start Date and Time and End Date and Time in the available calendars.
  7. Click "Start" to run the Flow.

Running an incremental Flow

  1. On the "Flows" page, select the Flow you want to run.
  2. Click "Run Flow".
  3. In the "Execute Flow" page, select the Environment where you want to execute the Flow to load your data.
  4. In the "Load Mode" drop-down list, select "Incremental".
  5. Click "Start" to run the Flow.

Running a single entity

  1. On the "Flows" page, select a Flow.
  2. Click "Run Single Entity".
  3. In the "Run Single Entity" page, select the Environment where you want the entity to be executed.
  4. Specify a Start Date and an End Date to define the time interval for the data you want to load.
  5. Select the entity for which you want to run the Flow.
  6. Click "Start" to run the Flow.

Last update: October 26, 2026