locked
Master Data Services Web Application RRS feed

  • Question

  • How to create a master data services web applications?

    Suppose I have 2 sources from which I will load to master data services,how can I manage it from front end using visual studio express 2012 version?

    Thursday, April 11, 2013 10:03 AM

Answers

  • Hi,

    Master data web application can be created by "MDS configuration manager" (This would be availabe in start --> All Programs --> SQL Server 2012 --> Master Data Services if MDS is installed on the machine). Click the below link for more details: -

    Create MDS database - http://msdn.microsoft.com/en-us/library/ee633740.aspx

    Create MDS Web Application - http://msdn.microsoft.com/en-us/library/ee633729.aspx

    With regards to your second question. If you want to insert data manually, then you can copy paste the data into MDS via MDS-ExceAddIn.

    If you need to automate it, then create ETL's using SSIS and follow the EBS (Entity Based Staging) process. Please note that staging architecture is different in 2008R2 and 2012. So make sure you are following the guide for right version.

    Regards,

    Nagesh CL

    • Marked as answer by Elvis Long Thursday, April 18, 2013 2:38 AM
    Friday, April 12, 2013 1:07 PM