Different database connections not supported

KNIME Analytics Platform
1

Hi,

I’m trying to execute a DB joiner node with input tables from two different databases. Hence using two separate MS SQL Server Connector nodes. And the DB Joiner throws a warning message “Different database connections not supported”. Is there any workaround or solution for this problem?

Thanks,
Vijay

2

There is this example of a streaming transfer between two databases. Otherwise you would have to download the data and upload it again. If the data is in different DBs there is no magic that can just bring it together.

5 Likes
3

Thanks for the swift response. So looks like the DB Reader node must be used with or without streaming.

1 Like
4

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