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

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.

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.

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.

This node has no views

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.

To use this node in KNIME, install the extension Neo4j extension from the below update site following our NodePit Product and Node Installation Guide:

v5.3

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

Plugin provider: REDFIELD

Plugin version: 1.0.3.v202312150320

On NodePit since: 2024-07-11

Last update: 2024-11-15

Tags: Streamable

KNIME versions: v5.3, v5.2, v5.1, v4.7, v4.6, v4.5, v4.4, v4.3, v4.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.