Farouk DawoodSenior Manager Data Architecture at a financial services firm
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The features that are most valuable are the governance, the end-profiling and the ETL which allows you to see the metadata repositories."
"There are not really many areas of the product that need improvement because the product stays up-to-date with data management needs."
"Technical support is very good."
"The most valuable feature is the administration console."
"It is very easy to deploy and provision a machine."
"What I like about Microsoft, is that it has a huge database with many users."
"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."
"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."
"It's very easy to use."
"One of the main features I have found useful is the integration with Azure active directory."
"We also want better cloud integration, so we could do things in the cloud if we needed to. This would be a good feature to add in a future release."
"The product is really only created for large organizations."
"The solution could be better integrated into Microsoft's other products."
"In the next version, I would like to see integration with Azure."
"Most of the Microsoft partners, especially digitally, are separate. Personnel are business people, and they do not have technical expertise, so you end up as a company spending a lot of money training your staff and your engineers."
"They do not offer the SQL Server Management tool via the installation. It is a separate tool I use when I'm trying to configure the mirroring with SQL Server Mirroring. This is not supported and I'm getting some errors on the database mirroring."
"The only drawback is that it does not have the matching, merging, and all true MDM components. For these, you have to use another competent called Data Quality Services (DQS). You need to plug it in and use it along with MDS for true MDM. Both of these are integrated together, but you have to do them separately, whereas, in Profisee, there are a couple of screens where you can configure the matching process, create matching rules, and other things, and everything is in one product, which is not the case with MDS. In order to implement a true MDM, you need MDS, DQS, and SSIS. You have to use MDS to store your golden records, DQS to configure and standardize all your rules and matching percentages, and SSIS to load the data to DQS and MDS. At the same time, you also need Melissa Data to clean up your addresses to validate and standardize the addresses. That's the main component of true MDM. It would be good if they can create a true matching component inside MDS and merge MDS and DQS."
"It would be a better option to have an on-cloud version."
"I do not like using Silverlight and Internet Explorer. The new 2019 version gets rid of that, which is one of the reasons why we are looking to switch."
"It may be costly for small organizations but adds value for large organizations with demanding workflows."
"The pricing of this solution is good."
"With Microsoft, we buy everything though an agreement, so we purchase volume licensing every year."
"I would like to see better pricing."
"MDS is a part of the SQL Server enterprise license. I am not aware of any additional costs."
"SAP is more expensive than Microsoft."
"The solution does require a license and we have enterprise licenses."
Earn 20 points
InfoSphere Master Data Management (MDM) is the most complete, proven and powerful MDM solution with collaborative and operational capabilities. InfoSphere MDM manages master data for single or multiple domains - customers, patients, citizens, suppliers, locations, products, services offerings, accounts and more - for improving application & business process effectiveness
Master Data Services (MDS) is the SQL Server solution for master data management. Master data management (MDM) describes the efforts made by an organization to discover and define non-transactional lists of data, with the goal of compiling maintainable master lists. An MDM project generally includes an evaluation and restructuring of internal business processes along with the implementation of MDM technology. The result of a successful MDM solution is reliable, centralized data that can be analyzed, resulting in better business decisions.
IBM InfoSphere MDM is ranked 6th in Master Data Management (MDM) Software with 2 reviews while Microsoft MDS is ranked 2nd in Master Data Management (MDM) Software with 9 reviews. IBM InfoSphere MDM is rated 8.0, while Microsoft MDS is rated 7.6. The top reviewer of IBM InfoSphere MDM writes "Data management for large organizations that need a critical data management tool". On the other hand, the top reviewer of Microsoft MDS writes "MDS 2016 - Primitive but the price is right". IBM InfoSphere MDM is most compared with Informatica MDM, SAP Master Data Governance, TIBCO EBX, IBM Master Data Management on Cloud and Informatica PIM, whereas Microsoft MDS is most compared with Informatica MDM, SAP Master Data Governance, Profisee, Reltio Cloud and TIBCO EBX. See our IBM InfoSphere MDM vs. Microsoft MDS report.
See our list of best Master Data Management (MDM) Software vendors.
We monitor all Master Data Management (MDM) Software reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.