MS SQL Server InfluxDB

Easy data transfer to InfluxDB

The Influx database is a powerful BigData / NoSQL database for time series data from InfluxData. Due to new non-relational database concepts, InfluxDB is able to store large amounts of time related data very quickly and efficiently and to load and make them available again.
With its plug-ins, the OPC Router has connections to various industrial infrastructure systems and thus has access to their data. With the InfluxDB plug-in it is possible now to transfer this data directly to the Influx database and make it available to BigData and analysis applications. Data sources are connected to InfluxDB as usual in a graphical configuration of Drag&Drop.

Run a free test now

Example for the transfer of process values to the InfluxDB:

Example for data recording in the InfluxDB from a PLC via OPC UA

That’s how easy it is.

Connecting Systems

What’s Transfer, Trigger and Browsing?

Transfer Objects

The transfer object of the Influx plug-in enables transfer of data to an Influx database.
Each transfer object is assigned to an InfluxDB connection, depending on the database to be written to.

InfluxDB Measurement, Tag and Fields

During data transfer, the measurement can be transferred from the data source or set statically. The measurements build the data pool in InfluxDB, comparable to a table in classic SQL.
The tag can also be determined statically or dynamically. Tags are used to group data in the InfluxDB to create a context for later queries.
The fields to be transferred are configured in the transfer object. In the connection, these are graphically connected with data points from the source. Fields are the individual fields of a data record. Compared to the classic SQL, the fields can be seen as columns of the tables.

Trigger

The Influx Plug-in does not have its own trigger. The data transfer into the database can be triggered by different basic triggers or triggers from other plug-ins.

Browsing

Browsing is supported by the InfluxDB Plug-in in several places.

When configuring the database connection, the databases of an InfluxDB server can be browsed.
To set up the connection configuration, the available measurements, tags and fields can be loaded from the database in the transfer objects.

InfluxDB Plug-in Application Examples

Process value data acquisition

Due to its networking in production environment, OPC Router has access to valuable production data. This data is very well suited to be transferred as time series data to Influx BigData database system. This opens up new analysis possibilities for the production data, but data already in the database can also be viewed in new contexts. The various plug-ins allow you loading data from various systems and transfering to InfluxDB. A typical example of data collection for process data acquisition is control and sensor data from PLC systems. Controllers are connected via standardized OPC UA protocols (with the OPC UA Client Plug-in).

InfluxDb
OPC UA Client / OPC DA Client
MQTT Client
InfluxDb

MQTT to InfluxDB transfer

More and more systems in industry are able to send their data via MQTT. Especially the constantly growing IoT (Internet of Things) is strongly based on this simple and light protocol. With its MQTT Client Plug-in, OPC Router can receive messages from an MQTT Broker and thus obtain data from any source as MQTT Subscriber. In combination with InfluxDB plug-in, data can then be transferred to InfluxDB directly or after a previous transformation. It is possible to use the OPC Router as an MQTT to InfluxDB Gateway with graphical configuration.

Here you will find further information
about OPC Router and Plug-ins.

Plug-ins
Run a free test now