Released version 2.0.0-Fireball of the Onesait Platform

On april 6, 2020, release 2.0.0 of Onesait Cloud Platform was published (aka fireball version, following our version policy: Version Policy onesait Cloud Platform).

Below, you can see this release’s main features:


This version includes support for aplication and microservices development, for which the Platform offers a centralized web console that supports the administration, configuration and development of all types of applications, integrating the creation of applications, its deployment on the CaaS infrastructure, application, visualization, etc.

The following features have been incorporated in this release:

  • Ontologies full integration with relational databasesfrom this release on, in addition to being able to connect to a relational database and create the ontology that represents a table (more info) you can create an Ontology using the UI wizard or by providing a JSON-schema and then the platform creates the tables and FKs on the configured database on a JDBC connection.
  • GeoJson support in Ontologies on PostGIScomplementing the previous functionality, this new version allows to establish a conection with a PostGIS database and create an ontology from an existing table with GEOMETRY type columns or to create the table from the selected ontology.
  • Mongo 4.X SQL support in Semantic DataHubup to this version support for executing SQL queries over MongoDB was limited to Mongo versions 3.X. A new SQL Engine that works with Mongo versions 4.X has been included in this version. This engine is based on the library: open-source sql-to-mongo-db-query-converter with which we have collaborated to expand and improve its functionality and in turn contribute these improvements to the community.
  • Identity Manager Plugin Architecturestarting in this version, systems built on Platform can take advantage of its plugin architecture that allows adding functionalities and extensions to different platform modules simply by adding a Java library (JAR) following some rules. This functionality is part of the Platform’s Enterprise version, and will be published in the next version (Q2 of 2020) although it can already be tested in PREVIEW MODE in the Identity Manager module.
  • SQL/JsonPath subscriptions via Digital Brokerthis functionality allows a platform client to subscribe to “changes” on ontologies, so that when a condition is passed, the Platform will notify the subscribed client.
  • Microservices generation from ZIP file o Git Repositoryfrom this version on you can select to create a microservice from a ZIP file or a Git repository. This allows to have a catalog of Git repositories that can be used as templates.
  • Advanced management of platform user credentialsin this version, numerous improvements have been included in the management of the credentials of a platform user, among which we can highlight:
    • Setting the minimum password required length and complexity.
    • Password block after multiple failed attempts.
    • Checking of previously used passwords.
    • Force password change every X days.
  • Complete Kafka integration with platform securitythe Platform supports Kafka as one of the protocols for ingest, until now security has focused on the authentication of the connected client. In this version, security control has been added to the use of ACL to manage the data authorization when we use Kafka intake topics. In this way, when creating a client and indicating permissions to the ontologies, the same authorizations (read / write / both) are required for Kafka topics. All this is managed by the platform on the integrated Kafka Bus.
  • Flow Engine migration to NodeRED 1.0.3FlowEngine execution engine has been updated to the latest version of Node-RED (1.0.3), this adds numerous updates to the component, both at flow editor level, asynchronous message passing, etc. You can check the new features of this version at the following link:
  • ConfigDB management via Query Toola deployment level option has been enabled (by default only enabled in Development Environments) that allows a user with an Administrator role in the Control Panel to do a complete management of the ConfigDB from the QueryTool itself.


This Platform’s version focuses on supporting the development of systems and applications that need to use analytical, AI or distributed intake capabilities of the platform. In this quarter we have focused on:

  • BigQuery integration with Platform’s OntologiesBigQuery support has been incorporated into the Semantic DataHub in this version, which allows to manage persistent ontologies on this Google database.
  • Agents architecture for JDBC connectionsthe Platform has incorporated a new JDBC Agent Architecture that allows connecting with various persistence technologies with JDBC interface. The Platform allows through this JDBC connection offered by the agent the creation of ontologies, which enables the possibility of using many databases with different types, drivers or even incompatible versions of the same database.
  • Cluster deployment Dashboard Engine supportthe Javascript library that manages the connection to the Dashboard Engine has been updated. Now in cluster operations of the Dashboard if any of the nodes becomes inoperative it reestablish the connection transparently against other available node.
  • Additional resources in Reports supportfrom this version on associated with a Report, additional resources can be added, which can be subreports, datasources, other sources, etc.
  • Ontology creation from Tables with same name supportfrom now on when you create an ontology from a JDBC connection.


This version of the Platform is focused on the creation of IoT systems in which Edge and Cloud capabilities of the platform can collaborate, allowing bi-directional communication with devices, modeling and deployment of Digital Twins, etc. We have focused the work in these lines:

  • Full Synoptics reviewwithin this task we have resolved various errors and incorporated improvements identified by our colleagues (thanks Sergio). This motor is already being used in several of our products.
  • Device Security Kafka IntegrationKafka’s integration with the platform has been improved, so that Devices on Platform that handle ontologies transfer their permissions to Kafka ACLs.


This category includes all the tools that help Platform’s Development and Operation of the Platform. In this quarter we have incorporated these new tools:

  • K8s Deployment with Helm ChartsHelm charts have been created that allows to automate the deployment of the Platform on OpenShift.
  • Kafka deployment over Kubernetes network (instead host net)in this version, the images referring to Kafka Platform services (Zookeeper, Kafka, KSQL, monitoring) have been modified to make use of the Docker / Kubernetes network. We have also simplified the configuration of all of them, allowing you to configure the services with the same environment variables that Kafka indicates in its base images.
  • Review and improvements in Export / Import Tool: a review of the Export / Import tool has been completed, also adding the ability to export and import Notebooks.
  • MariaDB as ConfigDB default databasefrom Platform version 2.0 onwards MariaDB is used as ConfigDB reference technology. This does not prevent the use of other databases, including MySQL, since the platform can support other databases to store configuration data.
  • Web Projects and Datasources management APISseveral new REST APIS have been created for the management of elements such as Web Projects and DataSources. This allows, for example, uploading a ZIP file of a web project from a continuous integration environment invoking this API.

As you can see, the new features are many and varied. As usual, you can access all the news from our Confluence.

✍🏻 Author(s)

2 thoughts on “Released version 2.0.0-Fireball of the Onesait Platform

Leave a Reply

Your email address will not be published. Required fields are marked *