Tuesday, October 14, 2014

0 Master Data Service

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

image

It will bring up the website that show what components are missing from the server.

image

  • Static Content
  • Default Document
  • Directory Browsing
  • HTTP Errors
  • ASP.NET
  • ISAPI Extensions
  • ISAPI Filters
  • HTTP Logging
  • Request Monitor
  • Windows Authentication
  • Static Content Compression
  • IIS Management Console

image

image

After completed installation the necessary components , re run the Master Data Services Configuration manager

image

Create the database

image

image

image

image

Configure the web site.

image

image

image
After configure successfully, it will bring up the website.

image

image

image

Install Sample package

MDS installation come with sample package.

image

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. 

"C:\Program Files\Microsoft SQL Server\120\Master Data Services\Configuration\MDSModelDeploy.exe" deploynew -package "C:\Program Files\Micro
soft SQL Server\120\Master Data Services\Samples\Packages\customer_en.pkg" -serv
ice MDS1 -model customer

image

Master Data Excel Add-on

MSFT also provide Excel Add-on that can use to explore and update the data.

image

image

image

After we fix the data, we can also upload .

image

Reference

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates