Common Content for Data Integration
- Common Content for Data Integration 10.5.6
- All Products
Option
| Description
|
---|---|
Location
| Node name for the location of the PowerExchange Listener that connects to Adabas. The node name is defined in the first parameter of the NODE statement in the PowerExchange dbmover.cfg configuration file.
|
User Name
| Database user name.
For a database on a supported Linux or UNIX system, if you have enabled PowerExchange LDAP user authentication, the user name is the enterprise user name. For more information, see the
PowerExchange Reference Manual .
|
Password
| Password for the database user name or a valid PowerExchange passphrase.
A PowerExchange passphrase can be from 9 to 128 characters in length and can contain the following characters:
Passphrases cannot include single quotation marks (‘), double quotation marks (“), or currency symbols.
To use passphrases, ensure that the PowerExchange Listener runs with a security setting of SECURITY=(1,N) or higher in the DBMOVER member. For more information, see "SECURITY Statement" in the
PowerExchange Reference Manual .
The allowable characters in the IBM IRRPHREX exit do not affect the allowable characters in PowerExchange passphrases.
A valid RACF passphrase can be up to 100 characters in length. PowerExchange truncates passphrases longer than 100 characters when passing them to RACF for validation.
|
Code Page
| Required. Name of the code page to use for reading from or writing to the data source. Usually, this value is an ISO code page name, such as ISO-8859-6.
|
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.
|
Encryption Type
| The type of encryption that the Data Integration Service uses. Select one of the following options:
Default is None.
Informatica recommends that you use Secure Sockets Layer (SSL) authentication instead of configuring the
Encryption Type and
Level connection properties. SSL authentication provides stricter security and is used by several Informatica products.
For more information about implementing SSL authentication in a PowerExchange network, see the
PowerExchange Reference Manual .
|
[Encryption] Level
| If you select
AES for
Encryption Type , select one of the following options to indicate the encryption level that the Data Integration Service uses:
If you do not select
AES for
Encryption Type , this option is ignored.
Default is 1.
|
Pacing size
| Optional. Amount of data that the source system can pass to the PowerExchange Listener. Set the pacing size if an external application, database, or the Data Integration Service node is a bottleneck. User lower values for faster performance.
The minimum value and default value is 0. A value of 0 provides the best performance.
|
Interpret as rows
| Optional. Select this option to express the pacing size as a number of rows. Clear this option to express the pacing size in kilobytes. By default, this option is not selected and the pacing size is in kilobytes.
|
Compression
| Optional. Select this option to enable source data compression. By compressing data, you can decrease the amount of data that Informatica applications send over the network. By default, this option is not selected and compression is disabled.
|
Offload processing
| Optional. Controls whether to offload some bulk data processing from the source machine to the Data Integration Service machine. Select one of the following options:
Default is AUTO.
|
Worker threads
| Optional. Number of threads that the Data Integration Service uses to process bulk data when offload processing is enabled. For optimal performance, this value should not exceed the number of available processors on the Data Integration Service machine. Valid values are 1 through 64. Default is 0, which disables multithreading.
|
Array size
| Optional. The number of records in the storage array for the worker threads. This option is applicable when you set the
Worker Threads option to a value greater than 0. Valid values are 1 to 5000. Default is 25.
|
Write mode
| Optional. Mode in which Data Integration Service sends data to the PowerExchange Listener. Select one of the following write modes:
Default is
CONFIRMWRITEON .
|