Neo4j Reader

The node allows user to run queries for extracting data from Neo4j, any queries that change the state of DB will be rolled back. There are two modes available:

• Script – active when there is no input table connected. User can create a Cypher script with injections of labels for nodes and relationships, and available server functions to extract data from the database. Schema is fetched with functions db.labels, db.relationshipTypes, dbms.functions. The output data will automatically matched to Knime table compatible types if possible, otherwise JSON columns will be produced.
• Query from table - if the table is connected, then the user can select the string column that contains Cypher queries.

Options

Script

Use JSON output

if active the result will be returned as a JSON column. Otherwise the node will try to return a Knime table with best match for Knime types.

Stop on query failure

if active the node will return an error and stop execution in case the query was not successfully executed. Otherwise node will produce an empty table and a warning message.

Script body

the text box, where use can put Cypher query with nodes, relationship, function and flow variables injections.

Query from table

Column with query

queries from the selected string column will be executed. Results will be returned as a JSON column.

Stop on query failure

if active the node will return an error and stop execution in case the query was not successfully executed. Otherwise node will produce an empty table and a warning message.

Input Ports

Neo4j connection

Output Ports

Table/JSON response

Neo4j connection

Best Friends (Incoming)

• Neo4j Connection (28 %) 
• Neo4j Writer (24 %) Streamable
• Table Row To Variable Loop Start (10 %) Deprecated
• Table Creator (10 %) 
• Value Selection Widget (7 %) 
• Show all 11 recommendations

Best Friends (Outgoing)

• Extract Column Header (17 %) 
• Nominal Value Row Filter (14 %) Streamable
• Ungroup (13 %) Streamable
• Neo4j Writer (13 %) Streamable
• String to Duration (11 %) Streamable
• Show all 13 recommendations

Workflows

• Chemistry documents semantics by Redfield (KNIME Hub) 
• Cocktails_​graph_​with_​Neo4j_​by_​Redfield (KNIME Hub) 

Installation

To use this node in KNIME, install Neo4j extension from the following update site:

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.