Oracle Cloud Infrastructure Documentation

Importing a Project

Import a whole project to a workspace in Data Integration.

When importing, you have the option to exclude importing data assets that already exist in the target. If you exclude existing data assets in an import request, Data Integration performs the following actions:

  • If source objects have references to data assets that are already present in the target, Data Integration does not import those data assets or touch the existing data assets in the target.

  • If source objects have references to data assets that are not present in the target, Data Integration imports those data assets to the target. This ensures that objects such as data flows load correctly in the target after importing for the first time. In subsequent imports to the same target, this ensures that only new source data assets are imported to the target.

Before importing a project, see Considerations When Using Export and Import for information about objects that have references to objects across folders in a project.

To import a project, specify the exported project's zip file and its Object Storage location. Ensure that you have the relevant permissions and IAM policies as described in Required Setup and Policies.

Note

To import different object types separately into a project that's already created in a workspace, see Importing a Folder, Task, Data Flow, or Pipeline into an Existing Project.
    1. Navigate to the workspace in which you want to import a project.

      For the steps to access a workspace, see Accessing a Workspace.

    2. On the workspace home page, click Projects.
    3. On the Projects page, click Create project and select Import.

      The Create project menu is available only if you have write access to the workspace.

    4. In the Import project panel, enter the following details:

      • Tenancy OCID: Enter the Oracle Cloud ID of the tenancy that has the exported zip file that you want to import.

        The namespace is a system-generated value based on the tenancy OCID that you enter.

      • OCI region: Select the region in the tenancy.
      • Compartment: Select the compartment with the Object Storage bucket that contains the exported zip file.
      • Bucket: Select the bucket.

      • File name: Enter the file name of the exported project zip file.

        The file name must end with .project.zip.

    5. Select the action to perform if the exported zip file (source) contains objects with the same name as the objects in the target.

      During an import request, Data Integration uses the identifier values of source and target objects to match objects, and performs the import using the conflict resolution option that you specify.

      • Retain: Retains the objects that exist in the target.

        Source objects (including dependencies) with the same names are not imported to the target.

      • Replace: Replaces the target objects with the source objects.

      • Duplicate: Duplicates the source objects in the target by using the source object names with the strings that you provide for a prefix, suffix, or both.

        • String for prefix: The string is added to the beginning of the source name, for example, string_sourceName
        • String for suffix: The string is added to the end of the source name, for example, sourceName_string

        If you don't add either a prefix or a suffix, a prefix of the following format is added to the beginning of the imported object name in the target: IMPORTPREFIX_1234555

    6. Select the Exclude existing data assets checkbox if you don't want to import data assets that are already present in the target.

      When the checkbox is selected, Data Integration imports to the target only those source data assets that are not present in the target. Data assets that are already present in the target are not imported.

    7. Click Import.

      A notification message appears with a View import requests link. Click the link to monitor the request status on the Export/Import requests page. See Monitoring Export and Import Requests.

  • Use the oci data-integration import-request create command and required parameters to import a project:

    oci data-integration import-request create [OPTIONS]

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

  • Run the CreateImportRequest operation with the appropriate request details to import a project.