Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Connections

Connections

IDMS connection properties

IDMS connection properties

When you configure an IDMS connection, you must set the connection properties.
The following table describes IDMS connection properties:
Property
Description
Connection Name
A name for the IDMS connection. This name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
Spaces at the beginning or end of the name are trimmed and are not saved as part of the name.
Maximum length is 100 characters. Connection names are not case sensitive.
Description
Description of the IDMS connection. Maximum length is 4000 characters.
Type
Type of connection. For IDMS, the type must be
IDMS
.
Runtime Environment
Name of the runtime environment that contains the Secure Agent that you want to use to run mapping tasks.
Listener Location
Host name or IP address of the system where the PowerExchange Listener that processes requests for IDMS runs. Also include the Listener port number. Enter the value in the following format, where
host_name
can be a host name or IP address:
host_name
:
port_number
For example:
PWXMLSNR:14673
User Name
A user name that can be used to access the PowerExchange Listener when PowerExchange Listener security is enabled. For more information, see the SECURITY statement in the
PowerExchange Reference Manual
.
Password
Password that is associated with the user name that is specified in the
User Name
property.
Schema Name
The schema name of the IDMS source.
Code Page
The code page that the Secure Agent for the Data Integration Service uses to extract data from the source database.
Offload Processing
Controls whether to use offload processing. Offload processes transfers bulk data processing from the source system to the target system. Options are:
  • Auto
    . Cloud Data Integration determines whether to use offload processing.
  • Filter After
    . Offloads the bulk data processing to the target, including the filtering of data.
  • Filter Before
    . Offloads processing to the target but continues to filter data on the source system.
  • No
    . Disables offload processing.
Default is No.
Offload Threads
The number of threads that Cloud Data Integration uses to process bulk data.
For optimal performance, this value should not exceed the number of installed or available processors on the machine where the secure agent runs.
Valid values are 1 through 64.
Default is 0, which disables multithreading.
Not all connection types support offload threads. If the
Offload Threads
connection property for one of these connections is set to a nonzero value, processing continues without threads.
Array Size
For IDMS data sources and sequential files, the size of the storage array, in number of records, that is used for partitioned or multithreaded sessions.
For partitioned sessions, this array size is shared across the partitions. For multithreaded sessions, each thread has this array size.
Valid values are from 1 through 5000. Default is 25.
To tune partitioned sessions, particularly when the
Write Mode
property specifies
Confirm Write On
, increase the array size.
Replace Low Values with Spaces
Controls whether to replace embedded nulls in character data with spaces. Select this property to replace embedded nulls. By default, this property is selected.
Connection Retry Period
Number of seconds that the PowerExchange Bulk Reader tries to reconnect to the PowerExchange Listener after the initial connection attempt fails. If a connection cannot be established within the retry period, the mapping task fails. The default is 0, which disables connection retries.
Custom Properties
Custom properties that you can specify to override PowerExchange default settings. You can enter multiple properties by using a semicolon (;) as the separator. Set custom properties only at the direction of Informatica Global Customer Support.
These properties are equivalent to the
PWX Override
options for the PowerExchange Client for PowerCenter (PWXPC) IDMS connections in PowerCenter.
Write Properties > Write Mode
Options are:
  • Confirm Write On
    . Sends data to the PowerExchange Listener and waits for a success or no success response before sending more data. This mode sends data synchronously to the PowerExchange Listener rather than buffering the data.
  • Confirm Write Off
    . Sends data asynchronously to the PowerExchange Listener by buffering the data. This mode does not wait for a success or no success response.
Default is
Confirm Write On
.

0 COMMENTS

We’d like to hear from you!