9 Data Flows

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

Topics

• About Data Flows
  A data flow defines how the data is moved and transformed between different systems.
• 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
  Create data flows to load data from a source connection, run transformations, and move the data to a target database.
• 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.
• Use Text Embedding Vector in a Data Flow
  Data Transforms supports the use of vector datatype and embedding vectors in a data flow. Currently, Data Transforms integrates with OCI Generative AI service to convert input text into vector embeddings that you can use for data analysis and searches.
• 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.