IT Central Station is now PeerSpot: Here's why

Microsoft MDS Valuable Features

GaryM - PeerSpot reviewer
Data Architect at World Vision
  • Ease of use
  • Excel interface
  • Simplicity
  • Soft delete support
  • Sophistication of business rules
  • Price (FREE for sql server enterprise license)
  • Hierarchy management 
  • Security integration with AD
  • Very fine grained security
  • Easy to build (and extendable) business rules
  • Automatic Notification
  • Versioning
  • Integrated boolean business rules
  • Change detection
  • Integrated workflow
  • Staging support
  • Publication support
  • Ability to propagate from one repository to another
  • Ability to share reference data across models
  • Integrates as a web part
  • Flexibility
  • Includes both batch staging process and Excel data loading
  • Unused area of hierarchies to easily identify members not assigned
View full review »
Suman Jupudi - PeerSpot reviewer
Sr. Database Developer at Hill Physicians Medical Group

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.

View full review »
Satyam Saxena - PeerSpot reviewer
Senior Software Developer at a manufacturing company with 5,001-10,000 employees

The most valuable feature of the solution is Excel because it enables even non-technical people to directly interact with the BI system which is important because most of our people are not from the IT sector. The second important feature is that while we are using Informatica and other SAP tools which are less customizable, MDS increases customization for us and that is very useful. MDS, SQL and SSIS make the solution much more powerful. The main reason we use this solution is because of its customization. 

View full review »
Buyer's Guide
Microsoft MDS
June 2022
Learn what your peers think about Microsoft MDS. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
607,332 professionals have used our research since 2012.
Ariful Mondal - PeerSpot reviewer
Consulting Practice Partner - Data, Analytics & AI at FH

It gives you the flexibility to have in-depth experience. It allows you to collect data and save it as a golden record. You have the flexibility for data stewardship.

They also have an Excel API where you can do everything from Excel. You can make changes with the connectivity on the Excel API.

It's very easy to use.

View full review »
MT
Individual Contributor at a pharma/biotech company with 1,001-5,000 employees

One of the main features I have found useful is the integration with Azure active directory.

View full review »
Buyer's Guide
Microsoft MDS
June 2022
Learn what your peers think about Microsoft MDS. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
607,332 professionals have used our research since 2012.