Do more, theorize less.

Real-Time Data Processing and Interoperability Server with No-Code Front-end

Streamsheets logo for cedalo real-time platform

Define data processing, user forms interoperability & visualizations

Build professional applications to automate workflows, continuously monitor operations, and control processes in real-time. Your solutions run 24/7 on servers in the cloud and on the edge.

Streamsheets servers runs on – central on-premise server, local edge servers at assets, (own) cloud server and SaaS in the Cedalo cloud. 

Download: Streamsheets Facts Sheet

  • IoT connectivity

    Find all necessary protocols on board that you need to connect to sensors, and machines like MQTT, REST, and OPC UA.

  • Tap into the stream

    Streamsheets is native to stream data processing like MQTT and kafka. Pick up a topic stream, transform it and blast it back out into the endless streaming world.

  • API connectivity

    REST opens you the world: Streamsheets let you connect to any web service or let them connect to you.

  • Intelligence, edge and cloud. Your choice

    Efficient. Ready for the Edge. Streamsheets run in the cloud, on your servers, but also on edge devices like a Raspberry Pi.

  • Real-time data processing and interoperability

    IoT data processing requires that you can react immediately to data changes. Streamsheets is built for dealing with rapidly arriving data.

Supported protocols

Connect data source

Streamsheets-connect-data-source

Merge & process data

A gif of a data stream on Eclipse Streamsheets

  • No code

    With Streamsheets you don't have to be a programmer or data scientist to work with streaming data. Experts for production and business processes can set up for themselves applications and maintain them.

  • Easy as pie logic

    You know Excel? You do not want to learn a new “language” to tell your app what to do, but you want to process IoT data? Welcome to Streamsheets!

  • Merge data from different sources

    Bind in multiple source and blend their data to create new results.

  • Transform and enrich data by spreadsheet logic

    The data does not arrive in the form you need it. You simply recalculate or aggregate it by streamsheet formulas.

  • Calculate KPIs and produce results live and in no time

    Easy dashboards are set up in some minutes.

Detailed overview

  • Fast dashboarding

    Visualize your data with a few clicks. With multiple dynamic graphs like line charts, pie charts and so many more waiting for you! Unified wizards and diagram setting menus speed up your work.

  • It does not have to look like a spreadsheet…

    You simply separate the spreadsheet-like development view from the presentation view. Convenient working for you as admin and superior visual impression for your audience.

  • Chart types for every use case

    No matter what is your use case we got you covered with heatmaps, speedometers, bar charts, pies, …

Monitor, visualize and create dashboards

Streamsheets-create-dashboards

Publish results

Streamsheets-publish-results

  • Join the endless stream again

    Publish any results as single values or full JSON constructs back to streaming architecture like MQTT, or Kafka.

  • Persistence and database access

    Any value pair or larger data array can be accessed from, or stored in relational databases (like MySQL), timeseries databases (e.g. Timescale), or No-SQL databases like MongoDB.

  • Not only monitoring but also controlling

    With Streamsheets this is not a one-way street: You cannot only read values by REST or OPC-UA, but you can also actively post tags to sensors, actors, and machines. Streamsheets can act as an OPC-UA client or as an OPC-UA server.

  • Runs 24/7 at high frequency

    You do not have to run it on a specific PC. It is central and always available for everybody.

  • Streamsheets server engine

    Powerful engine to process IoT real-time data streams and processes high frequency of messages. It is made for event-based processing.

  • Flexibility

    The world is changing. So are your requirements to your apps. Streamsheet’s inherent approach and logic lets you create and adapt in the blink of an eye.

  • Controlled access

    Manage user access and make sure only the right people can access the data.

Manage your apps

Streamsheets-manage-apps

How we support you

Streamsheets-support

  • Open source

    We believe in accessible technology to bring about innovation. Get started with Streamsheets with our open-source edition!

  • Well documented

    Streamsheets is a professional no-code platform by Cedalo and comes with an extensive and versioned documentation.

  • Product maintenance

    We don't just stop at providing you with Streamsheets. We take it even further by incorporating future changes and updates.

  • Support

    Receive timely feedback and avoid performance pitfalls while using Streamsheets.

  • Professional services

    We provide the expertise necessary to help our customers maximize the value of Streamsheets for business success.

Connections

  • Permanent monitoring of the connection quality
  • Permanent monitoring on new events 
  • Exact provision which topics shall be subscribed
  • Exact provision which topics shall be written to

Various protocols/services as server and client:

  • MQTT
  • OPC-UA
  • REST
  • HTTP/Web Services / web hooks

As client

  • Email
  • SMS
  • Kafka
  • File
  • ...

Streamsheets connectors

Streamsheets-support

What can you realize with a Streamsheet Server?

Monitoring

  • Create and visualize dashboards.
  • Collect and save real-time data.
  • Load historical data and visualize them, e.g. to compare them to real-time data (Timeseries DB integrated!).

Interaction

  • Various external systems can be controlled actively (Provide control messages, trigger web services, …).
  • Add user forms with buttons, entry fields etc. to change parameters or select from lists (e.g. for downtime reasons).

Make interoperability happen

  • Connect heterogenous systems  (e.g. technical systems, business systems, web based services,  …).
  • Act as server for clients, other systems, or users: web server, REST server, OPC-UA Server, MQTT Broker, …
  • Data transformation, filtering, and or aggregation.
  • Embed Streamsheets in web portals.

Open source or Premium?

Take a look at the features and capabilities the different versions of Streamsheets have to offer and choose your version.

View Pricing

Resources

Facts sheet

Download the Streamsheets 2-page facts sheet for a quick overview of Streamsheets.
Download

Blog post

Introducing Streamsheets 2.2: features, updates, and improvements.
Read More

Community

Join our community and get support, access to best practices and tutorials.
Join