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. Appendix A: Data Type Reference
  21. Appendix B: Data Type Reference for Test Data Warehouse
  22. Appendix C: Data Type Reference for Hadoop
  23. Appendix D: Glossary

Importing Data Sources

Importing Data Sources

Import data sources from PowerCenter, 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:
    • PowerCenter Repository. Import metadata from PowerCenter.
    • 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 rules and domain assignments or entities and 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
      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
      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.

0 COMMENTS

We’d like to hear from you!