Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Plans and Workflows
  11. Monitor
  12. Reports
  13. ilmcmd
  14. Data Type Reference
  15. Data Type Reference for Hadoop

Importing Data Sources

Importing Data Sources

Import data sources from the Model repository or from an external database to a project in Test Data Manager.
  1. To view a list of the projects in Test Data Manager, click
    Projects
    .
  2. Click a project in the list to open it.
  3. Click
    Actions
    Import Metadata
    .
    The
    Import Metadata
    window appears.
  4. Choose one of the following options:
    • Model Repository. Import metadata from the Model repository.
    • Datasource Connection. Import metadata from a database connection.
    To import metadata from a flat file source or a JDBC connection, you must import metadata from the Model repository
  5. Choose whether you want to review the metadata changes before you import the data sources. Test Data Manager displays the information before the import runs. You can choose to skip the import option.
    Test Data Manager shows you the metadata you are importing and the impact on domain assignments or groups in Test Data Manager.
  6. Optional. If you select an Oracle database connection, you can choose to ignore the tables that do not contain any data.
    Test Data Manager excludes all the empty tables in the Oracle database and lists the tables that contain data.
  7. Click
    Next
    .
  8. Choose one of the following options:
    • If you selected
      Model Repository
      , select the Model Repository folder that contains the data source you want to import. You can filter folders by the folder name or the description.
    • If you selected
      Datasource Connection
      , select the schema to import. You can filter schemas by schema name.
  9. Click
    Next
    .
  10. Select the files or tables that you want to import. You can filter the tables by data source, table name, or table description. If you choose a Hive database and if there are temporary junk tables present in the schema, ensure that you do not select those tables.
  11. Click
    Next
    .
  12. Choose when to import the sources. Choose one of the following options:
    • Import Now. Import the data source immediately. To run the import in the background, select
      Run import in the background
      .
    • Schedule Later. Schedule the import to occur at a specific date and time. Click the calendar to select a date. Use the hour and minute sliders to set the time.
  13. Click
    Finish
    .
    The
    Import Progress
    dialog box appears with the import progress bar.
    If you chose to review metadata changes before importing, the
    Impact Review
    dialog box appears with the metadata, assignments, and project objects. Review the impact, and click
    Approve
    to approve the changes or click
    Reject
    to reject the changes. If you approve the changes, TDM imports the metadata successfully.
After the job finishes, access the imported metadata through the
Data Sources
details view.