Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Glossary

Creating an Entity

Creating an Entity

When you create an entity, you select the driving table. Test Data Manager retrieves the related tables based on the constraints. You can add filter criteria to the driving table to filter source data when you create the data subset database. You can disable relationships between tables in the entity.
Before you create an entity, perform data discovery to identify constraints. Add constraints to the source to define the child tables.
  1. Open a project.
  2. Click
    Define
    Data Subset
    .
  3. Click
    Actions
    New
    Entities
    .
  4. In the
    New Entity
    dialog box, enter a name and optional description for the entity.
  5. Click
    Select Table
    to select a driving table from the list.
  6. Click
    OK
    .
    Test Data Manager displays a diagram of the relationship between the tables in the entity. You can view a list of the tables or a list that shows the relationships between the tables.
  7. To create a subset of the data based on filter criteria, click
    Edit
    in the
    Properties
    pane.
    The
    Edit Criteria
    dialog box appears.
  8. To add criteria for a column, click the
    Entity Criteria
    tab.
  9. Click
    Add Criteria
    .
  10. Select the columns on which you want to filter data and click
    OK
    .
    The columns that you selected appears in the columns list in the
    Entity Criteria
    tab.
  11. If you want to define the filter expression in the entity, select an operator from the list to filter the data.
    You can indicate a filter condition in the entity, but define the expression in the plan.
  12. If you enter a filter condition, enter a specific value or a variable to complete the filter expression.
    If you want to provide a variable in the entity criteria, you must start the parameter value with "$$" for nonrelational sources. For relational sources, you must start the parameter value with "$".
  13. Click
    Save
    for each filter criteria that you create. If you define multiple filters in an entity, the filter conditions act as "AND."
  14. Select the rows and click
    Save
    to exit the
    Edit Criteria
    dialog box.