Integration

Hi there,

I am trying to create a Logical DS to combine several Physical Data Services which are returned from queries against multiple databases which have the same System installed. Currently there is a view in each physical implementation for several installed databases and I have created Physical Data Services 1 to 3 (in Prod there will be dozens). Now I am trying to build the logical DS that combines and sorts these results. I have a little research that points me to the XQuery UNION construct (I would use that in SQL), but I have not been able to find any sample code for ODSI.

Has anyone done this before? If so please provide some sample code if possible.

The goal is to build a new "Multi-tennant" Data Service that will provide a simple means to query against each of the physical implementations and perform some aggregation as desired without the constraints of the physical implementation.

Thanks,
David.