0 ×

OrientDB Command

OrientDB extension nodes version 2.0.80.v201906141205 by Redfield AB

Executes non-idempotent query. This node is used for uploading, updating and deleting data from database. Suggested commands: create, insert, upsert, delete. Cell type 'LocalTime' isn't supported! Don't use it as source table!

Options

Use column with command
Executes each value of the selected column as a query.
Use SQL statement
Executes user defined query.
Write table to class
Executes each value of the selected column as a query.
Use upsert
If not active new objects of the chosen class will be created. If active the objects will be updated according to unique index matching or created if no such index found or any objects matched. Properties for upload/update can be selected with filter. Column name must correspond to the class property names in the database. Returns JSON column with the results.

Input Ports

Icon
Input data table.
Icon
OrientDB Connection.

Output Ports

Icon
Output Flow variables.
Icon
Output data table.
Icon
OrientDB Connection.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install OrientDB Connection Nodes from the following update site:

KNIME 4.3

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.