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 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 which contains the model. (optional)
  2. Type: Database Query Connection to a Microsoft SQL Database.

Output Ports

  1. Type: Database Query Output Database Connection.

Find here


Make sure to have this extension installed:

KNIME Microsoft R Integration (Run R Model in Microsoft SQL Server)

Update site for KNIME Analytics Platform 3.7:
KNIME Analytics Platform 3.7 Update Site

How to install extensions