You can translate the question and the replies:

How to Connect Denodo to a NEO4J data-source?

Hi All, I want to connect Denodo to a NEO4J Source. We have the JDBC driver (.jar) and this JAR file is working. How should we connect Denodo to NEO4J? I Can't select NEO4J when creating a new JDBC Source. King Regards, Chris Bos
user
17-03-2018 16:55:38 -0400
code

4 Answers

Hi, In order to connect to Neo4j data source from Denodo Platform, I would do the following steps: 1. Place the necessary JAR file in the following folder <DENODO_HOME>\lib\extensions\jdbc-drivers\neo4j-3.0\ <neo4j-jdbc-driver>.jar. 1. In JDBC data source connection wizard, select the Database adapter as 'Generic'. 1. Browse the folder 'neo4j-3.0' as Driver class path(optional) and class as 'org.neo4j.jdbc.Driver' 1. Configure Database URI as 'jdbc:neo4j:bolt://<HOST>:<PORT> and supply the necessary login credentials. After creating the Base Views from Neo4j data source, set the “Delegate SQL Sentence as Sub Query” to “No” in the Source configuration of the generated base view by navigating to the 'Base View' > Options > Search Methods > Wrapper Source Configuration in order to successfully execute and view the data from base views. For more information, you can refer to the section [JDBC Sources](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/jdbc_sources#jdbc-sources) and [View Configuration Properties](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/advanced_configuration_of_views/view_configuration_properties#view-configuration-properties) of the Virtual Data Administration Guide to know more information I hope this helps you!!
Denodo Team
19-03-2018 02:41:39 -0400
code
Hi Denodo team, Thanks for the reply / info. I have followed your steps (JDBC Configuration). NEO4J environment is running ok, I am able to connect with Squirel with the same JDBC driver and username/password on the same machine like Denodo is installed. When I use the BOLT Connector: jdbc:neo4j:bolt://127.0.0.1:7687/movies and I try to test, I get this error: Unable to establish connection: a database access error has occured. what does this error mean, where can I look for a solution ? When I use the HTTP connector: jdbc:neo4j:http://127.0.0.1:7474/movies and I test this one, I get a successfully, but when I go to create View TAB, I get an error "unable to connect to the database" Are there options to check what's going wrong ? Kind Regards, Chris Bos
user
22-03-2018 05:46:29 -0400
127.0.0.1 is not the IP address of your Neo4j server. You need to replace that with the IP of your server. You also have http:// in the string, but should not. jdbc:neo4j:bolt://<HOST>:<PORT> where <HOST> is the IP or FQDN of your server, followed by a colon and the listening port (usually 7687 for bolt)
user
04-09-2020 16:28:22 -0400
Hi, I tried using both 127.0.0.1 as well as localhost in the JDBC URI configuration like below: * jdbc:neo4j:bolt://127.0.0.1:7687/movies * jdbc:neo4j:bolt://localhost:7687/movies * jdbc:neo4j:http://127.0.0.1:7474/movies * jdbc:neo4j:http://localhost:7474/movies For me the connection was successful in both the cases by passing the appropriate username/password. Currently, the only possible way to create base views from Neo4j database is by using “*Create from Query*” option. After connecting to Neo4J, I was able to create the base view using the *Create from Query* option with a below cypher query. > MATCH (a:Movie) WHERE a.released > 1990 AND a.released < 2000 RETURN a.title,a.released,a.tagline Before executing the base view, I made sure that “Delegate SQL Sentence as Sub Query” is set to “No” in the Wrapper Source configuration of the generated base view. You can have a look at [Creating Base Views from SQL Queries](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) section of Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
17-09-2020 06:02:14 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here