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

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.
To use parameters in an entity, you must create the entities in the project before you create 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 and click
    OK
    .
  6. Click
    Save
    to create the entity.
    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 the
    Add Criteria
    button.
  10. Select the columns on which you want to filter data and click
    OK
    .
    The columns that you selected appear in the columns list in the
    Entity Criteria
    tab.
  11. To define the filter expression in the entity, select the attribute from the Attribute list. Choose
    Value
    to enter a value or
    Parameter
    to enter a parameter name.
    You can indicate a filter condition in the entity, but define the expression in the plan. You can choose to create multiple criteria with parameters and include required parameters when you run a workflow.
  12. Select an operator from the list to filter the data.
  13. If you enter a filter condition, enter a specific value or choose the variable from the list of variables to complete the filter expression.
  14. Click
    Save
    for each filter criteria that you create. If you define multiple filters in an entity, the filter conditions act as "AND."
  15. Click
    Save
    to exit the
    Edit Criteria
    dialog box.