Create a Data Load

A data load allows you to load multiple data entities from a source connection to a target connection.

You can create a data load in either of the following ways:

Note:

Data load is not supported for Oracle Object Storage connections.

Creating a Data Load from the Home Page

This section describes the generic steps to create a data load. If you plan to load and transform data using OCI GoldenGate, create the data load using the Projects page. See Creating a Data Load from the Projects Page.

To create a data load from the Home page:

  1. From the left pane, click the Home tab. Click Load Data.

    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. 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. Click Next.
  6. 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.
  7. 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 (Edit icon) to open the Update Connection page where you can fill in the missing details.
  8. Click Next.
  9. Similarly, define the target connection.
  10. Click Save.

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

Creating a Data Load from the Projects Page

To create a data load from the Projects page,

  1. On the Home page, click Projects, and then the required project title. 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.
  3. Add a description. This is optional.
  4. Select the source and target schemas.

    Note:

    Make sure that you have created connections before you plan to create a data load using the Projects page. See Work with Connections for more details about connections.
    • To use the OCI GoldenGate Deployment Console to load data entities:
      1. Select the Use GoldenGate checkbox.

        The Create Data Load page now shows fields that are specific to OCI GoldenGate.

      2. Select the GoldenGate connection from the drop-down.
      3. To select the source connection, select the Registered Database and the Schema.
      4. Similarly, define the target connection.
    • To use all other connection types to load entities:
      1. To define your source connection, select the connection from which you wish to add the data entities from the Connection drop-down.
      2. From the Schema drop-down select the schema that you want to use. 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).
  5. Click Create.

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