Adapter type: toolkit_file_xmldoc_input. The File/Hadoop XML Input adapter reads XML-formatted data from a file or a Hadoop Distributed File System (HDFS). Set these properties for the adapter in the ESP Studio adapter properties dialog.
If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.
Property Label | Description |
---|---|
Directory |
Property ID: dir Type: directory (Required) Specify the location of the data files. |
File (in Directory) |
Property ID: file Type: string (Required) Specify the file to read. Wildcards are allowed. |
Row Expression |
Property ID: xmlElemMappingRowPattern Type: string (Required) The XPath expression for mapping XML elements to ESP rows. |
Namespace URI |
Property ID: xmlElemNamespaceURI Type: string (Optional) The namespace URI for XML elements included in the pattern expression. |
Column Expression List |
Property ID: espColumnPattern Type: string (Required) Comma-separated list of XPath expressions for mapping XML elements to ESP columns. If the XML element used in an expression belongs to a namespace, specify the namespace in the expression. |
Dynamic Loading Mode |
Property ID: dynamicMode Type: string (Optional) Set dynamic mode for reading files. Valid values: static, dynamicFile, dynamicPath. |
Poll Period (seconds) |
Property ID: pollingPeriod Type: int (Advanced) Specify the poll period when dynamicMode is dynamicFile or dynamicPath. |
Dynamic Loading Mode |
Property ID: dynamicMode Type: string (Optional) Set dynamic mode for reading files. Valid values: static, dynamicFile, dynamicPath. |
Poll Period (seconds) |
Property ID: pollingPeriod Type: int (Advanced) Specify the poll period when dynamicMode is dynamicFile or dynamicPath. |
Remove Files After Processing |
Property ID: removeAfterProcess Type: boolean (Optional) Removes files after they have been processed. |
Date Format |
Property ID: xmldocDateFormat Type: string (Advanced) Specify the format for parsing date values. |
Timestamp Format |
Property ID: xmldocTimestampFormat Type: string (Advanced) Specify the format for parsing timestamp values. |
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. |