help: query has two different databases that I need to access

KNIME Analytics Platform
1

Hi Guys,

I am trying to connect to two different databases within the same query… I have a database connector that works for one but when I try to do the joint query it won’t work.

Is there a way to access two differnt databases within the same query string?

Any help appreciated

2

You have couple of options:
Create a view/stored procedure/function in one of DB reading both sources;
Set a linked server for second DB
or read necessary data from both DB separately to KNIME and make join in KNIME.

3

I have no idea what that means. can you help explain better?