TDM Architecture
The TDM architecture consists of tools, the TDM server, the Test Data Manager Service and other application services, and databases.
The following image shows the components of TDM:
The TDM architecture consists of the tools that you use to modify the data.
The application services include Model Repository Service, Data Integration Service, PowerCenter Repository Service, PowerCenter Integration Service, and Test Data Manager Service. The Model Repository Service and Data Integration Service access the Model repository and profiling warehouse.
Test Data Manager accesses the Test Data Manager Service and uses the database content from the TDM repository and the test data repository. PowerCenter services access the PowerCenter repository. The application services access the domain configuration repository and Model repository that maintain connections and metadata for the domain.
TDM Tools
TDM tools consist of Test Data Manager, Informatica Administrator, and the PowerCenter Client.
You can use the following tools to perform administrative tasks for TDM:
- Test Data Manager
- A web-based application that you can use to create connections, configure the test data warehouse, integrate a test tool with TDM, and manage preferences and dictionaries.
- Informatica Developer
- A client application that you use to create and export profiles for data discovery.
- Informatica Administrator
A web-based client that a domain administrator uses to manage application services and create users and user groups.
- PowerCenter Client
- A client application that you use to configure permissions on folders and connection objects for the PowerCenter repository.
TDM Server
The TDM Server runs the Test Data Manager and integrates with the Test Data Manager Service and other Informatica application services to perform data subset, data masking, data generation, and data discovery operations.
TDM Services
TDM application services consist of the Test Data Manager Service, profiling services, and PowerCenter application services. The application services are created in the Administrator tool.
TDM requires the following services:
- PowerCenter Repository Service
- An application service that manages the PowerCenter repository. The PowerCenter Repository Service accepts requests from the PowerCenter Integration Service when a workflow runs.
- PowerCenter Integration Service
An application service that runs workflows that users generate in the Test Data Manager for data subset and data masking operations. When you configure workflow options, you can select the PowerCenter Integration Service that runs workflows for users.
- Model Repository Service
- An application service that manages the Model repository for data discovery operations.
- Data Integration Service
- An application service that performs data discovery operations. The Data Integration Service connects to the Model Repository Service to store metadata from data discovery profiles in the Model repository. When you run a profile, the Data Integration Service also stores data from data discovery profiles in the profiling warehouse. The Data Integration Service performs data movement and data masking operations in the Hadoop environment. To run a Hadoop plan, TDM uses the Data Integration Service to push down the transformation logic into Hadoop clusters.
- Analyst Service
- Manages the Analyst tool that TDM uses to link TDM global objects to objects in the Business Glossary. The license for the Analyst Service to use database content from the TDM repository.
- Test Data Manager Service
- The TDM application service that manages the TDM repository. The Test Data Manager accesses the Test Data Manager Service to use database content from the TDM repository.
TDM Databases
The databases component of TDM consists of the TDM repository, the Model repository, the PowerCenter repository, the profiling warehouse, the test data repository, and the domain configuration repository.
TDM uses the following databases:
- TDM repository
- A relational database that contains tables that TDM requires to run and the tables that store metadata.
- Model repository
- A relational database that stores table metadata for data discovery profiles and the connections that you create in Test Data Manager.
- PowerCenter repository
- A relational database that stores all of the metadata required to run workflows.
- Profiling warehouse
- A relational database that stores profile results for data discovery.
- Test data repository
- A relational database that stores the test data warehouse metadata.
- Domain configuration repository
- A relational database that stores the connections used to run profiles, users for the Informatica domain, and metadata for the Informatica domain.
TDM Connections
To perform data discovery, data subset, data masking, and data generation operations, you need a profiling connection, a repository connection, and source and target database connections.
To perform data discovery operations, an application requires connections to a database source and a Data Integration Service. To perform data subset and masking operations, workflows that you generate from plans require connections to services, the TDM repository, the PowerCenter repository, and source and target databases. To perform data generation operations, workflows that you generate from plans require connections to services, the TDM repository, the PowerCenter repository, and target schema metadata. Workflows for operations to store data in the test data mart require a connection to the test data repository.
TDM uses the following connections:
- •Profiling connection. Create a connection to the Data Integration Service that you want to run data discovery operations. The profiling connection includes connection details for the Model Repository Service associated with the Data Integration Service.
- •TDM repository connection. Create a connection to the TDM repository when you create the Test Data Manager Service from the Administrator tool. Test Data Manager uses the TDM repository to store the metadata from sources that you import.
- •PowerCenter repository connection. Create a connection to the PowerCenter repository that you want to store workflow metadata. If the TDM repository and the PowerCenter repository exist in the same schema, copy the connection information for the TDM repository.
- •Test data repository connection. Create a connection to the test data repository from the Administrator | Repository and Data Mart view. Test Data Manager uses the test data repository to store the metadata for data set versions that you create in the test data mart.
- •Database connections. Create connections to the source and target databases to perform data discovery, data subset, and data masking operations. Create a connection to configure it as the test data mart to create data set versions. Import target metadata schema into the TDM repository to perform data generation operations. When you create a database connection in Test Data Manager, you define connection information for workflows and profiles. When you run a workflow or profile, the Test Data Manager uses the connection information to create connection objects in the PowerCenter repository or the Model repository.
- •Test tool connection. To run workflows to copy flat file results to a test tool, you must first integrate the test tool server with TDM. TDM connects to the integrated server to copy the flat file to the configured location.
