Neo4j Writer

The node allows user to populate Neo4j with the data. There are three 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 be automatically matched to Knime table compatible types if possible, otherwise JSON columns will be produced.
  • Query from table - active if the table is connected, the user can select the string column that contains Cypher queries.
  • Batch script - active if the table is connected, the user can provide a Cypher batch script with references to the input table columns as the parameters for the query. The capabilities are similar to Script mode.

Options

Script

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 and status 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. All the transactions will be rolled back.
Use asynchronous query execution
if active all the queries will be running in asynchronous mode, otherwise there will be consequent execution starting from the top of the table.

Batch script

Use batch query
activates Batch query mode and deactivates Query from table mode.
Name for batch parameter
defines a batch variable name that can be used with UNWIND clause.
Batch Patterns
several examples with Cypher batch queries with wildcards, can be inserted to script body with double-click.
Column List
list of columns of input table, can be can be inserted to script body with double-click.

Input Ports

Icon
Neo4j connection
Icon
Table with the Cypher query

Output Ports

Icon
JSON response
Icon
Neo4j connection

Views

This node has no views

Workflows

Links

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.