Sofia2 participates in the SESIAD Virtual Laboratory



The Virtual Laboratory of the Secretary of State for the Information Society and Digital Agenda (SESIAD) was born under the standard UNE 178104 “Integrated management systems of the smart city” with the aim of becoming a benchmark for national and international platforms, being a place of experimentation in which companies and developers can evaluate the compatibility of their products with different Smart Cities platforms.




Currently, platforms that participate in the Virtual Laboratory are Sofia2, from Minsait by Indra, SmartBrain from Cellnex and Thinking City from Telefónica. They collaborate with SESIAD contributing their expertise and participating in the improvement of interoperability between platforms.




As we saw in IoT Data Models: Initiatives and Sofia2 Data Model, there are different Initiatives of standardization of a Data Model in IoT. A Data Model represents the structure of your data and relationships, and therefore, organizes the elements and standardizes how they relate to each other.




GSMA and FIWARE Data Models are defined in JSON, so their representation as Sofia2’s Ontology is immediate. We saw how they are supported and how easy it is to work with these entities in Sofia2


To achieve better interoperability between platforms, NGSI 9/10 v2 was selected as a common protocol for the Interoperability Layer. We saw in this document how they are supported and how to consume APIS modeled according to the semantic FIWARE Data Model and published in Sofia2 following the NGSI 9/10 v2 protocol.


In our experience with the Virtual Laboratory, in addition to making recommendations for new attributes and modifications in the Data Model, we had the opportunity to perform a Proof of Concept (PoC) by creating a connection  and transformation flow of real data from Smart City A Coruña to GSMA/FIWARE Data Model on Sofia2’s Platform.


In this example, Smart Coruña parking data is collected and is ingested in an Ontology on the Sofia2’s platform. Each time an instance of this ontology is received, a Script is launched and transforms this data adapting them to the Data Model and, consulting them, we see how, effectively, the Data Models are fulfilled.




Also in this Proof of Concept we could publish this data through the API MANAGER of Sofia2 to later see that anyone with the proper permits can access this data via API, Curl or through the Virtual Laboratory portal.





All this process is explained in the post Acquisition, transformation and consumption of data with GSMA/FIWARE Data Model, and has been captured in the demonstrator, which, in addition to parking data, collects data from beaches and museums.




You can find all the information related to the SESIAD Virtual Laboratory here, as well as all the necessary tools (Data Model, APIs, Security tokens, examples …) to develop on the platforms complying with this interoperability model here





Sofia2 participates in the SESIAD Virtual Laboratory

Integration of Lora and Sofia2

The communication between Lora and Sofia2 is done through the Multitech kit, formed by a test node that simulates the transmissions between a Lora device and a Gateway. This Gateway is needed to communicate this type of devices within the network and to send the captured data.

Used Multiconnect Conduit Kit.

Before the integration in Sofia2, the configuration between the Gateway and the test node is needed. In this brief tutorial, the steps to develop both configurations are collected, as well as all the information needed in Sofia2 to receive and store the data sent by Lora.

Configuration of Lora technology

  • Gateway configuration

    In order to use the gateway without any connection problem, an initial configuration is needed. First access to the Gateway must be done by means of serial communication, though Putty or another similar tool. Credentials needed to access by console are admin/admin. We can get its IP address with the command ifconfig. Once the IP address is known, we use the explorer to access to the Multitech webpage, where we introduce the same credentials again.

    Acceso web al gateway
    Access to the gateway webpage

    Once we start the session, and only by the first time that we do it, we will find an assistant that requires us to change the password, to select the timezone and to configure the IP address. When the last window appears, we must to configure the static IP, to select the corresponding Gateway, and to add the DNS servers.

    Once we finish the IP configuration, we will configurate Lora. To do that, we have to access to Setup -> Lora. Then, we will see a screen where we will see some configurable fields. Anyway, we only need to modify Name and Passphrases.

    Lora configuration
  • Node-Red configuration

    Once we activate the Node-Red application, we can access though the “App” menu of the webpage. By default, a program that receives Lora test data and shows them is designed, but we have to modify it in order to send the information to Sofia2. Image shows the final flow diagram, with the option “Sofia2 API WEB encoder” added. This option is uncharged of giving the desired format, adding a header to the send message and an output HTTP.

    Node-Red diagram
  •  Configuration of test node

    To configurate the parameters of the test node is really simple. We only have to connect the mDot to the PC, by means of a USB, and to connect it to the test node with the kit programming cable. Then, we select the “Configuration” option in the mDot Box and we access to the device by using the Putty serial communication at 115200 baud.

    Lora tester

    We only need to configure two parameters, using the following AT commands:



    AT&W is used to save changes and  AT+Exit to exit the configuration mode.

    <Name> y <Passphrase> fields have to be the same values as used previously in the gateway.

    Configuración del tester
    Test node configuration

    In order to check if the configuration of both devices has been correct, we can do a test with the Node-Red.


