How to map a linked server in DB Table Selector?

KNIME Analytics Platform
1

Hi,
I am facing issues in mapping the schema and table in DB Table Selector node where i wanted to get the data from a View in the linked server. can someone help me here pls?

In Microsoft SQL SMS the query is working fine as “select * from [LinkedServerName1]…[View].[TableName1]”

Thanks in advance.

2

Hello @gokulpnair,

Could you try clicking the “Custom Query” checkbox in the DB Table Selector node and running the same query you mentioned earlier to see if you can access the data? This will not require the schema mapping and might help you to fetch the data from the linked server.

Best,
Keerthan

2 Likes
3

Thanks @k10shetty1 - I am currently using this method, but would like to know if we have any solutions for the mapping part- especially in the linked server. Thanks in advance.