Process Data Using a Sequence of Data Flows

A sequence is collection of data flows, datasets, or other sequences that you process together. They're useful when you want to run multiple data flows, datasets, or sequences, as a single transaction.

1. On the Home page click Create and select Sequence.
2. Click the default sequence name "New Sequence" top left, and change to a meaningful name, for example "My Sequence".
3. Add the items you want to process using the Data Flows, Datasets, and Sequences tabs to show items for selection.
   
   
   Description of the illustration sequence-editor.png
   
   
   • To add data flows, click Data Flows, then drag and drop one or more data flows to the Selections pane.
   • To add datasets, click Datasets, then drag and drop one or more datasets to the Selections pane.
   • To add other sequences, click Sequences, then drag and drop one or more sequences to the Selections pane.
4. Arrange the items in the sequence.
   • If you want to override the default order in which Oracle Analytics processes items, select the Ordered option and drag and drop items to change the order (numbered 1,2,3 and so on).

     If the Ordered option is deselected (the default setting), this triggers auto-dependency detection. Oracle Analytics takes into consideration inputs and outputs for each sequence item to determine the execution order, and executes items in parallel where necessary.

   • To remove items, hover over an item and click the ellipsis at the right-hand side, then click Remove.
5. Click Save.
6. Start the sequence.
   • To start the sequence immediately, click Execute Sequence in the sequence editor.
   • To start the sequence later, from the Home page, click the Navigator, then click Data, then Sequence. Right-click a sequence, then click Run.
   • To schedule a sequence to execute at a particular date and time, from the Home page, click the Navigator, then click Data, then Sequence. Right-click a sequence, then click New Schedule, then click New, and use the Schedule dialog to specify a date and time and repeat cycle.
7. Manage the sequence process.
   • To manage a sequence being processed, from the Home page, click the Navigator, then Jobs.
   • To manage scheduled sequences, from the Home page, click the Navigator, then Jobs, then Schedules.

Note:

Sequences don't process copies of a data flow. When a sequence processes a data flow, copies of that data flow are ignored. If this happens, you see updates in the sequence logs accessed via the History tab on the Inspect panel.