Once that the devices have been configured, we have to develop the next steps in Sofia2. We need two new ontologies, an API rest and a rule script to deal with data. This section briefly explains with each of them.

  • Defining new ontologies

    First of all, we have to create an ontology that will receive the data sent by the test node. In this ontology we will insert raw data, without any previously filtering.

    Ontology example with raw data

    As we can see in the previous image, data usually have hexadecimal codifications, undesirable formats or information that needs to be treated before work with it. To do that, we have to create a rule script and a new ontology, where we will insert filtered data with the format required by the data base to correctly store it.


    Once the ontologies are defined, we will create an API REST of type POST, to insert data in the ontology of raw data. To do that, we have to go to the API MANAGER -> APIs, where we will find the option “New API”. There, we write the name of our API, and select the option “Publish Ontology as REST API” and the ontology desired. It is convenient to disable the maximum number of calls per minute, in order to assure that we do not lose information. At the end, we select the “POST” operation and create the API.


    The URL of the “Base Endpoint” field is the one that we have to insert in the Node-Red.

  • Rule script

    Once verified that the data sent directly from the device is correctly inserted in the desired ontology, we must create a script to filter them, extract all possible information and provide them with the corresponding format. To do this, we simply enter Rules-> Wizard New Rules and select the option “Generate rule using a template “. With this type of rules, each time the device sends new data to the ontology, the script will be executed and data will be processed and inserted into the final ontology.

  • Presentation on results

    We can use Sofia2’s visualization tools to show the data we’re storing quickly and easily. To do that, we have to go to the Visualization ->My Gadgets -> New Gadget, where we can select the optimal tool depending on our data. On the basic of measured data from Lora tester, the following representation could be interesting: to drawn the coordinates on a map or Signal to Noise Rate (SNR) along the time.

Coordinates shows on a map
SNR representation.
Integration of Lora and Sofia2

IoT Technologies and its support in Sofia2


IoT technologies make it easy to connect all kinds of things to the network and develop applications to control and manage these “things”. All the complexities of enabling connectivity, services, and deployment for these devices is the task of the IoT platform.

An IoT platform ensures integration with different hardware devices supporting a wide range of communication protocols. Through the integration interfaces provided by the platform, you can also manage the IoT data collected to specific systems for data visualization, data storage, as well as transmitting data to connected devices (configuration, notifications) or between them (controls, events ).

IoT platforms are also known as IoT Middleware, which underlines its functional role as mediator between hardware and application layers.

Let’s see an IoT flow and the components involved:


Sofia2 supports each and every one of the modules in the previous diagram as follows:


         Generic IoT Platform                                  Sofia2 IoT Platform

p2                 thingssofia2

