0 ×

Neo4j Reader

StreamableNeo4jconnector version 1.0.0.v202007061010 by REDFIELD

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

Icon
Neo4j connection

Output Ports

Icon
Table/JSON response
Icon
Neo4j connection

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

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

KNIME 4.3

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.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

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.