9 Data Flows

This section contains detailed information about creating and working with data flows, which includes adding components, mapping columns, and executing a data flow.

Topics:

• About Data Flow Editor
  The Data flow editor is divided into five parts, the Data Entity Panel, the Database Functions Toolbar, the Design Canvas, the Properties Panel, and the Status Panel.
• Create a Data Flow
  A data flow defines how the data is moved and transformed between different systems.
• Add Components
  Add the data entities and database functions to the Design Canvas, and connect them in a logical order to complete your data flows.
• Component Properties
  The Properties Panel displays various settings for components selected in the Design Canvas.
• Map Data Columns
  When you connect the source data entity with the target data entity, the column names are automatically mapped by the column names. You have a choice to map the columns by Position or by Name or map the columns manually using the Expression Editor.
• Validate and Execute a Data Flow
  After your mappings are ready, you can proceed to validate and execute the data flow.
• Schedule Data Flows or Workflows
  You can schedule workflows and data flows to run at specified time interval.
• Monitor Status of Data Loads, Data Flows, and Workflows
  When you run a data load, data flow, or workflow Oracle Data Transforms runs jobs in the background to complete the request. You can view the status of the job in the panel on the bottom right of the Data Load Details, the Data Flow Editor, and the Workflow Editor page.