0 ×

Run R Model in Microsoft SQL Server

KNIME Microsoft R-Project nodes version 4.3.0.v202011212005 by KNIME AG, Zurich, Switzerland

This node allows running R code on a Microsoft SQL Server (using a SQL query behind the scenes). Input and output data to the R script are SQL tables. In addition the knime.model (cannot be NULL, or will not be transfered to R otherwise) and knime.flow.in variables from a R port can be used in the R script. To output data from the R script to the output SQL table, assign a R data.frame to knime.out.

JDBC driver

This node requires the Microsoft JDBC driver to be used in the Microsoft SQL Server connector. You can install the driver extension from the KNIME Update Site (KNIME Microsoft JDBC Driver For SQL Server).


R Snippet

SQL Input
Shows the SQL query defined by the input port. Its result will be available as knime.in.
SQL Output Table Name
Name of the SQL table which knime.out will be written to.
Whether to overwrite when a table with the output table name already exists (failure otherwise).
R Script
The code being executed in R. Input data is available as a data frame named knime.in.


A template category defined by the author.
Names of the available templates.
A brief overview of the purpose of the template.
The code to be applied to your expression editor.

Input Ports

R Workspace which contains the model.
DB Data defining the input data of the R script.

Output Ports

DB Data referencing the result table from the R script.


R Std Output
The text sent to standard out during the execution of R executable as well as the text of the .Rout file generated by R.
R Error Output
The text sent to standard error during the execution of R executable as well as the text of the .Rout file generated by R. (If it appears in gray, it's the output of a previously failing run which is preserved for your trouble shooting.)

Best Friends (Incoming)

Best Friends (Outgoing)


To use this node in KNIME, install KNIME Microsoft R Integration (Run R Model in Microsoft SQL Server) from the following update site:


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.


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.