iBI

Master Data Services allows organizations to manage their master data in a centralized repository  with easy to use interfaces. The implementation of Master Data Services is part of an organization’s  Master Data Management (MDM) solution. An MDM solution involves business and  technology process alignment and is often managed by a data governance committee made  up of functional business stakeholders, subject matter experts and data stewards. MDS was designed with business users in mind. It allows non-technical users to create and  manage data models, entities, attributes, hierarchies, attribute collections and apply business  rules to the master data. Business users can use the intuitive web-based user interface or  through the MDS Excel add-in, which provides a more familiarized experience in Excel. MDS provides technical users the ability to programmatically create and manage master  data using backend database objects or through the Master Data Manager Web Service. For  e

The Master Data Services Configuration Manager can be used to do the initial setup and  configuration of the MDS database and web application. The MDS Configuration Manager can  be also used to upgrade the MDS database after a new SQL Server update has been installed  or to repair the MDS database in case of corruption or configuration mismatch after a database  has been restored from a backup. The Master Data Services Configuration Manager can also be used in migration scenarios,  for example, when the MDS database needs to be moved to a different SQL Server instance or  when to associate a different web application with an existing MDS database. In addition, the Master Data Services Configuration Manager is used to specify a series of  system settings related to database and web application services. The main settings and setting  categories include: General Settings Database connection time-out Database command time-out Web service time-out Client time-out Number

The installation of Master Data Services consists of three steps as follows: 1. Install required Windows roles and features 2. Install Master Data Services from the SQL Server installation media 3. Configure Master Data Services from the MDS Configuration Manager Windows roles and features installation To install the Windows roles and features required for MDS, you can use Windows Server Manager  or through a PowerShell script. To start the Windows roles and features installation using  Windows Server Manager follow these steps: 1. Open Server Manager and click on Manage on the menu bar, then click Add Roles and  Features from the drop-down menu options to launch the Add Roles and Features  Wizard. 2. On the Select installation type window, select the “Role-based or feature-based installation”  option as shown and click Next. 3. On the Select destination server window, click the checkbox for the “Select a server  from the server pool” optio