We understand Things as any device that is capable of sending data, whether sensors, surveillance cameras, robotic arms, Smart watch … Some of the devices supported by Sofia2 are:

  • Devices:
    • Opening and closing doors sensor : CLIMAX, Leedarson, Nyce, Wulian, Centralite.
    • Environmental thermometer: Several manufactures
    • Pulsoximetros: several manufactures using IEEE protocol
  • Smart Home: presence sensor: CLIMAX, Leedarson, Nyce, Wulian, Centralite, DEVELCO.
  • Smart Building: Smart Plug: Meazon, 4-Noks
  • Smart Retail:
    • Thermostat: 4-Noks, Centralite
    • IP Camera: D-LINK, Panasonic
    • Temperature and humidity sensor: Wulian, Centralite, Leedarson
    • Smoke and gas sensor: CLIMAX, DEVELCO, Leedarson, Wulian
    • Flood sensor: Centralite, CLIMAX, DEVELCO, Wulian
    • Light sensor: Leedarson
    • Smoke Listener: Centralite
    • Siren: Metalligence, Wulian
    • LED illumination: LG, Leedarson
    • Switches: CLIMAX, Centralite
    • Thermostatic valve: CLIMAX
    • Weather station: Adafruit sensors
    • Beacon: Indra, Estimote
    • Panic button: CLIMAX, Centralite
    • Smart Meters: Several manufactures
  • Smart Cities: Environmental humidity sensor: several manufactures
  • Smart Traffic: Sensor power consumption: several manufactures
  • Smart Agro: Flowmeter: several manufactures
  • Smart Tourism:
    • Tensiometer: several manufactures
    • Potentiometer: several manufactures
    • Smart metering: several manufactures
    • Traffic ligth: Cross
    • Intelligent lighting: UVAX, LUIX
    • Libelium sensors
      • Air Quality
      • Atmospheric pressure
      • Temperature
      • Humidity
      • Luminosity
      • Waspmote internal temperature, batterty level, accelerometer
  • Smart Health: scales, several manufactures using IEEE protocol
  • Smart Insurance:
    • Tensiometers: several manufactures using IEEE protocol
    • Thermometer: Fora
    • Glucometer: Fora
    • Nociceptor: several manufactures
    • Anesthesia tower: Drager, General Electric
    • Pressure sensor in bed
    • Fall sensor
    • SmartBand: Withings
  • Otros:
    • Quadrirotor/Drone: Indra, 3DRobotics, Microsoft IPCam
    • Rover/Drone: Indra
    • Raspberry Pi: Indra
    • ARduino

In addition to supporting the data collection of all these devices, Sofia2 also allows the ingestion of data from other types of sources, such as RRSS, APIs and general files:



Generic IoT Platform        Sofia2 IoT Platform

p3.PNG    Comunicacion Sofia2

Sofia2 is agnostic of the communications, with implementations in multiple protocols of light communication (REST, OPC, MODBUS,  WebSockets, MQTT, WS, JMS, AMQP…)

In addition, among others, the gateways supported by Sofia2 are:


Services and Cloud

 Generic IoT Platform                                   Sofia2 IoT Platform


In the platform Sofia2 the following elementary concepts are defined:

smart space sofia2


It is the collaborative universe of systems and/or devices (ThinKPs) that exchange information between them. The core of a Smart Space is the SIB (Semantic Information Broker):

SIB: It is the core of the Smart Space, acts as an element of integration of the information exchanged by the devices. There may be several in a Smart Space.

ThinKP: Each of the systems and / or applications that interoperate in the Smart Space through the SIB must be defined as ThinKP in the same. The ThinKP is an element deployed in the Smart Space that can consume and/or produce information.

Ontology: Semantic atomic element with which to model the different information systems that interoperate in the Smart Space domain.

Ontologies are semantic descriptions of a set of classes. In this way, applications that share classes (usually called concepts) of the same ontology, can exchange information through concrete instances of these common classes.

In Sofia2, these ontologies are represented in JSON-Schema format that defines and validates them.

In terms of data storage in Sofia2 we distinguish between:


For each ontology can be configured a time window from which the information is considered ‘historical’.

The information remains in this database until it is automatically migrated to the historical information repository.

The stored information will be available as data source for the different modules of the platform: Integration, Machine Learning, APIManager.

Sofia2 has an API Manager with the following capabilities:


Apps and Analytics

Generic IoT Platform                             Sofia2 IoT Platform

p5   AppsyAnalyticsSofia2

In sofia2/console we will find the user interface and experimentation environment with all the capabilities of the platform. In it we can not only create Ontologies to model our data, ThinKPs or ingest data files or RRSS, but also we can create rules (SCRIPTS) to process all this information in the way we are most interested, to visualize this data in Gadgets and Dashboards Or publish ontologies via API. We also have Analytics modules that will allow us to create pipelines and notebooks, or create Machine Learning flows:


To conclude, here we can see the architecture of the platform Sofia2:


As well as an overview of the Sofia2 components:

flujo general Sofia2

IoT Technologies and its support in Sofia2

Minsait impulses IoT Smart Cities solutions with Sofia2


Minsait, Indra’s digital transformation unit, its promoting the construction of solutions with high innovative content in the scope of Smart Cities, through their participation in the European program of I+D Smart Cyber ​​Physical Systems Engineering (CPSE) Labs, which purpose is the creation of a collaborative network of expert centers in engineer for developing cyberphysicists systems in the areas like smart cities, automotive or urban sustainability.


