Qlikview to Neo4j Connectivity

[#1]

Hi,

I'm using 11.20..11643.0 IR version. Is it a stable qlikview version?

I'm  trying to connet to neo4j which is a graph database using JDBC connector but not able to connect to neo4j. Is it because of the qlikview version?

After installing the jdbc connector and when i tried to connect to qlikview and test the connection its saying No Suitable driver found.

Below is the screen shot of the error:

Thanks,

Shree

[rbecher]

Please install Java 7.

[#3]

Hi Ralf, After installing the Java 7 , i'm able to connect to Neo4j. Thank you so much

Also i have one more doubt. I i'm successfully established the connection to neo4j. But when i  want to select/ load the neo4j data into qlikview , how can i do it.? Because after connecting to neo4j, when i click on Select  to selet the neo4j data nothing is shown . Below i have attached the screen shot:

One more thing i would like to ask  is  , is it the same procedure for connecting to hbase and mongoDB?

I have hbase jars with me  and i'm not sure which are the jars to add and which are the necessary jars requried?

Also can i use the same JDBC driver which is used for neo4j  for habse as well ?

Pls help me on this.

[rbecher]

There are no tables in Neo4j, you have to code Cypher queries. You can find an example here:

Working with Graph Data from Neo4j

HBase or MongoDB is a different story. For HBase you can use Pheonix SQL Layer JDBC driver and for MongoDB the UnityJDBC driver.

- Ralf

[#5]

Hi Ralf,

Can you please look into the thread which i have posted on Qlikview and hbase connection.

The link is :

Qlkiview to hbase connection

[#6]

Hi Ralf,

I have some issues with Qlikview and neo4J. As i told i'm able to connect to neo4j using JDBC driver. So after connection when i used cypher neo4j queried in the qlikview edit script window, it's giving me a some error after executing.

does cypher queried are supported in qlikview ?

I have attached the queries  used and the error I'm facing.

please let me know where i'm doing wrong?

Thanks,

Shree

[rbecher]

You'll need to RETURN the field names of the objects with a given alias:

RETURN ID(r) as RelID, r as RelText, r.name as RelName ... etc.

[rbecher]

Btw. try to elaborate the Cypher query itself before in SQuirrel so you can see the resultset..

[#9]

Hi, i don't have SQuirrel installed with me now.

The cypher query i have used is :

SQL MATCH p=(Managers { name: "Adam" })--(Employees)

RETURN Managers, Employees, r;

So what is wrong with the query? Even i have used SQL in front of cypher query.

[rbecher]

As I wrote you'll need at least aliases:

SQL MATCH p=(Managers { name: "Adam" })--(Employees)

RETURN Managers as Managers, Employees as Employees, r as Relation;

But I also suggested to use the field names! If not, you will get some JSON results which cannot be easily handled in QlikView.

[rbecher]

Similar example from the movie graph db:

MATCH p=(Actor { name:"Carrie-Anne Moss" })--(Movies)

RETURN Actor.name AS ActorName, Movies.title AS MovieTitle, r.role AS RoleName;