Forum Discussion
Direct Query with two linked servers?
I know Direct Query does not work when retreiving data from two separate servers, in which case Import must be used, but will it work if the two servers are linked?
Direct quyery have a several limitations
You should use a Data Virtualization Plataform such as Querona querona.com to connect multiple data sources and also permit to have the data on line