FEEP IoT&BigData Platform Sofia2 has impulsed the development of solutions with high value added in clients of scopes like Smart Cities (La Coruña urban platform) or Smart Health (TELEA project, for teleassitance, and SISENS for monitorize the pacients, both of them in the Sanity Galician Service), in addition, is the technological base for projects of diferents indole:

  • Develop for an intelligent water management system, capable of reaching a save to a 40% in consume, integrating heterogene information from diferent devices and systems, in addition be able to process thousands of events per second, with Big Data capabilities and integrated rules. Project iWESLA.


  • Two new projects that has been recently started to try out the use of drones as information source for the new european emergency calls system and impulse the sustainable development in cities.


  • Development of e-Vacuate, an european project for the innovation wich purpose is developing a simulating and management emergency system and IoT and Big Data technologies to define in real time optimal evacuating routes for big infrastructures.


  • In fields like domotic, industry and retail, through solutions like Connected Home, Smart Cities, Industry 4.0, as well as severals solutions destined to the energetic eficiency world and sustainable in infrastructures.


  • Building solutions in I+D projects in transport sector, like ITRail or Transforming Transport, or space, like Land Analytic Eo Platform


If you want to know more about the developed and in progress projects in Sofia 2 platform click here to see the press release

Minsait impulses IoT Smart Cities solutions with Sofia2

Logroño adjudica la implantación de su Plataforma Smart City



La Junta de Gobierno Local del Ayuntamiento de Logroño, en su sesión del pasado miércoles 12 de Abril adjudicó el suministro, implantación, desarrollo y mantenimiento de la Plataforma ‘Smart Logroño‘ a la UTE Indra Sistemas y Suma Info.


FEEP IoT&BigData Platform Sofia2 servirá como base tecnológica para este proyecto que se extenderá hasta 2021.



Según ha informado el portavoz del equipo de Gobierno municipal, Miguel Sainz, la propuesta de la UTE adjudicataria “proporciona una solución de plataforma de gestión integral robusta, consolidada y madura” que, además, contempla la propia evolución de la plataforma con una visión “global e integradora de la ciudad, la administración y los ciudadanos.

La plataforma incluirá “dos portales de información”, de los que el primero será de acceso a los datos públicos, “un ‘opendata’ que proporcionará información municipal sobre cifras estadísticas y de servicios de gran utilidad para que los emprendedores puedan tomar decisiones y crear negocios”.


El segundo de los portales, será el “Smart city”, que “permitirá que las relaciones del ciudadano con el Ayuntamiento sean más transparentes” y tendrá acceso directo a contenidos de la plataforma, como el servicio 010, la gestión del tráfico y alumbrado y “un proyecto piloto de la gestión y manejo de la red municipal de aguas”.


También se plantea la normalización de la información, gestión de dispositivos, gestión analítica y georreferenciada de los datos y la elaboración de mapas, informes e indicadores para la gestión de los servicios.








Logroño adjudica la implantación de su Plataforma Smart City

Comparison of free versions on IoT platforms



In this post we compared capabilities of several IoT platforms (Sofia2, Azure IoT, Watson IoT and AWS IoT). Today we want to compare what each of these platforms offer without cost.


On one hand, the IoT Watson platform from IBM includes a maximum of 500 registered devices, a maximum of 500 application links and up to 200 MB of data:





For its part, Microsoft Azure, allows up to 500 devices and 8000 messages per day:




As well as a message size of 0.5 KB:




AWS IoT, allows up to 250,000 messages published or delivered per month:




And Sofia2, in its CloudLab environment, allows you to use the IoT version of the platform without any limitation, either at the level of connected devices, nor the number or size of messages that circulate through the platform:



In table format we would be talking about:


   Number of Max Devices Allowed Data

Azure IoT Hub


8000 Messages/day



8300 Messages/day

Watson IoT Platform


200 MB/month

Sofia2 IoT Platform Unlimited


Comparison of free versions on IoT platforms

Minsait impulsa soluciones IoT Smart Cities con Sofia2


Minsait, la unidad de transformación digital de Indra, está dando un nuevo impulso a la construcción de soluciones de alto contenido innovador en el ámbito de las Smart Cities a través de su participación en el  programa europeo de I+D Smart Cyber Physical Systems Engineering (CPSE) Labs, cuyo fin es la creación  de una red colaborativa de centros expertos en ingeniería para el desarrollo de sistemas ciberfísicos en áreas como  las ciudades inteligentes, automoción o sostenibilidad urbana.


Seguir leyendo “Minsait impulsa soluciones IoT Smart Cities con Sofia2”

Minsait impulsa soluciones IoT Smart Cities con Sofia2