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 .
- Type: PortObjectR WorkspaceR Workspace which contains the model. (optional)
- Type: DB DataDB DataDB Data defining the input data of the R script.