Introduction

My name is Kristian Raue and I work at https://www.cedalo.com. In this blog I will explain the technology and use cases of Streamsheets. A very brief introduction to event streaming can be found in this blog post. You can get a commercial and a free version of Streamsheets at www.cedalo.com.

A Streamsheet is a server-based spreadsheet that continuously processes payload data from event streams. Therefore Streamsheets are able to publish and subscribe to broker based event streams like MQTT or Apache Kafka. (I will give a very short introduction to pub/sub based event streams in the this post).

A Streamsheet looks like a spreadsheet to the end user. In the background it runs continuously as a microservice on a local or cloud based server (or even on a Raspberry Pi) without exposing much complexity to the end user.

With Streamsheets the everyday technical or business end user can create stream processing applications just by using their existing spreadsheet knowledge (e.g. from Microsoft Excel or Google Spreadsheets). In other words: A Streamsheet lets a non-programmer do with event streams what otherwise only a experienced software programmer can do.

Applications for stream processing are widespread and are as generic as spreadsheets in general are. Streamsheets are used in the following areas:

  • IoT: Control, analysis, monitoring, visualization and simulation of industrial and other IoT processes (Smart Factory, Smart Building, Smart City, Smart Energy, Precision Farming, …) using MQTT or AMQP.
  • Stream Processing: Any kind of business or technical processes that publish and subscribe to a streaming platform (e.g. Kafka) and does analysis, transactions, monitoring, statistics, automated alerts, conversions, semantic mappings, enriching of data sets, etc.
  • Protocol conversion or gateways: Edge to Cloud, IT to OT, Protocol to Protocol, Request/Response to Publish/Subscribe, Logfile to Stream, etc. using MQTT, AMQP, UDP, REST, POP, SMTP protocols or simple input from text files.

In the following posts I will explain the technological foundations of a pub/sub event stream and will then continue with the functional basics of a Streamsheet. In ongoing posts I will then further show demos, use cases and tips & tricks with regard to Streamsheets.