Alternative of LinkedServer using WSO2 Dataservice?-CodePudding

I have a use case in which i use linkedserver in my database sql server but i would like to handle this in wso2 instead of using linkedserver is it possible ? my use case that i have inner join between two table in different database server.

My actual LinkedServer Query

SELECT local.name AS LocalLogins, linked.name AS LinkedLogins  
FROM master.sys.server_principals AS local  
LEFT JOIN [SRVR002\ACCTG].master.sys.server_principals AS linked  
     ON local.name = linked.name;  
GO

CodePudding user response：

If your requirement is to move the LinkedServer behaviour into the integration layer, you can achieve that with a workaround (by creating 2 data services). You can create 2 data services and invoke them using the integration layer and combine/ merge the results.

CodePudding user response：

In a Dataservice the Query will be directly passed to the underline Database, so if your Database Server is able to handle the Linkedserver query you should be able to use the same query in a Dataservice.

If you want to get rid of the linked query altogether and use WSO2 instead, there is no inbuild capability in WSO2 for such operations, hence you will have to create some integration logic to retrieve data from both servers separately and get the intended data by doing some processing.