SV Adaptor

The SV Adaptor takes multiple messages structured as a records with delimited fields and converts each record to a relational row.

The adaptor configuration must specify the following arguments:

No. Argument Description
1 Table columns Comma separated list of column names in the target table. Each name must correspond to a known column in the target table
2 Field positions Comma separated list of field positions. Each position identifies a field that maps to the corresponding column above. Each position must in the range 1-1024.
3 Field delimiter The character used to delimit fields.
4 Record delimiter The character used to delimit records.
5 Message state position Field position of the message state field. The position must be in the range 1-1024.
6 Message state type Data type of the message state. Use N or T to indicate number or timestamp data type.
7 Message state mask Format mask that the message state appears in

Note that each argument must be enclosed in single quotes.

The number of field positions (argument no. 2) must match the number of table columns (argument no. 1).

An example of an SV adaptor configuration is:

'device_id,datetime,temperature','1,2,3',',','\n','2','T','YYYYMMDDHH24MISS.MS'


For non-printable delimiter characters, use E'\xNN' notation to specify a hexadecimal ASCII code for the character, eg. use E'\x0D' to specify ASCII code 13 (decimal). The following escape sequences can also be used to indicate special characters:

  • \b - backspace
  • \f - form feed
  • \n - new line
  • \r - carriage return
  • \t - tab

See format masks for message state format mask notation.

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk