ogamma Visual Logger for OPC
4.0.6
Contents:
Introduction
Licensing
Licence for
ogamma
Visual Logger for OPC.
Annual Maintenance and Upgrades License.
Licenses of open source dependencies.
Features
Deploy
Docker.
Distribution packages for various target platforms.
Activate
Configure
Collect
Store and Forward
Visualize
Analyze
Troubleshoot
Target Platforms
More features are coming
Deploy
Setup using Docker
Pulling docker image of
ogamma
Visual Logger for OPC and running it.
Using docker-compose.
Running all supported databases and demo OPC UA Server in Docker
Setup in Windows
1. Install required prerequisites
a). Install Visual C++ 2019 redistributables (64 bit version)
b). Install / Configure database to store time-series data.
c). Install Microsoft ODBC Driver 17 for SQL Server.
2. Install
ogamma
Visual Logger for OPC
3. Start
ogamma
Visual Logger for OPC.
4. Running
ogamma
Visual Logger for OPC as a Windows service.
5. Install Grafana
Setup in Ubuntu 18.04 and Ubuntu 20.04
Setup in RedHat Enterprise Linux
Setup in Raspberry Pi.
Prepare Micro SD card with 32 bit debian-bullseye OS.
Install Docker and Docker Compose
Get docker compose files for
ogamma
Visual Logger for OPC and start it:
Install as Azure IoT Edge module.
Installing older versions.
Upgrading from older versions.
Steps before upgrade.
Upgrading Docker container.
Upgrading Windows and Ubuntu installations.
Steps after upgrade.
Versions the upgrade is supported from.
How to deploy
ogamma
Visual Logger for OPC as Azure IoT Edge Module
Install Azure IoT Edge runtime in the device.
Install prerequisites.
Install Azure IoT Edge runtime
Provision IoT Edge device with its cloud identity (using symmetric key).
Restart IoT Edge runtime.
Deploy
ogamma
Visual Logger for OPC
Activate
Upload Annual Maintenance and Upgrades License.
Reactivate.
Upgrade product edition with a new key.
How to setup configuration GUI endpoint to use https.
How to generate and install SSL certificate issued by Let’s Encrypt.
Requirements for SSL certificate files generated by third-party tools.
Configuring of the instance to use https.
Configure
Application Instances.
Configuration files.
Configuration steps.
1. Connecting to the Configuration database.
1.1 Connecting to PostgreSQL database in secured mode
2. User authentication and authorization.
2.1. Versions before 4.0.0
2.2. Versions 4.0.0 or newer.
2. Collector Configurations.
3. Time-Series database connection settings.
4. Configuration of application instance.
Collect
Connections to OPC UA Servers.
Advanced connection settings.
Periodical reading and logging of variable values.
Enabling support for complex type values.
Browsing OPC UA Server nodes with large number of child nodes.
Connecting in secured mode and certificates.
Configure OPC UA servers to trust
ogamma
Visual Logger for OPC instance certificate.
Configuring ogamma Visual Logger for OPC to trust to server instance certificates.
Connections from Docker container.
Connecting to OPC UA Servers running in Docker container, accessed over VPN or NAT or using port forwarding.
Connecting to classic OPC DA Servers.
Browsing OPC UA Server address space and selecting variables to log.
Browsing and selecting of variables manually using web GUI.
Auto-discovery and selection of variables
Logged Variables table.
Columns.
Grouping of logged variables
Filtering by OPC UA Server.
How to set default values for logging options.
Display real time data.
Other options.
Client-side deadbands.
Logging values of complex data type.
Write values to OPC UA Variables
Time-Series Databases
Common settings
Store and Forward Settings and statistics.
Settings for OPC UA to TSDB mapping.
Handling of invalid UTF-8 strings.
SQLite
TimescaleDB/PostgreSQL.
Installation.
Configuration.
Mapping from OPC UA to SQL database, table and columns.
Schema of the
values
table.
Accessing
Display
Name
or
OPC
UA
Node
Id
of variables from time-series database of SQL type.
Writing time-series data to the table with name different than default name
values
.
Connection in secured mode
Using PostgreSQL instance hosted at Microsoft Azure
Using instance of TimescaleDB hosted by Timescale
Configuring retention policy in TimescaleDB.
InfluxDB version 1.7.
Installation.
Configuration.
Example file for automatic deployments.
Configuration using web GUI.
Mapping OPC UA to InfluxDb.
The
measurement
part.
The
tags
part
Placeholders
Spaces in measurement and tag keys.
The InfluxDB
fields
part.
Timestamp precision.
Logging application status
InfluxDB version 2.0.
Installation.
Configuration.
Example configuration file used in case of automatic deployment.
Steps to configure InfluxDb2 running in Docker container.
Grafana data source plugin for InfluxDB 2.0
Mapping OPC UA to InfluxDb.
Confluent Platform: Cloud and Enterprise
Configuration.
Configuration using web GUI.
Example file for automatic deployments.
Mapping from OPC UA to Confluent Topic, Key names and Partitions. Payload format.
Payload
Apache Kafka
Configuration.
Configuration using web GUI.
Example file for automatic deployments.
Mapping from OPC UA to Kafka Topic, Key names and Partitions. Payload format.
Microsoft SQL
MySQL
MemSQL
MQTT
Publish Topic Name composing
MQTT payload
Eclipse Mosquitto
Microsoft Azure IoT Hub
AWS IoT Broker
Google Cloud IoT Core MQTT Bridge.
IBM Watson IoT Platform
TSDB database access optimization.
Store
Visualize
InfluxDB 2.0 built-in visualization tools.
Visualization with Grafana.
Install Grafana
Setup Grafana data source plugins to get data via
ogamma
Visual Logger for OPC REST API endpoint
Installing of the
Infinity
plugin.
Installing of the
SimpleJson
data source plugin.
Using Grafana data sources to read data from databases directly.
Setup Grafana dashboards.
Create new dashboard.
Reading values from
Infinity
data source plugin.
Reading values from
SimpleJson
data source plugin.
Reading values stored in PostgreSQL database.
Analyze
Test use case
Step 1: Add server node into Address Space.
Step 2. Start logging of values for OPC UA variable node.
Step 3. Configure Grafana panel to view data values
Step 4. Analyze data visually.
Step 5. Open PgAdmin page and connect to the TSDB database.
Step 6. Run SQL queries.
Step 7. Look at log files for additional information.
Step 8. Conclusion.
Roadmap
Support
How to:
Modify minimal refresh rate for Grafana
How to enable SQL Server Authentication and TCP in Microsoft SQL Server Express
Enabling SQL authentication Mode.
Enabling TCP connections.
Enable horizontal scrolling in the Logged Variables table.
Upgrade time-series database from InfluxDB 2.0 Beta version to InfluxDB 2.0.3 released version.
How to solve issue with duplicate records in SQLite or PostgreSQL/TimescaleDB.
How to install and run InfluxDB.
Windows 10
Linux (Ubuntu 18.04)
Installing SSL certificates from letsencrypt for InfluxDB (Ubuntu)
Running InfluxDB as Azure IoT Edge Module
How to quickly setup test configuration with 100K variables.
How to modify configuration options for large number of variables.
Import variables from CSV file
Import into SQLite configuration database.
Import into PostgreSQL configuration database.
How to create and use self-signed OPC UA application instance certificate.
How to monitor state of connection with OPC UA Servers
How to configure
ogamma
Visual Logger for OPC and monitor its state using REST API.
How to add OPC UA Server connection settings and logged variables using Python scripts
How to connect to Ignition OPC UA Server in secured mode.
Connecting when
ogamma
Visual Logger for OPC and OPC UA Server run in different network environments.
ogamma Visual Logger for OPC
»
Index
Index