InfluxDB v1

InfluxDB v1 is the initial version of the high-performance time-series database designed for time-stamped data storage and real-time analytics, for more information visit the influxdata website.

Information Model Requirements

Writing

ExampleInsertModel
  • Arrays arrayNode can be used to set use an index

ExampleInsertModelWithComplexVariableAndArrays

Reading

  • Reading from InfluxDB is done using Command commandNode, Complex Variables variableNode and Lists listNode

  • Result variables are optional, so the number of variables can be fewer than those returned by the query

  • For the time the types string, long and OffsetDateTime are supported

  • Variables in the requests can be used as parameters for building the query using the ${MyVariableName} pattern

  • For ungrouped result the following command reply structure needs to be used

ExampleSelectModel
  • For grouped result the following command reply structure needs to be used

ExampleSelectModelGrouped

Configuration

  1. Select the root model node in the tree on the left.

  2. Configure the InfluxDB.

    • Enter the URL to the database

    • Enter the Database name

    • Enter the database Username and Password or select it from the Credentials Manager

    • Enter the Batch size - writes data in batches to minimize network overhead when writing data to InfluxDB

    • Enter the Flush interval and select the Unit (Please note that too short interval might cause data loss!)

InfluxDBConfiguration

Description of configuration properties

Property

Description

Example

URL

Database URL and port

http://127.0.0.1:8086

DB Name

Database name

InfluxDB

Credentials

Database credentials

None

Batch size

Data written in batches

1000

Flush interval

Delay between data flushes in milliseconds, at most batch size records are sent during flush

1000

Measurement

Name of the measurement stored in influxdb

WeatherData

Tag names

Optional tag to be added to the measurement

Type=Station

Writing / Event Configuration

  1. Select the event node

  2. Enable the checkbox to configure the event

    • Enter the Measurement - if it differs from the event name

    • Enter Tags - comma separated

Event Configuration

Tags

Tags are metadata for the data. They're made up of key-value pairs, and they describe attributes of the data that don’t change every time the data point is recorded. To configure a variable as a tag follow the steps below:

  1. Select the variable which should be a Tag

  2. Enable Extended configuration

    • Select Tag from the drop-down menu

    • Enter a Name - if it differs from the variable name

Tag Configuration

Fields

Fields represent the actual data stored and consist of key-value pairs. Unlike tags, fields aren't indexed. Variables not explicitly configured are automatically recognized as fields by the InfluxDB Channel.

If the field name should differ from the variable name in the Information Model, follow the steps below:

  1. Select the variable which should be a field

  2. Enable Extended configuration

    • Select Field from the drop-down menu

    • Enter a Name - if it differs from the variable name

Field Configuration

Time

Timestamps indicates when a data point occurred and, in combination with its tag set, uniquely identifies that data point in a series. The time can be provided as:

  • Long value (unix timestamp)

  • String (format needs to be provided in the configuration)

  • OffsetDateTime

To configure a variable as a time follow the steps below:

  1. Select the variable which should be a time

  2. Enable Extended configuration

    • Select Time from the drop-down menu

    • Select the Precision (Only for variables of type Int or Long)

    • Enter a Formatter (This is required if time is provided as a String)

Time Configuration

Arrays

  1. Select the Array

  2. To configure the Array select Extended Configuration

    • (Optional) Enter an Index name

    • (Optional) Enter a Field name if the event node name differs from the actual name in InfluxDB.

    • (Optional) Enter Tags separated by commas e.g., (location=NewYork, street=xxx)

Array Configuration

Reading / Command Configuration

  1. Select the command node

  2. Enable the checkbox to configure the command

  3. Enter the query.

    For using variables in the query the ${MyVariableName} pattern can be used

Command Configuration