Run R Model in Microsoft SQL Server

This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.

This node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.

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

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

: R Workspace which contains the model.
: Connection to a Microsoft SQL Database.

Output Ports

: Output Database Connection.

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

No workflows found

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:

v5.3

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

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 5.3.0.v202312081535

On NodePit since: 2024-07-09

Last update: 2024-11-21

Tags: Deprecated

KNIME versions: Since v3.6

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

Try NodePit Runner!