You can translate the question and the replies:

Dendo Design Studio's problem with Neo4J

Hello Team, I'm using Denodo 8 via Web Design Studio. I created the Neo4j datasource via HTTP configuration with post method, also making use of a Json file. I inserted the fields via the following source query: \{"statements": [ \{ "statement": "MATCH p=(a)-[r:X]->(b) RETURN a.A as A, a.B as B, b.C as C, b.D as D"\}] \}. Once the base view has been created, when I go to create the flatten file I cannot flatten it because I don't get the icon (point 2 of the following link: to flatten the array. Thanks

1 Answer

Hi, It is possible to use flattening on hierarchical structures and Denodo supports two different complex data types at the moment which are Registers and Arrays. For more details, please find [this link]( The statement in your initial question is showing that it will return only 4 fields (a.A, a.B, b.C and b.D) with the relationship of p=(a)-[r:X]->(b). It is possible that the flatten button is not activated when the design studio cannot find anything to be flattened. I would verify the base view by executing it and see the result set returned from neo4j to see if the resultset needs to be (can be) flattened or not. Hope this helps.
Denodo Team
24-11-2022 03:06:10 -0500
You must sign in to add an answer. If you do not have an account, you can register here