The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
Has anyone tried to connect neo4j with RapidMiner before? There is very little to read on this subject from google searches. There are jdbc drivers available for neo4j but I'm not exactly sure how to get RapidMiner to use those drivers to connect to the database. This is the link to neo4j jdbc drivers -
http://neo4j-contrib.github.io/neo4j-jdbc/
Thank you.
I've never done this but I would follow: http://docs.rapidminer.com/server/administration/creating-connections/creating-db-conns.html
I believe one our Wisdom presenters (Rel8ted) did connect Neo4j to RapidMiner.
Thank you Thomas,
I sent them an email (info@rel8ed.to) however one of their data analysts replied saying that while they use neo4j, they do not use it from inside RapidMiner...
To connect RapidMiner to Neo4j use the following process using the Neo4j JDBC/Bolt driver.
1) In RapidMiner Connections menu: select "Manage Database Drivers"
2) Add a "Neo4j" Database driver like in the following picture
JDBC Bolt connections to Neo4j are supported from Neo4j version 3 and onwards.
See https://github.com/neo4j-contrib/neo4j-jdbc
3) Drag and drop the "Read Database" operator in the RapidMiner process as shown in the following picture.
Please note that in the "Read Database Parameters" tab I selected the previously defined/named "Neo4j" database driver as the "connection" Parameter.
4) Select in the "Read Database Parameters" tab the "Build SQL Query" button.
5) Insert a Cypher query as a (pass through) "SQL Query" like in the following picture.Please note that in my Neo4j graph database "Organization" is a Node label and "guid" a Node property.
Replace these with your own Node labels and properties.
6) Select in RapidMiner "Run current process"(F11).
You should see a resultset as demonstrated in the following picture.
You don't have to enable "Beta Mode" in RapidMiner as shown in the picture. "Beta Mode" is shown in the picture because I was previously experimenting with RapidMiner beta functionality (H2O operators) in RapidMiner.
That's all!
Now you can use Neo4j Cypher MATCH/RETURN resultsets as input for RapidMiner operators/processes.
Please note that the resultset is a flattened table created from the Neo4j Cypher MATCH/RETURN subgraph. The graph structure is gone, it's flattened into a table.
The graph structure is gone, it's flattened into a table formatted resultset.
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
.jpg "RM Read Database (Neo4j jdbc).jpg")
