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

Database Connections

Database Connections

TDM requires a connection to a database source to perform data discovery operations and a database target to perform data generation operations. It also requires connections for relational sources and targets for data subset and data masking. To store data sets in the test data warehouse, TDM requires a connection to a test data warehouse.
Configure connections in the Administrator view of Test Data Manager. To connect TDM to databases, you do not need to install a separate driver. To create a test data warehouse, add the database connection and then configure the connection as the test data warehouse from the
Administrator | Test Data Warehouse
view in Test Data Manager.
When you generate workflows from data subset or masking plans, you must select connections for relational sources and targets. When you generate workflows from data generation plans, you must select connections for targets. Select these connections in Test Data Manager when you create a plan. TDM tests the connections when it generates workflows from plans, and the PowerCenter Integration Service uses the connections when it runs the workflows.