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.
Go to Suggested ReplacementRun R Model in Microsoft SQL Server

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

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

Output Ports

Icon
Output Database Connection.

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

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.