9.2 Create a Data Flow

A data flow defines how the data is moved and transformed between different systems.

A data flow in Data Transforms connects sources to targets through a flow of components such as Join, Filter, Aggregate, Set, Split, and so on. See Supported Database Functions for more information.

When you run a data flow, Data Transforms uses the joins, filters, mappings, and constraints to transform source data and load it to target tables. Note that you can run only one execution flow at a time. You cannot put multiple flows on a Data Flow and a flow cannot diverge into multiple flows.

You can create data flows in any of the following ways:

• From the Projects page
• From the Data Flows page within a project
• From the Home page

The newly created data flow is displayed in the Data Flows page of the associated project. Click the Actions icon () next to the selected data flow to edit, rename, copy, change folder, start, export, or delete it.

From the Projects page

To create a data flow from the Projects page,

1. On the Projects page, click Create Data Flow.

   Create Data Flow page appears:

2. In the Name field, enter a name for the new data flow.
3. Select Create New Project, if you wish to create new project folder for the newly created data flow.
4. Else, click Add to Existing Projects, if you wish to add the newly created data flow to an existing project folder.
5. If you have selected Create New Project for the previous option, in the Project Name field, enter the name of the newly created project.
6. Else, if you have selected Add to Existing Projects for the previous option, select the required project from the Project Name drop-down arrow.
7. In the Description field, enter a description for the newly created data flow.
8. Click Create.

From the Data Flows page within a project

To create a data flow from the Data Flows page within a project,

1. On the Projects page click the project tile you wish to create a new data flow for. The Project Details page appears.
2. In the Data Flows page, click Create Data Flow.
3. Provide the Name and Description of the new data flow.
4. Click Next.
5. To define your source connection, from the Connection drop-down, select the required connection from which you wish to add the data entities.
6. In the Schema drop-down, all schema corresponding to the selected connection are listed in two groups:
   • Existing Schema (ones that you've imported into Oracle Data Transforms) and
   • New Database Schema (ones that you've not yet imported).

   Select the schema that you want to use from the drop down. For Oracle Object Storage connections, the Schema drop-down lists the name of the bucket that you specified in the URL when you created the connection.

7. Click Save.

   The Data Flow Editor appears that allows you to create a new data flow.

From the Home page

To create a data flow from the Home page,

1. On the Home page, click Transform Data. The Create Data Flow page appears.
2. Provide the Name and Description of the new data flow.
3. Select a project name from the drop-down. Alternatively, click the + icon to create a project.
4. Click Next.
5. From the Connection drop-down, select the required connection from which you wish to add the data entities. Alternatively, click the + icon to create a new connection.
6. In the Schema drop-down, all schema corresponding to the selected connection are listed in two groups:
   • Existing Schema (ones that you've imported into Oracle Data Transforms) and
   • New Database Schema (ones that you've not yet imported).

   Select the schema that you want to use from the drop down.

7. Click Save.