| 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
from the project configuration 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.
|