Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Global Parameters
  10. Dictionaries
  11. User-Defined Datatypes

Connections Overview

Connections Overview

Create connections to databases to perform data subset, masking, and generation operations, and to run profiles for discovery operations.
You can create connections in TDM. You can also import connections that you created in PowerCenter and Informatica Administrator. When you create a connection in Test Data Manager, TDM stores the connection information in the Model repository.
Connection requirements depend on the operations that you need to perform. To perform a data discovery operation, TDM requires a connection to a database source. To perform data subset and data masking, TDM requires connections to source and target databases. To perform data generation, TDM requires a connection to a target database.
TDM supports some databases for certain TDM operations only. When you create a connection, relevant properties appear in the connection configuration wizard. For example, if you create a connection to a database that you cannot run a profile on, the wizard does not provide the unique profiling connection parameters.
To create a connection for a MySQL database, you use the ODBC connection type. If you use the connection as a target in a plan in which you disable and enable the constraints, you must enter a target JDBC connection. You enter a target JDBC connection in the plan to provide a JDBC connection string. Use the JDBC connection type to create a MySQL connection to enter as the target JDBC connection. You cannot use a connection that you create using the JDBC connection type as a source or target connection.
TDM supports SSL authentication for source and target connections. TDM supports Kerberos network authentication for some connection types. You can enable Kerberos authentication in the connection configuration wizard.
To restrict access to connections, you can assign permissions to connections that you create in Test Data Manager.
Create and manage connections from the
Administrator | Connections
view in Test Data Manager.