Importing a Subset Definition

There are three methods of import:

  • Import a subset definition XML file from the desktop

  • Import a subset dump

  • Import a subset definition XML file from the Software Library

To import a subset definition XML file from your desktop:

  1. From the Actions menu, select Import, then select File from Desktop.

  2. In the pop-up that appears:

    • Specify a name for the subset definition

    • The ADM on which the subset is based

    • A source database

    • The location on your desktop from which you want to import the subset definition

    • Click Continue

  3. In the pop-up that appears:

    • Enter a descriptive job name (or accept the default)

    • Provide credentials

    • Schedule the job

    • Click Submit

    After the job runs successfully, the imported subset appears in the list of subsets in the table on the Data Subset Definitions page.

To import a subset dump:

  1. From the Actions menu, select Import, then select Subset Dump.

  2. In the pop-up that appears:

    • Select a target database

    • Provide database and host credentials, then click Login.

    • Specify the location of the dump file, which can be in a selected directory on the target database or at a custom path on the target. Note that if the original export action used an external location for the dump files, the location must be specified as well.

    • Click Continue.

  3. In the pop-up that appears:

    • Select whether to import both metadata and data, or data only. If data only, indicate if you want to truncate, that is, overlay existing data or append to existing data.

    • Perform tablespace remapping as necessary

    • Perform schema remapping as necessary

    • Select log file options

    • Click Continue

  4. In the pop-up that appears:

    • Enter a descriptive job name (or accept the default)

    • Schedule the job

    • Click Submit

    The job reads the dump files and loads the data into the selected target database.

To import a subset definition XML file from the Software Library:

  1. From the Actions menu, select Import, then select File from Software Library.

  2. In the Import Data Subset Definition from Software Library pop-up that appears:

    • Selected the desired subset definition XML file on the left

    • Provide the ADM properties on the right.

    • Click Continue

  3. In the pop-up that appears:

    • Enter a descriptive job name (or accept the default)

    • Provide credentials

    • Schedule the job

    • Click Submit

    After the job runs successfully, the imported subset appears in the list of subsets in the table on the Data Subset Definitions page.