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

Input ports

1. Type: PortObject
   R Workspace
   R Workspace which contains the model. (optional)
2. Type: DB Data
   DB Data
   DB Data defining the input data of the R script.

Output ports

1. Type: DB Data
   DB Data
   DB Data referencing the result table from the R script.