Test Data Management
- Test Data Management 10.5.3
- All Products
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 Oracle.
|
Description
| The description of the connection. The description cannot exceed 255 characters.
|
Use Kerberos Authentication
| Enables Kerberos Authentication. You cannot enter a user name and password if you select this check box.
|
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.
|
Metadata Connection String
| Required. The JDBC connection URL used to access metadata from the database. Enter jdbc:informatica:oracle://<hostname>:1521;SID=<sid>.
Used for all operations.
|
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
| Code page the Integration Service uses to read from a source database or write to a target database or file.
Used for all operations.
|
Data Access Connection String
| The native connection string to the database. Connection string to preview data and run mappings. Enter dbname.world from the TSNAMES entry.
Used for all operations.
|
Environment SQL
| SQL commands to set the database environment when you connect to the database. The
Integration Service executes the connection environment SQL each time it connects to the database.
Used for all operations.
|
Transaction SQL
| SQL commands to set the database environment when you connect to the database. The
Integration Service runs the transaction environment SQL at the beginning of each transaction.
Used for all operations.
|
Connection Retry Period
| Number of seconds the Integration Service attempts to reconnect to the database if the connection fails. If the Integration Service cannot connect to the database in the retry period, the operation fails.
Used for all operations. Default is 0.
|
Enable Parallel Mode
| Enables parallel processing when loading data into a table in bulk mode.
Used for all operations. Default is disabled.
|
Pass Through Security Enabled
| Enables pass-through security for the connection. When you enable pass-through security for a connection, the domain uses the client user name and password to log into the corresponding database, instead of the credentials defined in the connection object.
Used for data discovery operations. Default is disabled.
|