Dear FIWARE Tech Help,

I'm faced with the task of migrating previously collected environmental
datasets (weather, airquality, noise etc) from sensors deployed in
different locations, and stored in several tables of MySQL database, to my
instance of fiware Orion CB, and thus persisted to fiware backend.

The challenges are many:

• the data isn't stored in fiware standards, so must be transformed
  according to the fiware data models.
• not all tables are a good candidate of being transformed to an Entity.
• some Entities need have field values from several tables as
  attributes. For instance, defining AirQualityObserved Entity-type would
  have attributes from these tables: airquality, co, co2, no2 and
  deployment. So mapping these attributes to a particular Entity-type is a
  challenge.

As this is a one-time upload (not live data), I am thinking to approach the
task by creating a Python script that "pretends" to be a contextProducer to
the Orion instance, sending data (say every 5sec) until the last record.

My greatest challenge however is the data fields --> Entity's
attributes mapping
that actually need be combined from several tables. I have not come across
any previous solution to similar problem, to get me going.

Is there any recommendations from FIWARE Foundation for situations similar
to this? Any help would be appreciated.

Many thanks,

Akil.

__________________________________________________________________________________________

You can get more information about our cookies and privacy policies on the following links:

• https://wiki.fiware.org/FIWARE_Privacy_Policy
• https://wiki.fiware.org/Cookies_Policy_FIWARE

Fiware-tech-help mailing list
Fiware-tech-help@lists.fiware.org

To unsubscribe from Fiware-tech-help mailing list, go to the information page of the list at:
https://lists.fiware.org/listinfo/fiware-tech-help

[Created via e-mail received from: Akil Rilwan <akilrilwan@gmail.com>]