StableNet® Integration
StableNet® integration is used to display and evaluate data from StableNet®.
The following diagram illustrates the components involved:
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.