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. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Glossary

Importing Data Sources

Importing Data Sources

Import data sources from PowerCenter 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:
    • PowerCenter Repository. Import metadata from PowerCenter.
    • Datasource Connection. Import metadata from a database connection.
  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 rules and domain assignments or entities and groups in Test Data Manager.
    Test Data Manager shows you the metadata you are importing and the impact on rules and domain assignments or entities and groups in Test Data Manager.
  6. 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
      PowerCenter Repository
      , select the PowerCenter 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.
  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.
  14. View the progress of the import job in the
    Monitor
    view.
    If you chose to import review changes, the
    Impact Review
    dialog box appears with the metadata, assignments, and project objects.
  15. Review the impact, and approve or 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.