Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).
In this article we cover the steps for creating an MDS view.
Why Create an MDS View?
MDS views allow multiple databases to be used to create a single View by sending a query to each database and combining the results into another query using the MDS database.
Steps To Create an MDS View.
1. Open VDM.
2. Add the desired fields from the first database.
3. Add the desired fields from the second database.
Note: Once you add fields to the View from another database, the MDS indicator will be enabled.
4. Make any needed adjustments to the linking.
5. Run the View and verify the results.
Note: Since the View is MDS, VDM will send one query for each database and combine the results in an MDS query. If you view the logs you will see 3 queries in total. See below for the different queries being sent.
Image: First two individual queries being sent
Image: MDS Query being sent