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 activities, such as integration with DQS (will be covered in next chapter), are only possible with the Excel Add-in.

From an end user's perspective, the Excel Add-in is more comfortable. However, from the administration's point of view, the WebUI plays...