Sr. Database Developer at Hill Physicians Medical Group
Real User
Mar 4, 2021
It has a very good feature called Excel plug-in. You just have to install the plug-in, and then it directly connects to the MDS instance where you can maintain and manage your data and publish it right through Excel. You don't need to go to the front end to make any changes.
It has easy integration with SQL Server, and you can use SSIS to do the ETLs. It is a part of the Microsoft stack. It works with most of the Microsoft stuff.
Its availability for a secured server is one of its most valuable features. Also its replications - we can manage eight replicas. Their clustering and availability groups are also valuable.
Microsoft Master Data Services (MDS) is an SQL server solution for master data. MDS enables users to organize and manage a business's master set of data into models while also creating rules for updating the data and control over who can edit it. In addition, the master dataset can be shared with other people in your organization through Excel.
In Master Data Services, you create a model, which is the highest level container in the structure of your master data. This model can then be used...
More generic related things can be included in the services.
Unlike specialized tools, MDS is adaptable for various industries, making it a versatile choice for master data management.
The tool is easy to use.
The best thing about it is that it comes with the Microsoft package.
The ease of use is valuable.
The most valuable feature of Microsoft MDS is its management.
The backup and restore functionality are the solution's most valuable aspects.
Enables non-technical people to directly interact with the BI system.
One of the main features I have found useful is the integration with Azure active directory.
It's very easy to use.
It has a very good feature called Excel plug-in. You just have to install the plug-in, and then it directly connects to the MDS instance where you can maintain and manage your data and publish it right through Excel. You don't need to go to the front end to make any changes.
It has easy integration with SQL Server, and you can use SSIS to do the ETLs. It is a part of the Microsoft stack. It works with most of the Microsoft stuff.
Its availability for a secured server is one of its most valuable features. Also its replications - we can manage eight replicas. Their clustering and availability groups are also valuable.
What I like about Microsoft, is that it has a huge database with many users.
It is very easy to deploy and provision a machine.
The most valuable feature is the administration console.
Technical support is very good.