| Server |
Property ID: host
Type: string
(Required) The server host name.
Default value is localhost.
|
| Port |
Property ID: port
Type: int
(Required) Server port. If
port is set to -1,
the adapter reads from the Ephemeral Port File. Default
value is 12345.
|
| Match Stream Name |
Property ID: matchStreamName
Type: boolean
(Optional) Ignores messages if the
XML element name does not match the source stream name.
Default value is false.
|
| Ephemeral Port File |
Property ID: epFile
Type: filename
(Advanced) The file that contains
the server port number, if port is set to -1. Default value is
false.
|
| Retry period (seconds) |
Property ID: retryperiod
Type: uint
(Advanced) Indicates the time
period for attempting to re-establish an outgoing
connection, in seconds. Default value is 1.
|
| Enter Initial State |
Property ID: initial
Type: choice
(Advanced) Indicates when the
adapter enters the initial loading state. Default value is
never.
|
| Convert to Safe
Opcodes |
Property ID: safeOps
Type: boolean
(Advanced) Converts the opcodes
INSERT and UPDATE to UPSERT, and DELETE to SAFEDELETE.
Default value is false.
|
| Skip Deletes |
Property ID: skipDels
Type: boolean
(Advanced) Skips the rows with
opcodes DELETE or SAFEDELETE. Default value is false.
|
| Date Format |
Property ID: dateFormat
Type: string
(Advanced) Format string for
parsing date values. Default value is %Y-%m-%dT%H:%M:%S.
|
| Timestamp Format |
Property ID: timestampFormat
Type: string
(Advanced) Format string for
parsing timestamp values. Default value is
%Y-%m-%dT%H:%M:%S.
|
| Block Size |
Property ID: blockSize
Type: int
(Advanced) Number of records to
block into one pseudo-transaction. Default value is 1.
|
| Field Mapping |
Property ID: permutation
Type: permutation
Mapping
between Event Stream Processor and
external fields. Format is the
ESP column name equals
the database column name to which you are mapping. Multiple
mappings are separated by a colon. For example,
<esp_columnname>=<database_columnname>:<esp_columnname>=<database_columnname>.
No default value.
|
|
PropertySet
|
Property ID: propertyset
Type: string
(Advanced) Specifies the name of the property set.
Property sets are reusable sets of properties that are stored in the project
configuration file. Using these sets allows you to move adapter configuration properties
out of the CCL file and into the CCR file. If you specify the same properties in the
project configuration file and the ATTACH ADAPTER
statement, the values in the property set override the values defined in the ATTACH ADAPTER statement. No default value.
|