Microsoft introduce MDS since SQL 2008R2 . The goal for MDS is to create the Golden Copy for the data and let the Business analysis has ability to correct the value by themselves without DBA involvement .
Configure the MDS
After install MDS, click the SQL Server 2014 Master Data Service Configuration
It will bring up the website that show what components are missing from the server.
- Static Content
- Default Document
- Directory Browsing
- HTTP Errors
- ISAPI Extensions
- ISAPI Filters
- HTTP Logging
- Request Monitor
- Windows Authentication
- Static Content Compression
- IIS Management Console
After completed installation the necessary components , re run the Master Data Services Configuration manager
Create the database
Configure the web site.
Install Sample package
MDS installation come with sample package.
We can use below command to install . The command needs to be run under admin privilege because it need to be able to access the folder.
Master Data Excel Add-on
MSFT also provide Excel Add-on that can use to explore and update the data.
After we fix the data, we can also upload .