Using R snippet

Hi,
is it possible to connect R snippet to DBreader?
What should I write when I see knime.in - > knime.out?

Should I say in R snippet the source? but it is the db reader, so I think not.

Many thanks
Giada

Hi @giad -

No, you can’t connect an R Snippet to a DB Reader, as the port types don’t match.

In general, with the R Snippet node, knime.in and knime.out are special designations that refer to the input and output tables, respectively. It’s important to note that those tables are converted to R data frames when moving into or out of the node.

Can you provide more detail about what you’re trying to do, and then maybe we can come up with a solution?

2 Likes

You can do all sorts of things with KNIME and R and databases. You would need the right combination of ports and drivers (and always think about what would make sense and does run in an productive environment).

Here is an example how a CSV file could be handeled with KNIME, R and SQLite as an example for a database.

3 Likes

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