Home / Q&A / How to Create Base View in Denodo to a NEO4J data-source?
You can translate the question and the replies:

How to Create Base View in Denodo to a NEO4J data-source?

Hi All, I know that a very similar question was asked before, but my problem is not connecting Denodo with Neo4j, I could connect the tools using the corresponding Driver, placing it in the folder "<DENODO_HOME> \ lib \ extensions \ jdbc-drivers \ neo4j-3.0 \ <neo4j-jdbc-driver> .jar ", placing 'org.neo4j.jdbc.Driver' as Driver class and placing" jdbc: neo4j: bolt: // <HOST>: <PORT> "as Database URI. The problem I have is when I want to create a "Base View" of my Neo4j database, but when I select "Create Selected" it throws me an error "Unexpected error accessing the server". I have tried with the "Create from Query" option, but it does not work for me. King Regards, Enrique Quiroz
Neo4j JDBC Create Base View Connection
user
01-04-2018 17:09:31 -0400

6 Answers

Hi, Currently, the only possible way to create base views from Neo4j database is by using "Create from Query" option. I followed the below steps and I was able to create the base views successfully: * In Virtual DataPort Administration Tool, open the data source which is created over Neo4j database and click on the “Create base view” option at the top. * Select the ‘Create from query’ option. * Enter the view name and the SQL query on the ‘Create Base View from SQL Queries’ dialog. * Click ‘Ok’ and click on ‘Save’ to create a base view. You can have a look at [Creating Base Views from SQL Queries](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/jdbc_sources#creating-base-views-from-sql-queries) section of Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
02-04-2018 08:46:26 -0400
Hi, Thanks for answering. Now create the "Base View" using "Create from Query". However, I do not know which is the query that I have to put in order to be able to show me data. I wrote the following: "match (n: DELIVERED_DIM) return n.id_delivered AS id_delivered, n.description as description" And with that I could create the "Base View", but when I want to make a query to that "Base View" with, for example "SELECT * FROM sop_dv.delivered_dim" it throws me error: DELIVERED_DIM [BASE] [ERROR] DELIVERED_DIM [JDBC WRAPPER] [ERROR]
user
04-04-2018 12:10:28 -0400
Hi, For this scenario, I would ensure to set the option **Delegate SQL Sentence as Sub Query** to **No** in the Source configuration of the base view which is created upon the Neo4j datasource. This setting would ensure that the Cypher statement is executed in Neo4j. You could find the option **Delegate SQL Sentence as Sub Query** by navigating to "*Options -> Search Methods -> Wrapper Source Configuration*" of a base view. Once the modifications are done, query the base view to get the expected results. Hope this helps!
Denodo Team
12-04-2018 00:32:15 -0400
Hi, Thanks for responding, I tried to change the option "Delegate SQL Statement as Sub Consulta" to No. But it still throws the same error. It is possible that it is due to a problem of version of the database Neo4j 6.0?, I have version 3.1.1. Or maybe it is an error due to the driver version? I am using version 3.1.0. DELIVERED_DIM [BASE] [ERROR] DELIVERED_DIM [JDBC WRAPPER] [ERROR] regards
user
13-04-2018 18:31:08 -0400
Sorry I confused version, I wanted to say the following versions: - Neo4j 3.1.1 - jdbc Neo4j 3.1.0 - denodo platform 6.0 (x86)
user
13-04-2018 18:36:11 -0400
we are encountering the same issues when using the select statement from Neo4j base view. We changed the option “Delegate SQL Statement as Sub Consulta” to No, but still not work. We got [JDBC Wrapper][Invalid Route] error. Just wonder has anyone managed to excute select statment from Neo4j base view ?
user
14-09-2021 12:18:14 -0400
You must sign in to add an answer. If you do not have an account, you can register here