| Server |
host |
string |
(Required) The server host name. Default value is localhost. |
| Port |
port |
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 |
matchStreamName |
boolean |
(Optional)
Ignores messages if the XML element name does not match the source stream name. Default value is false. |
| Ephemeral Port File |
epFile |
filename |
(Advanced) The file that contains the server port number, if port is set to -1. Default value is false. |
| Retry period (seconds) |
retryperiod |
uint |
(Advanced) Indicates the time period for attempting to re-establish an outgoing connection, in seconds. Default value is 1. |
| Enter Initial State |
initial |
choice |
(Advanced) Indicates when the adapter enters the initial loading state. Default value is never. |
| Convert to Safe Opcodes |
safeOps |
boolean |
(Advanced) Converts the opcodes INSERT and UPDATE to UPSERT, and DELETE to SAFEDELETE. Default value is false. |
| Skip Deletes |
skipDels |
boolean |
(Advanced) Skips the rows with opcodes DELETE or SAFEDELETE. Default value is false. |
| Date Format |
dateFormat |
string |
(Advanced) Format string for parsing date values. Default value is %Y-%m-%dT%H:%M:%S. |
| Timestamp Format |
timestampFormat |
string |
(Advanced) Format string for parsing timestamp values. Default value is %Y-%m-%dT%H:%M:%S. |
| Block Size |
blockSize |
int |
(Advanced) Number of records to block into one pseudo-transaction. Default value is 1. |
| Field Mapping |
permutation |
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
|
propertyset |
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.
|