Data Integration Connectors
- Data Integration Connectors
- All Products
Connection Override
| Description
|
---|---|
User Name
| A user name for connecting to the database.
|
Password
| A password for the specified user or a valid passphrase.
|
Compression
| Specifies whether or not to compress source data. Valid values are:
Default is N.
|
Encryption Type
| Specifies the encryption level to use. Valid values are: AES
This attribute has no default.
You must specify both Encryption Type and Encryption Level.
|
Encryption Level
| Specifies the encryption level to use. Valid values are: 1. AES 128, 2. AES 192, and 3. AES 256.
Default is 1.
You must specify both the Encryption Type and the Encryption Level.
|
Pacing Size
| Specifies the pacing size. Valid values are: 0 to 999999999.
Default is 0.
|
Interpret as Rows
| Specifies whether to represent the pacing size in number of rows. Valid values are:
Default is Y.
|
Image Type
| Indicates whether Data Integration should send captured Updates as Updates, or as Deletes followed by Inserts. Valid values are:
Default is BA.
|
Application Name
| Uniquely identifies the GMD application.
|
RestartToken File Name
| Fully qualified restart file name.
|
Number of Runs to Keep RestartToken File (*)
| The maximum number of backup copies to keep of the restart token file. Valid values are: 0 to 9999.
Default is 0.
|
Recovery Cache Folder
| The name of the file cache folder that is used for recovery of the session.
Default is
$PMRootDir/Cache .
|
UOW Count
| The number of units of work (UOWs) that Data Integration processes before it sends a commit request to commit data to all targets in the CDC session. Valid values are: 1 to 999999999.
Default is 1.
|
Convert character data to string
| Controls whether to convert character fields to string fields so that embedded nulls in data are processed as spaces. Valid values are:
Default is N.
|
Retrieve PWX log entries
| Controls whether Data Integration writes informational messages related to a CDC session in the session log. Valid values are:
Default is Y.
|
Continuous Extraction
| Valid values are:
Default is 0.
|
Real-time Flush Latency in milli-seconds
| The number of milliseconds that must elapse before Data Integration sends a commit request to commit data to all targets in the CDC session. When this period elapses, Data Integration continues to read the changes in the current UOW until it reaches the end of the UOW. Then Data Integration sends a commit request so that the data can be committed to the targets.
Valid values are: 0 to 999999999.
Default is 0.
The Real-time Flush Latency in milliseconds, Maximum Rows Per Commit, and Minimum Rows Per Commit attributes work together to control commit frequency.
|
Maximum Rows Per Commit
| The maximum number of change records that Data Integration processes before it sends a commit request to commit data to all targets in the CDC session. Data Integration does not wait for a UOW boundary to commit the change data.
Valid values are: 0 to 999999999.
Default is 0.
The Real-time Flush Latency in milliseconds, Maximum Rows Per Commit, and Minimum Rows Per Commit attributes work together to control commit frequency.
|
Minimum Rows Per Commit
| The minimum number of change records that the PowerExchange Listener must read from the change stream before it passes a commit record to the target. Before reaching this minimum, the PowerExchange Listener passes only change records to Data Integration and discards any commit records.
Valid values are: 0 to 999999999.
Default is 0.
The Real-time Flush Latency in milliseconds, Maximum Rows Per Commit, and Minimum Rows Per Commit attributes work together to control commit frequency.
|
Event Table
| The source event table.
|
CAPI Connection Name Override
| A name that overrides the default CAPI connection name.
|