Skip to content

Streamsheets

With Streamsheets, technical or business end users can create stream processing applications by using their existing spreadsheet knowledge (e.g. from Microsoft Excel or Google Sheets). As a no-code platform, it gives non-programmers the opportunity to work with event streams and create applications through drag and drop, filling cells with values and formulas, and creating charts and graphs in the way they already know.

Streamsheets can be used in many areas of IoT, stream processing and protocol conversion or gateways to build apps that enable workflow automation, monitoring, and perform control in real-time. Solutions can run either in the cloud or on-prem.

For more information on Streamsheets, refer to the official website and the official documentation.

Requirements for usage with Nerve

To use Streamsheets in combination with Nerve, the following things are required:

  • Nerve Management System with at least one node registered
  • Nerve Connection Manager
  • A trial license and files from Cedalo

Use the Cedalo contact form to request a trial version for the on-premise version of Streamsheets. Once the requirements are met, continue with the instructions below.

Setup and installation

The instructions below are split into multiple parts to make them easier to follow. The first part focuses on gathering all required files, renaming them and creating ZIP files for workloads that will be used in the Nerve Management System. The later parts cover how to create the workloads in the Management System and get Streamsheets ready to be used with Nerve.

Gathering files and creating configuration ZIP files

The delivery from Cedalo includes a license, credentials for their Docker registry and a number of files. The following is a screenshot of all files that are part of the delivery, contained in a folder:

Cedalo files

Follow the instructions below to get the files ready to be used:

  1. Make sure that the files above are located in a folder on the local PC.
  2. Rename the Cedalo license file to license.lic.
  3. Copy the license.lic file into streamsheets/license/

    Copy license file

  4. Create the folder structure streamsheets/packages/gateway/config/

  5. Copy the init.json file from the streamsheets folder into streamsheets/packages/gateway/config/.

    Copy init.json file

The required files and folders are now created and moved into their required places. Now the contents of those folders can be zipped to be used as configuration files for the Streamsheets workload.

  1. Open the streamsheets folder.
  2. Add the contents to a ZIP filed named streamsheets.zip.

    Zip streamsheets folder

  3. Open the /mosquitto/ folder.

  4. Add the contents to a ZIP filed named mosquitto.zip.

    Zip mosquitto folder

This finishes the preparation of the files.

Provisioning Streamsheets as a workload

With the files prepared, Streamsheets can now be provisioned as a Docker Compose workload. Keep the credentials for the Cedalo Docker registry at hand that were part of Cedalo's delivery.

  1. Log in to the Management System.
  2. Select Workloads in the navigation on the left.
  3. Select the Docker Compose symbol (Add new Compose workload) in the upper-right.

    Docker workload

  4. In the new window, enter a name for the workload. This example uses Streamsheets.

  5. Select the plus symbol next to Create version to add a new version of the workload.

    New version

  6. In the next window, enter the following information in the Basic tab:

    Category Settings and descriptions
    VERSION SPECIFIC INFO Version name
    Enter a name for the version of this workload.

    Compose file
    Select the upward arrow symbol to open the file browser and upload the following docker-compose-nerve.yml file.

    Once the compose file is added, its contents are displayed on the right.

    Compose file added

With the compose file uploaded, the Registries and Services tab becomes active and can be used to configure volumes for storage.

  1. Select the Registries and Services tab.
  2. Enter the log in credentials received from Cedalo under registry.cedalo.com/streamsheets.

    Enter cedalo registry credentials

  3. Select the drop-down menu in the Configuration storage column for the mosquitto row.

  4. Select mosquitto:/mosquitto/.

    Select mosquitto volume

  5. Select the drop-down menu in the Configuration storage column for the streamsheets row.

  6. Select streamsheets-config:/streamsheets/.
  7. Tick the checkboxes in the Restart on conf. update for both mosquitto and streamsheets.

    Tick restart checkboxes

Identical to the Registries and Services tab, the Remote Connections tab became active after the upload of the compose file, and it can be used to configure a remote connection to the Streamsheets service.

  1. Select the Remote Connections tab.
  2. Select the plus icon next to Remote tunnel under Remote Connections.

    Add Tunnel to Workload

  3. Enter the following information:

    NERVE PARAMETERS Name
    Enter a name for the remote connection. This example uses streamsheetsui.

    Local acknowledgment
    Select Yes or No from the drop-down menu.

    Selecting Yes will require approval of the remote connection in the Local UI before the connection can be established. If No is selected, the settings in the Local UI do not apply.

    Service
    Select streamsheets from the drop-down menu.
    NETWORK PARAMETERS Port on workload
    Enter 8080.

    Port on PC
    Enter the port that will be used for communication on the local PC. This example uses 8086.
  4. Select Add to save the remote connection configuration.

    Save tunnel configuration

    The connection is saved and now displayed in the Remote Connections tab, showing the Name, Type and Port of the remote connection.

    Added Remote Tunnel

  5. Select Save in the lower-left corner to save the workload version.

The system is now downloading the required Docker images. Once this is done, the workload is ready to be deployed.

Deploying the Streamsheets workload

Select the rocket icon to deploy the workload directly after provisioning and follow the steps in Deploying a workload from the workloads menu.

Added Remote Tunnel

Otherwise the workload can also be deployed from the Deploy menu. Refer to Deploying a workload from the deploy menu for more information.

Applying configuration files to the Streamsheets workload

Once the workload has been deployed, configuration files need to be applied. This is done from the node control screen of the Streamsheets workload.

  1. Select Nodes in the navigation on the left.
  2. Select the node tree symbol.
  3. Select the node running the Streamsheets workload from the node tree.
  4. Select the Streamsheets workload in the node details view on the right.

    Select Docker Compose workload

  5. Follow the instructions on how to apply configuration files to a Docker Compose workload to apply the streamsheets.zip file to the streamsheets service.

    Added Remote Tunnel

  6. Repeat the steps to apply the mosquitto.zip file to the mosquitto service.

    Added Remote Tunnel

Streamsheets is now ready to be used.

Connecting to the Streamsheets UI

Depending on the location of the Nerve device, there are different ways to connect to the Streamsheets UI:

  • Locally, if the local PC is connected to the management port of the Nerve device.
  • Remotely, if the Nerve device is not located in vicinity.

If the local PC is connected to the management port of the Nerve device, accessing the Streamsheets UI can be done simply through a web browser.

  1. Open a web browser.
  2. Enter 172.20.2.1:8080 to access the Streamsheets UI.

With this, it is possible to work with Streamsheets. Refer to the official Streamsheets documentation for more information and help with Streamsheets.

To connect remotely, the Nerve Connection Manager is required, as the connection will be established using a remote tunnel through the Management System. Download the latest version of the Nerve Connection Manager from the Nerve Software Center and install it before continuing. The remote tunnel that will be used has already been configured when the Streamsheets workload was created.

  1. Follow the instructions on how to use a remote tunnel to a workload to establish a remote connection.
  2. Open a web browser.
  3. Enter localhost:<portonpc> to access the Streamsheets UI. This example used port 8086 so the URL is localhost:8086.

With this, it is possible to work with Streamsheets. Refer to the official Streamsheets documentation for more information and help with Streamsheets.