Comparing WebUI with the Excel Add-in

There are two editors for MDS: WebUI and Excel Add-in. When you install and configure Master Data Services, the WebUI will be configured and ready to use (you've seen how to configure MDS and WebUI in the previous example). The Excel Add-in needs to be installed separately from the newly generated WebUI link.

Both WebUI and the Excel Add-in have the ability to do many of the basic tasks in MDS, such as creating and inserting values in entities, browsing entity values, editing values, and other tasks. However, some tasks are only available in one of these editors; for example, permissions can be configured only from the WebUI, and hierarchies can be edited and viewed only in the WebUI. On the other hand, some ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.