Run R Model in Microsoft SQL Server

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

Options

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

Templates

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

Input Ports

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

Output Ports

Icon
DB Data referencing the result table from the R script.

Popular Predecessors

Popular Successors

Views

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

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.

Installation

To use this node in KNIME, install the extension KNIME Microsoft R Integration (Run R Model in Microsoft SQL Server) from the below update site following our NodePit Product and Node Installation Guide:

v4.7

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

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 4.7.0.v202211142020
On NodePit since: 2022-12-06
Last update: 2023-05-28
KNIME versions: Since v4.1