Hello everyone ... again,
I will be quick and objective in explaining my problem. I want to create a Base View from a Neo4j database. I was able to connect the tools with the corresponding driver, placing it in the folder "<INICIO_DENODO> \ lib \ extensions \ jdbc-drivers \ neo4j -3.0 \ <neo4j-jdbc-driver> .jar", placing 'org.neo4j.jdbc.Driver 'as controller class and placing "jdbc: neo4j: bolt: // <HOST>: <PORT>" as URI of the database.
Then create a Base View, from a label, using the "Create from Query" option by typing the following:
"Match (n: DELIVERED_DIM) return n.id_delivered AS id_delivered, n.description as description"
After creating the Base View I put the option "Delegate SQL Sentence as Sub Query" to "No" to ensure the query Cypher will be executed in Neo4j. Then I open a VQL shell window and execute the following query:
"SELECT id_delivered, description FROM sop_dv.DELIVERED_DIM"
But I get the following error:
Finished with error: Error executing query. Total time 0.254 seconds.
DELIVERED_DIM [BASE] [ERROR]
DELIVERED_DIM [JDBC WRAPPER] [ERROR]
Look at the Output option, this error shows me:
DELIVERED_DIM [BASE] [ERROR]
DELIVERED_DIM [JDBC WRAPPER] [ERROR]
DELIVERED_DIM # 0 [JDBC ROUTE] [CONNECTION_ERROR] Unexpected error creating a connection: org.neo4j.driver.v1.exceptions.AuthenticationException: The client is unauthorized due to authentication failure. Received exception with message 'org.neo4j.driver.v1.exceptions.AuthenticationException: The client is unauthorized due to authentication failure.'
It shows me an authentication problem, but I put my credentials to create a connection and then from them create my Base Views. We need other credentials besides the user and password of Neo4j, for example what I put is:
user: neo4j
password: neo4j
I do not know what the problem might be, could it be a problem because I use bolt ?, could it be a problem with the Denodo version ?, or with the driver version or the Neo4j? Or simply when you make queries to a Base View has to do with another syntax?
I leave the versions of my tools:
Neo4j 3.1.1
jdbc Neo4j 3.1.0
denodo platform 6.0 (x86)
Note: try a connection using Pentaho Data integration, use the same driver and connect it, make a query in Cypher and execute without any error.
Sorry for the bad English :(
Please help!
kind regards,
Enrique Quiroz
