Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Appendix A: Data Type Reference
  21. Appendix B: Data Type Reference for Test Data Warehouse
  22. Appendix C: Data Type Reference for Hadoop
  23. Appendix D: 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.
Use Sorter Transformation
Use a Sorter transformation in the mapping to sort data. Required if the source and staging databases use different sorting techniques.
You cannot use the sorting technique if you select a Hadoop HDFS connection.
Use Batch Updates for Recursive Executor
Update rows in batches in a data subset operation on tables with cyclic or tending to cyclic constraints.
Source Connection
A connection to the source database. Choose a variable, relational, or Hadoop HDFS connection from the list. Select the variable name or select a source connection from the list. If you choose to enter a variable, the list of variables includes global parameters and project parameters. Global parameters are indicated with an asterisk (*).
You cannot use a Hadoop HDFS connection as a variable when you configure a source.
In a Hadoop plan, you can select a Hive or an HDFS connection.
Source Connection Directory Path
Displays if flat file sources are present. Enter the path to the flat file source directory.
Target Connection
Choose a variable, relational, test data warehouse, flat file, or Hadoop HDFS connection from the list. Select a target connection or a variable name from the list. You cannot use a Hadoop HDFS connection as a variable when you configure a target. If you choose to enter a variable, the list of variables includes global parameters and project parameters. Global parameters are indicated with an asterisk (*).
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.
In a Hadoop plan, you can select a Hive or an HDFS connection.
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.
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.

0 COMMENTS

We’d like to hear from you!