6.1 Create a Data Load

Use the Create Data Load wizard to define the source connection and the target connection for the data load.

Note:

Data load is not supported for Oracle Object Storage connections.

The wizard also allows you to choose the load processing option based on the deployment type. The newly created data load is displayed in the Data Loads page of the associated project. Click the Actions icon () next to the selected data load to edit, rename, start, export, or delete it.

To create a data load from the Home page:

1. Do one of the following:
   • On the Home page, click Load Data. The Create Data Load wizard appears.

     In the Create Data Load tab, enter a name if you want to replace the default value, add a description, and select a project from the drop-down.

   • On the Home page, click Projects, and then the required project tile. In the left pane, click Data Loads, and then click Create Data Load.

   The Create Data Load wizard appears.

2. In the Name field, enter a name for the data load. The field is pre-populated with a default name. You can edit this value.
3. Add a description. This is optional.
4. If you have opened the Create Data Load wizard from the Home page, then you need to select a project name from the drop-down. If this your first time here, click the + icon to create a project. If you have logged in as SUPERVISOR, the default project name is Home. For other users, the default project name is in the format <username>_Home. You can edit the default value. See Work with Projects for more information about projects.
5. For Load Processing do one of the following:
   • Select the Internal radio button and from the Deployment Type drop-down select Data Transforms (Batch).
   • Select the Delegate radio button and from the Deployment Type drop-down select OCI GoldenGate. From the GoldenGate Deployment Connection drop down select a connection.
6. Click Next.
7. To define your source connection, 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. See Work with Connections for more details about connections.
8. 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.

   Note:

   If there is missing information such as user name or password not specified, wallet missing, and so on, the list may fail to populate with a “This connection has missing information.” error. Click the Edit icon () to open the Update Connection page where you can fill in the missing details.
9. Click Next.
10. Similarly, define the target connection. If you plan to use an Apache Iceberg connection as a target to load data, see Creating and Running an Apache Iceberg Data Load for specific instructions.
11. Click Save.

    The Data Load Detail page appears listing all the loaded data entities.