MDS - Multiple Data Sources

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

VDM is capable of connecting to multiple databases when building a View; referred to as Multiple Data Sources or MDS. Prior to creating a View that leverages Multiple Data Sources or VoV Joined Datasets, you must setup a local SQL Express installation.

 

Steps For Setting Up MDS

1. Download Microsoft SQL Server 2017 Express from https://go.microsoft.com/fwlink/?linkid=853017

2. Complete the install steps for a "Basic" installation and accept the defaults.


3. Record the SQL Express Instance details listed on the installation summary screen as it will be needed to create an Connection Profile:



4. After the SQL Server 2017 Express installation has been completed successfully, click on Database and select New from the Ribbon Bar inside VDM.

 

5. Create a new Microsoft SQL Connection with Prefix Enabled and define the Server, Instance and Database settings. Enable Trusted Connection and test the connection.



6. Once the profile has been created, tested and verified go to Settings and set MDS SQL Database to the newly created profile. 


mceclip0.png

 

 

Have more questions? Submit a request

Comments