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