Integrating R (ggplot2) into a KNIME workflow

Forum

I’ve been using KNIME to Extract and transform PostgreSQL data but I find the KNIME graphics capabilities clunky and have been told I can integrate R (ggplot2 library) into my workflow. I’ve found a couple of resources (i.e. https://hub.knime.com/knime/spaces/Examples/latest/07_Scripting/02_R/01_Example_of_R_Snippet) but am looking for the KNIME node that will read the database to get me started (accessing the DB).

Jeff

For the general access to a database you could use the KNIME DA Nodes:
https://docs.knime.com/2019-06/db_extension_guide/index.html

Then I have a few more examples of graphics using R and Python you might find useful.

R - multiple graphics

R - Venn Gram - Export graphics to PNG

R - Heatmaps with Dendrograms

Python - some graphics from the Iris data set

2 Likes

Hi there @reichmaj,

I know KNIME is missing some visualizations and features in existing ones but what is clunky about them? :confused:

Br,
Ivan

I simply am more comfortable with and like the power of R’s ggplot2

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.