StableNet® Integration

StableNet® integration is used to display and evaluate data from StableNet®.

The following diagram illustrates the components involved:

stablenet-fdw-components.drawio.png

SKOOR Dashboard

The dashboard application runs in the browser. It allows to view and edit dashboards. The dashboard application receives its data from the SKOOR web service.

SKOOR Server

SKOOR Webservice

The SKOOR web service provides the data for the dashboards. Data can be prepared for display using a fully integrated query engine (data queries).

SKOOR Auth

Uses the StableNet Middleware API to authenticate users to StableNet.

PostgreSQL DB

The SKOOR PostgreSQL Database usually runs on the same System as SKOOR itself is running.

StableNet Foreign Data Wrapper (FDW)

This is a PostgreSQL extension that communicates with the StableNet Middleware API using HTTPS requests and makes the data available to clients as normal database tables. If a call is made to a table, a corresponding HTTPS request is automatically sent in the background. The FDW is primarily used for static data such as devices, interfaces, measurements, etc.

Pre Aggregated Measurement Data (AGG)

Data is pre-aggregated into specific bucket sizes in order to be able to carry out evaluations on measurement data quickly. The following resolutions are currently available:

  • minutely

  • 5 minutely

  • 15 minutely

  • hourly

  • daily

  • weekly

  • monthly

  • quarterly

  • yearly

The data is synchronized and aggregated by a data sync job. The tables are named according to the bucket size. E.g. stablenet_meaurement_data_minutely, stablenet_measurement_data_15_minutely, …

Aggregated data is being automatically cleaned up based on a configurable retention policy. By default, the retention policy is defined as follows:

[retention_days]
#raw = 1
#minutely = 1
#five_minutely = 14
#fifteen_minutely = 31 # ~1 month
#hourly = 93 # ~3 months
#daily = 365 # ~1 years
#weekly = 365 # ~1 years
#monthly = 1825 # ~5 years
#quarterly = 1825 # ~5 years
#yearly = 3650 # ~10 years

Data Sync

The data sync job is configured in the SKOOR Engine and is also executed there. It basically consists of two parts.

Raw Data Sync

The sn_ping_data and sn_snmp_data tables are currently being synchronized. A one-to-one copy of the data from the StableNet DB is created within the SKOOR DB. With sn_snmp_data, the synchronized metrics and measurements can be restricted by configuration. There are plans for the future to push this measurement data directly from StableNet ind to the PostgreSQL Database instead of polling it from the StableNet Database.

Aggregate Data Sync

Here, the data from the raw tables is aggregated into the defined bucket sizes.

StableNet Server

StableNet Middleware

Provides an HTTP API with which third-party providers can query data from StableNet. This API is used by the FDW.

StableNet Database

This is normally an Oracle or MySQL database used by StableNet. SKOOR uses this database to efficiently retrieve measurement data.