File XML Input Adapter

Adapter type: xml_in. The File XML Input adapter reads a file in XML format.

This adapter polls for new data appended to a file, and supports schema discovery.

If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type. The type for this adapter is xml_in.

Sample record format for the data file:

<Trades Id="0" Symbol="EBAY" TradeTime="2000-05-04T12:00:00" Price="140.0" Shares="50" />
<Trades Id="1" Symbol="EBAY" TradeTime="2000-05-04T12:00:01" Price="150.0" Shares="500" />

Property Label	Property ID	Type	Description
Directory	dir	`directory`	(Required) Specify the absolute path to the data files you want the adapter to read. For example, <username>/<folder name>. No default value.
File (in Directory)	file	`tables`	(Required) File the adapter writes data to. No default value.
Match Stream Name	matchStreamName	`boolean`	(Optional) If true, XML element name is matched against the stream name. Unmatched messages are discarded. Default value is false.
Repeat Count	repeatCount	`uint`	(Optional) Number of times the input data is repeated. If set to -1, the input data is repeated indefinitely. Default value is 0. Note: This parameter can be used for testing a continuous streaming source.
Repeat Field	repeatField	`string`	(Optional) Determines which numeric field's values are bumped on each repeat. Default value is a hyphen (-). Note: If repeatCount has a nonzero value, specify the stream column name. If the repeatColumn is a key column in the stream, ensure there are no duplicates when specifying multiple rows in the input file. If the adapter is attached to a window, the repeatField must be a key column.
Directory (run-time)	runtimeDir	`runtimeDirectory`	(Advanced) Location of the data files at run time, if different from discovery time. No default value.
File Pattern	filePattern	`string`	(Advanced) Pattern used to look up files for discovery. Default value is *.xml.
Poll Period (seconds)	pollperiod	`uint`	(Advanced) Period for polling new contents, in seconds. Default value is 0.
Convert to Safe Opcodes	safeOps	`boolean`	(Advanced) Converts the opcodes INSERT and UPDATE to UPSERT. Converts 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 data 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) Determines the number of records to block into one pseudotransaction. Default value is 1.
Field Mapping	permutation	`permutation`	(Advanced) Mapping between the in-platform and external fields. No default value.
PropertySet	propertyset	`string`	(Advanced) Specifies the name of the property set (a group of properties and values) you want to use 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.

Known limitations:

When polling, you can append to a file, but cannot overwrite or replace the file.
The stream name in the file entries is ignored.
Do not mix data files and model XML files in the same directory. This causes Event Stream Processor XML files to be discovered as invalid.