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 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.