| 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.
|