Oracle Cloud Infrastructure Documentation

Mapping a Reference

References in Data Integration are the data assets, connections, and schemas that are associated with published tasks in an application. Mapping lets you map or replace a reference to a data asset, connection, and schema resource.

For example, if a data asset or connection object is deleted in the workspace, you can map the data asset or connection reference to another data asset or connection object. Similarly, when you create an application as a copy of another application, you can map a schema reference to another schema.

If an application has pipeline tasks, you can map or replace a task reference in a pipeline. You can map to published tasks in another application in the same workspace or in another workspace.

    1. On the workspace home page, click Applications.
    2. On the Applications page, select the compartment that contains the application.
    3. In the applications list, click the name of the application that has the reference that you want to map.
    4. On the application details page, click References.
    5. To map a data asset, connection, or schema reference, click Data assets in the References section.

      To map a connection, you must first map the data asset. To map a schema, you must first map the connection. Follow these steps for the reference that you want to map:

      1. For a reference that doesn't show a name link in the Mapped to column, click Map.
      2. For a reference that shows a name link in the Mapped to column, select Edit mapping from its Actions menu.
      3. In the Map <type> reference panel, select one of the available objects and click Map.
        Only the following mapping types are permitted:
        • From Database to Database
        • From Object Storage to Object Storage
        • From Object Storage to Database
        Note

        You can't map a Database asset reference to an Object Storage asset.
    6. To map tasks in a pipeline, click Tasks in the References section. Follow these steps for the reference that you want to map:
      1. For a reference that doesn't show a name in the Mapped to column, click Map.
      2. For a reference that shows a name in the Mapped to column, select Edit from its Actions menu.
      3. In the Map <type> task reference panel, select the application that contains the tasks that you want, or select the compartment and workspace and then the application.
      4. In the list of tasks, select the check box for the task that you want to map to.

        Only tasks of the same type and with the same input parameters can be mapped.

      5. Click Map.

  • Use the oci data-integration reference update command and required parameters to update and map references in an application in Data Integration:

    oci data-integration reference update [OPTIONS]

    For a complete list of flags and variable options for CLI commands, see the Command Line Reference.

  • Run the UpdateReference operation to update and map references in an application in Data Integration.