The Data Model in CA TDM Portal

A Data Model provides a solution to identify all table relationships across multiple data sources in an environment. After you have identified the table relationships, you can add new table relationships and edit existing table relationships. A Data Model is created using the relationships discovered during a scan. This Data Model allows you to visualize the relationships between table and data sources, so you can better understand data usage in your Environment.
tdm46
HID_data_discovery
CA TDM uses its Data Discovery process to create a Data Model, from analysis of your environment.
A Data Model provides a solution to identify all table relationships across multiple data sources in an environment. After you have identified the table relationships, you can add new table relationships and edit existing table relationships. A Data Model is created using the relationships discovered during a scan. This Data Model allows you to visualize the relationships between table and data sources, so you can better understand data usage in your Environment.
Data Discovery flow
Data Discovery flow
An Administrator logs in to CA TDM Portal and creates a project with a specific version for a Test Data Engineer (TDE) to perform Data Discovery.
A Data Discovery scan discovers table relationships based on the following critera:
  1. Foreign key relationships between tables.
  2. Column name matches along with common values within the tables.
After creation of the Data Model, you can add table relationships manually.
The Data Discovery process excludes some system entities by default, whose contents do not create meaningful data relationships. A full list of these exclusions is available at List of System Exclusions. The Data Discovery process excludes columns that only refer to the creation of data in the database ('Who' columns) from Primary Key relationship discovery - the Data Model only includes these columns' Foreign Key relationships.
Overview of Data Discovery process (creation of Data Model)
As a TDE, you need to perform the following steps in order to begin the Data Discovery process:
For a detailed guide to the Data Discovery process for the creation of a Data Model, see End-to-End Scenario for Data Discovery.
After you create a Data Model, you can do the following:
Data Model Terminology
  • Data Model
    refers to CA TDM's model of the entities it discovers in your environments through the Data Discovery process.
  • Data Discovery 
    refers to the process of identifying tables and relationships to create a reusable Data Model.
  • Environment 
    refers to a list of connection profiles. For more information about connection profiles, see Create and edit Connection Profiles.
    Connection Profiles are shared between Data Discovery using CA TDM Portal and Test Data Reservation Service. For more information about how to use Connection Profiles with Test Data Reservation Service, see Configure Test Data Reservation Service.