ClickHouse DB Logger

Log industrial data to ClickHouse

ClickHouse is an open-source, column-oriented database designed for fast analytical queries over large volumes of time-stamped data. ClickHouse DB Logger stores your logged industrial data in ClickHouse, so long histories can be queried and analysed with SQL.

It is a separate product from the OPC UA Data Logger, which logs OPC UA data to SQL Server and sends scheduled Excel reports. Choose by the database you want your data in.

Get Demo
Illustration of industrial data passing through a logger into a column-oriented database

The problem

Logged process data grows into very long, time-stamped histories

Analysing that history is a different workload from producing scheduled operational reports

An analysis-oriented store can sit next to, or instead of, SQL Server logging

Solution

A logger that stores industrial data in a ClickHouse database

ClickHouse is queried with SQL and is built for analytical workloads

Request a demo to see it with your own data and setup

What it does

Logs to ClickHouse

Writes your logged industrial data into a ClickHouse database.

Built for analytical queries

ClickHouse is a column-oriented database designed for analytical queries over large tables.

Queried with SQL

Work with the stored history using standard SQL tools and queries.

Alongside SQL Server logging

Use it next to the OPC UA Data Logger, which logs to SQL Server. They are separate products.

Long histories

Keep long, time-stamped histories in a database made for analysis.

Request a demo

See it with your own data and setup. Contact us to discuss your requirements.

Data flow

Illustration of data flow from industrial data sources through a logger into a column-oriented database and on to analytics
Data sources

Industrial data produced by your systems. Ask us which sources fit your setup.

ClickHouse DB Logger

The logger that writes the data to ClickHouse.

ClickHouse database

Column-oriented storage for analytical queries and downstream analysis.

How it differs from the OPC UA Data Logger

OPC UA Data Logger

Collects OPC UA data, logs it to SQL Server and sends scheduled Excel reports by email, on Windows or in the cloud.

ClickHouse DB Logger

Stores logged industrial data in ClickHouse for analysis of long histories.

Which one do I need?

For SQL Server logging and Excel reports, see the OPC UA Data Logger. For ClickHouse, choose ClickHouse DB Logger. Contact us if you are unsure.

Frequently Asked Questions

What is ClickHouse DB Logger?

An RBS Report product that logs industrial data into a ClickHouse database.

How is it different from the OPC UA Data Logger?

The OPC UA Data Logger logs OPC UA data to SQL Server and sends scheduled Excel reports by email. ClickHouse DB Logger logs to a ClickHouse database instead.

Which data sources and protocols does it support?

This page does not list specific protocols. Request a demo and we will confirm what fits your setup.

Can I try it with my own data?

Yes, request a demo and tell us about your requirements.

What happened to the InfluxDB Connector?

It has been replaced on this site by ClickHouse DB Logger. If you use InfluxDB today, contact us to discuss your setup.