This is tantilisingly close to working with Neo4j, but just a step away!
We have installed the latest jdbc drivers from Neo4j, https://github.com/neo4j-contrib/neo4j-jdbc/releases/tag/3.0, and have used it to connect an instance of the graph database. This worked. We then try to pull some data out in a database reader node. The cypher query is
Match (p:product) return p
which should return all the nodes which are products.
it does return, but only the first node makes it to the output table. It returns as a string that can be turned into a json type.
it seems the JDBC driver does not return a unique row number in the ResultSet.getRow() method which causes KNIME to fail. It would already solve the problem if the driver would simply throw an SQLFeatureNotSupportedException which isn't the case. The Database Connection Table Reader node has an option to ignore the database row number and use an internal counter instead. We plan to add the same option to the Database Reader as well. We might be able to add the option to the node with the December release but I can't promiss it. Until then you will need to use an external tool to read the data into a file which you can then load into KNIME with the CSV or File Reader for example.
That would be great, the database nodes are very convenient for constructing the queries, we are currenly using the rest nodes, and have also been trying python via bolt. However, they are much trickier to write a query.
We have just released a preview of the new database framework which is available via the labs update site. This comes with a new DB Query Reader node which no longer uses the db row id and thus should solve your problem. Give it a try and let us know if you encounter any problems.
Bye
Tobias
I could successfully connect to Neo4J and run Cypher queries against it, using py2neo on python nodes. If it helps, I can provide you with sample code.
from py2neo import Graph, types
from pandas import DataFrame
graph = Graph(host="x.x.x.x",
http_port=7474,
user="xxx",
password="xxx",
bolt=False)
# Your query here
# Notice that returned values have basic KNIME types (eg. String, Int and so on)
query = "match (h:History)-[rt]-(t:Concept)-[rc]-(c:Concept) where toString(h.id) =~ '20180624114754.*' return h.id, h.fsn, h.daydate"
result = graph.run(query).data()
df = DataFrame(result)
output_table = df.copy()
I got some basic Neo4J functionality working recently using the “old” database connector nodes and JDBC connection, but wondered if anyone has managed to use the OrientDB JDBC driver in KNIME - I tried, but cannot open a connection to a running OrientDB server. I also wondered if there are any plans for graph database integration either via specific nodes for OrientDB or Neo4J or possibly using tinkerpop?