We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The most important features are the mastering of the data and the UI intuitiveness."
"The staging and hierarchical features are the most valuable."
"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."
"They need more feature flexibility, as it is not fully developed."
"Its look and feel needs improvement. It has a lousy look and feel. Informatica PIM is designed specifically for the retail industry. They need to make sure that it is also applicable to all the other industries and verticals."
"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."
"We switched to Informatica PIM because it was cheaper than the Oracle solution. It is cheaper initially, but they will bundle it later. This is what happens in the industry."
"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."
MDM – Product 360 is Informatica’s master data-fueled product information management (PIM) system. It allows business users to more effectively manage and collaborate on product content to fuel all sales channels with consistent, rich, and accurate product data for an informed and engaging customer experience. By delivering clean, consistent, and trusted product data, Product 360 empowers customer engagement and a company’s digital transformation by increasing speed, agility, and time to market.
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.
Informatica PIM is ranked 10th in Master Data Management with 2 reviews while Microsoft MDS is ranked 2nd in Master Data Management with 9 reviews. Informatica PIM is rated 6.6, while Microsoft MDS is rated 7.6. The top reviewer of Informatica PIM writes "It is scalable and comes with good staging and hierarchical features, but its look and feel needs improvement". On the other hand, the top reviewer of Microsoft MDS writes "MDS 2016 - Bit clunky but it works and the price is right and easy to get setup ". Informatica PIM is most compared with Informatica MDM, SAP Hybris PCM, Stibo STEP MDM, TIBCO EBX and ADAM Smart Content Hub, whereas Microsoft MDS is most compared with Informatica MDM, SAP Master Data Governance, Profisee and Reltio Cloud. See our Informatica PIM vs. Microsoft MDS report.
We monitor all Master Data Management 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.