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. Data Type Reference for Hadoop
  23. Glossary

Entity Views

Entity Views

Create, edit, and delete entities in the
Define | Data Subset
view of a project.
When you create an entity, you define a driving table for the entity. The driving table is a starting point for determining the structure of the entity. Test Data Manager determines the rest of the tables in the entity based on the constraints that include the driving table.
When you create an entity, you can configure it with the following views:
Entity Map
The
Entity Map
view is a graphical representation of the tables in the entity and the relationships between the tables. You can disable and enable relationships, and edit filter criteria for each table in the
Entity Map
view.
If you drag the entity map panel to the left, a
Table Properties
panel appears that includes information about a selected table or constraint. If you click the link between two tables, the
Constraint Properties
panel appears.
You can change which tables you view in the entity map. You can view all the tables or you can view the tables by their relationships with a selected table. By default the entity map shows enabled relationships.
You can choose the
Show excluded tables
option with any of the views to show disabled relationships.
Select one of the following views:
All
Shows all tables in the entity.
All parents
Shows all the parent tables of a selected table.
All immediate relationships
Shows the tables that have constraint relationships with a selected table. You can view one level of parent and child tables from the selected table.
All children
Shows all the child tables of a selected table.
All cyclic relationships
Shows all constraint relationships that create cyclic relationships. The maximum number of cyclic relationships that TDM displays is 1000. You can choose to hide nodes and paths that are not a part of the cycles.
You can select any table in the map to edit the filter criteria. You can click a link to edit the constraint between the tables. You can disable relationships between tables from the map. When you select links in the
Entity Map
view, the corresponding rows are selected in the
Relationships
view.
You might define the driving table as Employee. Employee has a primary key, EmpID. Employee has three child tables that have the EmpID foreign key. The EmployeeBankDetails child table has an AccountNum constraint that relates EmployeeBankDetails to a BankAccounts table. When you create an entity with Employee as the driving table, Test Data Manager might create an entity map similar to the following map:
In the entity map, arrows point from the Employee driving table to the EmployeeAddressDetails, EmployeeBankDetails, and EmployeeDetails tables. An arrow points from the EmployeeBankDetails table to the BankAccounts table.
The driving table icon contains a star in the entity map.
To add a filter criteria for Employee, click the Employee table in the entity map. Edit the filter criteria from the Table Properties panel.
When you click the links between the Employee, EmployeeBankDetails, and BankAccounts table, the corresponding rows are selected in the
Relationships
view.
Tables
The
Tables
view contains a list of the tables in the entity. You can edit filter criteria for each table in the
Tables
view.
The
Tables
view shows the table name, description, and the name of the database that contains the table. The status field indicates whether the entity includes or excludes the table. When you disable a relationship in the entity and the table is not related to any table in the entity map, the table is excluded from the data subset database.
Relationships
The
Relationships
view shows a list of relationships in the entity. For each constraint, the view shows the parent table, the child table, and the database names for each table in the relationship. You can disable and enable relationships between tables in the
Relationships
view.
When a table has more than one relationship in an entity, the table appears more than once in the view. The
Status
field indicates whether the relationship is enabled or disabled.
When you select a row in the
Relationships
view, the corresponding link is selected in the
Entity Map
view. To generate test data, you can select a relationship and specify the number of child records that you want in the target.