Xineo XIL Data Source Reference

This document describes built-in data source of the Xineo XIL processor.

JDBC Data Source

Source type : sql.

Available properties
NameDescriptionRequiredDefault
urlJDBC connection URL (see here).Yes
userIdUser ID (may also be specified in the URL).No
passwordUser password (may also be specified in the URL).No
loadDriverA driver class name may be specified here to ask the corresponding driver to be loaded before connecting.No
Query format
The format of the query must be a valid SELECT statement, in the SQL dialect suitable for your RDBMS and JDBC. Variables are created for each returned field, which the name of this field.
Notes
For more information about JDBC, see its official site.

Regular Expressions Data Source

Source type : regex.

Available properties
NameDescriptionRequiredDefault
inputSourceThe name of the file that has to be processed.Yes
inputEncodingThe encoding of the input streamNoUTF-8
skipFirstLinesWhen specified, the given amount of lines are skipped at the begining of the file (must be a positive or null integer).No0
matchFullLineTells if lines of the input stream must be entirely matched by the regular expression (must be true or false).Notrue
Query format
The format of the query must be a valid regular expression. Variables are created for each captured expression, with its index as name.
Notes

See here for details about supported regular expression syntax. See here for more information about capturing groups.

Non-matching lines will be silently ignored.

Local Regular Expressions Data Source

Source type : localRegex.

Available properties
NameDescriptionRequiredDefault
inputStringThe string that has to be processed.Yes
Query format
Same as the regex datasource.
Notes
Instead of matching each line of the input, this datasource tries to match the given regular expression as many times as possible. See he regex datasource documentation for more info.

Note : Optional third-party data sources may be available without being documented here.