Created question in FIWARE Q/A platform on 09-06-2020 at 09:06
Please, ANSWER this question AT https://stackoverflow.com/questions/62276979/postgres-db-table-name-is-encoded-using-the-ngsitopostgresql-processor-from-fiwa

Question:
Postgres Db Table name is encoded using the NGSIToPostgreSQL processor from Fiware Draco

Description:
Context

We have some data from sensors which is published on Firware Orion. We'd like to visualize the data in the Fiware CKAN Open Data Portal using Fiware Draco. At this moment the Draco (Nifi with NGSI extension) creats a table in the PostGres public namespace with an encoded name. This is an issue because the CKAN portal requires a valid guid as table name.

Nifi template config

The image below gives a high lever overview of the flow
nifi template config
The update attributes processor configures the id of the resource in the CKAN datastore:
enter image description here

The id of the resource in the CKAN db

A resource created in the CKAN stores some metadata in the CKAN db. The id of this metadata has to be equal to the tablename in the datastore db.
Which is an issue at the moment because the NGSIToPostgreSQL processor encodes the tablename.

enter image description here

I already tried to disable the encoding. This is not a solution because data updates will fail throwing following issue:
enter image description here