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. Data Sets
  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. Data Type Reference for Hadoop
  22. Glossary

Connection Properties

Connection Properties

The following table describes connection options that you can configure at the data source level and the table level:
Connection Options
Description
Source Connection
A connection to the source database. Select a source connection from the list. For Hadoop sources, you can select a Hive or an HDFS connection.
Source Connection Directory Path
The path to the flat file source directory. Appears if flat file sources are present.
Source Filename
The name of the source file. Required if the source is a flat file. Default is <name of selected source>.dat.
Target Connection
A connection to the target database or the target file. Choose relational or flat file from the list. Select a target connection from the list. For Hadoop targets, you can select a Hive or an HDFS connection.
Target JDBC Connection
Appears if you select ODBC target connection. The connection that contains the JDBC connection string of the ODBC target database. Required if ODBC does not support the data type, if you disable indexes and constraints, and if you want to perform data masking, data subset, and data generation operations. Optional if you want to perform simple data movement operations.
Output Filename
The name of the target file. Required if the target is a flat file. Default is <name of selected source>.out.
Column Delimiter
A character that separates columns from each other in the .csv file. Required if the source is a flat file. Default is a comma (,).
Row Separator
A character that separates columns from each other in the .csv file. Required if the source is a flat file. Default is a pair of double quotes ("").
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.
Lookup Connection
Connection to a database that contains lookup tables. Required if the plan has a mapplet rule which includes a transformation. Choose relational or flat file from the list. Select a 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.