This repository is maintained by the KNIME Team Rakete.

This repository contains the plugins for the

• KNIME Interactive R Statistics Integration
• Windows R binaries for the interactive R integration
• KNIME Microsoft SQL R integration

plugins which contain a set of KNIME nodes for running R code in KNIME.

Please note: KNIME Interactive R Statistics Integration and Windows binary plugins are available through the KNIME update site while the Microsoft SQL R integration is contained in KNIME Labs.

The KNIME Interactive R Statistics Integration has its own port type, the R Workspace. It allows passing an entire R workspace, including all of its data, variables and loaded libraries, on to a subsequent node.

Nodes that accept an R workspace rather than just modifying it, load a copy of the entire workspace to ensure the same workspace can be reused by multiple subsequent nodes.

The above image shows the various nodes available in the KNIME Interactive R Statistics Integration plugin for KNIME.

• R Source nodes allow running an R code snippet to generate or load data and output it either as KNIME data table or as an R workspace port.
• R Snippet node allows running an R code snippet on an KNIME data table and outputs the result as a KNIME data table.
• R To R allows running an R code snippet on an existing R workspace.
• Add Table to R allows running an R code snippet on both an existing R workspace and a KNIME data table.
• R to Table allows running an R code snippet on an existing workspace and converts resulting data into a KNIME table.
• R Views allow running R code that generates a PNG image (e.g. plots) and outputs this image through an Image Port.
• R Learner and R Predictor allow learning an R model and running predictions using this model.
• R Model Writer writes an R model.
• R to PMML serializes an R model in the PMML format.

Currently this plugin only contains the Run R Model in Microsoft SQL Server node, which runs a SQL query with R code on a SQL table and outputs the result to a SQL table.

The node does not require an R environment, but instead a Microsoft SQL Server installation with Microsoft R setup.

You can download the example workflows from the KNIME public example server (07_Scripting/02_R/01_Example_of_R_Snippet - see here how to connect...) or from the KNIME node guide.

You can find instructions on how to work with our code or develop extensions for KNIME Analytics Platform in the knime-sdk-setup repository on BitBucket or GitHub.

• KNIME Forum