How to Join two datatables there are in two different server

[rumabharathy]

I need to join Two data tables there are in two different server.

Are there any SQL query to do that?

I know if Two data tables are in single server, I can easily use below SQL query to
“Insert into [UiPath_Dev].[dbo].[VendorInventory_Onsale_JoinResult]
Select
t1.ArticleNumber,
t1.OnhandStockBalance,
t2.MaterialNumber,
t2.RSArticleNumber,
t2.VendorNumber
from [UiPath_Dev].[dbo].[VendorInventory_Onsale_Main] as t1
left join [BODS_Prod].[dbo].[MaterialStatus] as t2 on t1.ArticleNumber=t2.RSArticleNumber”

But my problem Two data tables there are in two different server.

[Anil_G (Anil Gorthi)]

@rumabharathy

You can read both the datatable and then use join in UiPath datatable activities

Or you can try this approach of creating stored procs

Joining tables from different servers

Cheers