Guides

SQL Server or ClickHouse: Which RBS Report Logger Do You Need?

By Timuçin Çelik, Founder November 19, 2026 3 min reading
RBS Report logo and the question 'Which logger do you need?' above two product boxes: OPC UA Data Logger (SQL Server and Excel reports) and ClickHouse DB Logger (ClickHouse and SQL analysis).

RBS Report has two loggers for industrial data, and they write to different databases. The OPC UA Data Logger writes to SQL Server. ClickHouse DB Logger writes to ClickHouse. This guide helps you pick the one that matches what you want to do with the data. It is a decision guide, not a setup guide, and it only uses what our product pages state.

The short answer

If you want scheduled Excel reports from your logged data, choose the OPC UA Data Logger. If you want to keep long histories in a database built for analysis and query them with SQL, look at ClickHouse DB Logger. They are separate products, and you choose by the database you want your data in.

What the OPC UA Data Logger does

It collects OPC UA data and logs it to SQL Server. It also sends scheduled Excel reports by email, built from your own Excel templates. It runs on Windows or in the cloud. This is the path for operational reporting: a shift report, a daily summary, a weekly file that lands in someone's inbox without anyone opening a program.

Our guides walk through that path in order: logging OPC UA data to SQL Server, creating an Excel report from that data, and sending it by email on a schedule.

What ClickHouse DB Logger does

It writes your logged industrial data into a ClickHouse database. ClickHouse is an open-source, column-oriented database designed for fast analytical queries over large volumes of time-stamped data, and you work with the stored history using standard SQL tools and queries. Logged process data grows into very long histories, and analysing a long history is a different workload from producing a scheduled report. An analysis-oriented store suits that second workload.

How to choose

  • You need scheduled Excel reports by email. Use the OPC UA Data Logger.
  • You already run SQL Server and want your logged data there. Use the OPC UA Data Logger.
  • You want long, time-stamped histories to analyse with SQL. Use ClickHouse DB Logger.
  • You want both. You can run ClickHouse DB Logger next to the OPC UA Data Logger. An analysis store can sit next to SQL Server logging or replace it.

What we do not claim here

Our ClickHouse page does not list which data sources or protocols the logger supports. We will not guess. If your source matters for the decision, contact us or request a demo and we will confirm what fits your setup with your own data.

If you used the InfluxDB Connector

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

Schedule a 30-minute discovery meeting

Talk to our team about the right solution for your business. The demo and consultancy are free.