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. Dictionaries
  10. User-Defined Datatypes

Teradata FastExport Connections

Teradata FastExport Connections

You can create a Teradata FastExport connection in Test Data Manager to perform data subset and data masking operations.
The following table describes the database connection properties to access Teradata through FastExport:
Property
Description
Name
Required. Name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, start with a number, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
Connection Type
Required. The connection type. Select Teradata FastExport.
Description
The description of the connection. The description cannot exceed 255 characters.
User Name
Required. The database user name.
Use Parameter in Password
Indicates the password for the database user name is a session parameter. $Param
Name
. Define the password in the workflow or session parameter file, and encrypt it using the
pmpasswd
CRYPT_DATA option.
Used for data subset and data masking operations. Default is disabled.
Password
Required. The password for the database user name.
Owner
The owner of the connection. Default is the user who creates the connection. You can change the owner of the connection.
JDBC Login Password
Required if Use Parameter in Password is selected. The password for the JDBC user.
Used for import from source and data discovery operations.
Code Page
The code page that the Integration Service uses to extract data from the source database.
Database Name
The name of the Teradata database you want to connect to. The Integration Service generates the SQL statement using the database name as a prefix to the table name.
TDPID
Teradata database ID.
Tenacity
Number of hours that FastExport tries to log on to the Teradata database. When FastExport tries to log on but the maximum number of Teradata sessions is already running, FastExport waits for the amount of time defined by the Sleep option. After the Sleep time, FastExport tries to log on to the Teradata database again. FastExport repeats this process until it has either logged on for the required number of sessions or exceeded the Tenacity hours time period.
Default is 4.
Max Sessions
Maximum number of FastExport sessions per FastExport job. Max Sessions must be between 1 and the total number of access module processes (AMPs) on your system.
Default is 4.
Sleep
Number of minutes FastExport pauses before retrying a login. FastExport attempts a login until the login succeeds or the Tenacity hours elapse.
Default is 6.
Data Encryption
Enables data encryption for FastExport. You can use data encryption with the version 8 Teradata client.
Default is disabled.
Block Size
Maximum block size to use for the exported data.
Default is 6400.
Log Table Name
Restart log table name. The FastExport utility uses the information in the restart log table to restart jobs that halt because of a Teradata database or client system failure. Each FastExport job should use a separate log table. If you specify a table that does not exist, the FastExport utility creates the table and uses it as the restart log. PowerCenter does not support restarting FastExport, but if you stage the output, you can restart FastExport manually.
Executable Name
Teradata command used to read the source data. Use the default value.
Default is fexp.