Cedalo, the company behind the two Eclipse – Open Source – projects Mosquitto and Streamsheets has recently released Streamsheets in the new version 2.3. It focuses on interoperability and integrations.
New crypto features enable the secure transfer of sensitive data between applications. Additional cell functions facilitate the work of streamsheet creators, e.g. to convert data from JSON to XML. The release is rounded off with additional wizards to better set up graphs. The new chart type “Map” allows the display of any data on country and regional maps.
In Streamsheets, external services can already be controlled via HTTP – request functions. “For many of our users, we want to make this even easier. With our no-code platform Streamsheets, we want to address users who do not have in-depth IT know-how,” explains Philipp Struss, CEO of Cedalo AG.
Read an Exclusive Interview: How can Enterprises Enhance their Employee’s Self-Service Experience with Pat Calhoun, CEO, Espressive
“Consequently, we will now step by step offer cell functions that directly exchange information with third party systems using no more than simple spreadsheet formulas.” In a first step, it is now possible to send text messages directly from a Streamsheets cell. Likewise, geodata can be determined for locations or weather data and forecasts can be obtained for a location by means of further integration functions.
Streamsheets is aimed at professional users who need to monitor, transform, and display continuously incoming data (“streaming data”) in real time in their business and production processes.
In this no-code environment, business users can map their processes using spreadsheet logic without having to know how to program. Each user can drag and drop these directly onto their Streamsheets server. There, users can adapt the examples to their own needs.
Interoperability often requires that data sets are transformed. Streamsheets is here a mediator between the (application) worlds and allows numerous data transformations. New in version 2.3 is the JSON.to.XML – function.
Both JSON and XML are very common formats when structured data needs to be passed between applications. The new function allows a quick and easy transformation between these two important formats.
Streamsheets 2.3. now includes a map-based chart. Analyses are very often done by regional categories, be it continents, countries or in some cases by individual streets.
In the “Maps” – diagram quantitative data can be assigned to places plastically using different map types. In addition, Streamsheets has already been supporting a variety of different X-Y diagrams and heatmaps, e.g. to display data on a grid map.