[Backlogmanager] [FIWARE-JIRA] (HELP-16774) [fiware-stackoverflow] Postgres Db Table name is encoded using the NGSIToPostgreSQL processor from Fiware Draco

[Fernando Lopez (JIRA)]

     [ https://jira.fiware.org/browse/HELP-16774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fernando Lopez reassigned HELP-16774:
-------------------------------------

    Assignee: Andres Muñoz

> [fiware-stackoverflow] Postgres Db Table name is encoded using the NGSIToPostgreSQL processor from Fiware Draco
> ---------------------------------------------------------------------------------------------------------------
>
>                 Key: HELP-16774
>                 URL: https://jira.fiware.org/browse/HELP-16774
>             Project: Help-Desk
>          Issue Type: Monitor
>          Components: FIWARE-TECH-HELP
>            Reporter: Backlog Manager
>            Assignee: Andres Muñoz
>              Labels: fiware
>
> Created question in FIWARE Q/A platform on 09-06-2020 at 09:06
> {color: red}Please, ANSWER this question AT{color} 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



--
This message was sent by Atlassian JIRA
(v6.4.1#64016)