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

Connection Options

Connection Options

Enter source and target connections.
The following table describes connection options:
Connection Options
Description
Treat the subset criteria as a variable
Appears if you select at least one subset component in a plan. Use the subset criteria as a variable only when there is an entity with a parameter value instead of a specific value in the entity criteria. When you select this option, you must enter the parameter file name and parameter file path.
Use Source Connection as Target Connection
Use the same connection for source and targets. Use with inplace masking.
Source Connection
A connection to the source database. Select a source connection from the list.
Source Connection Directory Path
Displays if flat file sources are present. Enter the path to the flat file source directory.
Target Connection
Choose variable, relational, test data warehouse, or flat file connection from the list. Select a target connection from the list.
If you enter the target connection as a variable, ensure that you define the scope of the variable as
Global
or
Integration Service
in the parameter file.
In a multinode setup, if you use parameters to enter the connection information, the parameter file must be present on the node on which the Test Data Manager Service runs. The file must be in the same directory path on both nodes.
Target JDBC Connection
Appears if you select an ODBC target connection type. The connection that contains the JDBC connection string of the ODBC target database.
Required if the target connection type is ODBC and either of the following statements is true:
  • You want to disable and enable constraints in the plan.
  • The source connection type is ODBC and you want to generate mappings with the source data type.
Optional if the target is ODBC and you want to perform simple data movement operations.
Source File Directory
Appears if the project includes XML sources. Location of the source XML file. Enter the path to the XML source file directory. The source file must reside on the machine on which the PowerCenter Integration Service runs.
Default is the PowerCenter Integration Service process variable directory $PMSourceFileDir.
Target File Directory
Appears if the project includes XML sources. Enter the path to the XML target file directory. The path must be on the machine on which the PowerCenter Integration Service runs.
Default is the PowerCenter Integration Service process variable directory $PMTargetFileDir.
Parameter File Name
Appears if one or more of the following conditions are true:
  • You select variable source and target connections.
  • You choose to treat the subset criteria as a variable.
  • You enter the seed value as a parameter or variable in a masking rule that you use in the plan.
The name of the parameter file that contains the entity parameter values and the variable names for source and target connections. Enter the name of the parameter file.
Parameter File Path
Appears if one or more of the following conditions are true:
  • You select variable source and target connections.
  • You choose to treat the subset criteria as a variable.
  • You enter the seed value as a parameter or variable in a masking rule that you use in the plan.
The path to the file that contains the entity parameter values and the variable names for source and target connections. Enter the path to the parameter file.
Source File Name
The name of the IMS source file or VSAM source file. If the source is a Hierarchical IMS file, enter the name of the source unload file. If the source is a Hierarchical VSAM/SEQ file, enter the name of the source file. Required if the source connection is PXW_NRDB Batch.
Target File Name
The name of the IMS target file or VSAM target file. If the target is a Hierarchical IMS file, enter the name of the target unload file. If the target is a Hierarchical VSAM/SEQ file, enter the name of the target file. The target file name must be different from the source file name. Required if the target connection is PXW_NRDB Batch.
Teradata ODBC Connection
Name of the Teradata ODBC connection. Required if the target connection is Teradata PT. Select a connection from the list.
Dictionary Lookup Connection
Connection to a database that contains lookup tables. Required if the plan has a dictionary generation rule assignment or a mapplet rule that includes a transformation. Choose relational or flat file from the list. Select a dictionary lookup connection from the list.
Dictionary Connection
A connection to the database that contains the dictionary table. The dictionary connection option does not appear unless the project contains a rule that requires a relational dictionary.
Email Dictionary Connection
A connection to the database that contains the email dictionary table. The email dictionary connection option does not appear unless the project contains a masking rule that requires a relational email dictionary.
Number of Records to Generate
Required. The number of records that you want to generate in the target table when you create a generation plan.
Reference Lookup Connection
A connection to the database that contains parent tables. Required if the generation plan has reference lookup rule assignment. Choose relational or flat file from the list. Select a dictionary lookup connection from the list.