We performed a comparison between Ataccama ONE Platform, Informatica MDM, and Microsoft MDS based on real PeerSpot user reviews.
Find out what your peers are saying about Informatica, SAP, Talend and others in Data Quality."The ease of use of the user console is valuable."
"The drag-and-drop feature is incredibly flexible and straightforward."
"The product’s important feature is data profiling and quality check."
"The desktop version of the solution was particularly valuable to me, primarily for creating components. We opted for the data quality aspect to assess the quality of our data warehouse. The functionalities available allowed us to not only check data quality but also serve as an ETL tool. This versatility enabled data transformation and storage in various formats, including files on platforms like SharePoint or local online directories. The flexibility of the tool catered to the specific needs of those building components, contributing to our desired outcomes."
"The notable aspect lies in the workflow structure, where building the workflow aligns significantly with data governance."
"We can see all our information on a single screen."
"The most valuable features of Informatica MDM are its reliability, match functions, and integration capabilities. The out-of-box functionality of deduplication and built-in data models ensure faster implementation."
"Address Doctor gives an accurate combination of information provided with a level of returned threshold value."
"The scalability of the solution is excellent."
"The fuzzy matching capability is a great feature."
"It has been leading the market with hierarchy management and all the different match concepts and algorithms. They're very robust."
"Informatica MDM has data quality, mastering the data's capability."
"MDM is very stable - it can handle millions of hits daily and still run 24/7."
"What I like about Microsoft, is that it has a huge database with many users."
"The ease of use is valuable."
"Technical support is very good."
"The tool is 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."
"It's very easy to use."
"The backup and restore functionality are the solution's most valuable aspects."
"It is very easy to deploy and provision a machine."
"Speaking specifically about the version we use, version 12.3, I'm unsure if this has been addressed in subsequent versions. One improvement I'd like to see pertains to the language used in certain components, especially in data quality checks. The language complexity posed a challenge for beginners. Although we had on-site assistance from Ataccama, making it manageable for us, some individuals found it difficult to comprehend, necessitating additional support. The provision of a comprehensive guide for on-premise installation can also be enhanced. The lack of detailed information on the solution's workings and the overwhelming nature of notifications, with extensive content, were areas of concern. Streamlining the notification content in newer versions would significantly expedite issue resolution."
"Data movement is a pain."
"It is complicated to fetch 20-25 reports when we profile the data."
"I believe it would be beneficial if it could enhance its flexibility to connect with a wider range of downstream systems beyond just Excel and Postgres."
"There is a notable challenge in having to provide detailed filters before the site recognizes the search criteria."
"Informatica MDM has a complex user interface, which could be improved."
"Their support should be improved. We have had some trouble with their support from time to time. Its scalability should also be improved. I would also like to have a bit more modern and friendly UI for the end-users. There should definitely be a simplified way to configure and set it up."
"We currently have issues with real-time integration."
"The integration could be a bit better. The process is something new."
"Informatica MDM could be improved by adding drag and drop options, business data insights, and visualization reporting."
"I think everything related to the APIs and the manageability of the APIs in Informatica MDM are areas where improvements are required."
"New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market."
"This is a costly solution. We have several customers who evaluate it but then look for other solutions because of the cost. At present, Informatica MDM comes as an on-premises or cloud-based solution. I would like to see them offer a SaaS-based MDM model. I think they are working on it."
"Microsoft MDS isn't getting strong support because Microsoft is focusing more on cloud solutions."
"The stability could be improved."
"From my understanding, MS, as of 2021, will not maintain the product going forward."
"There are occasions when the solution maintains SD and we get duplications of MDS."
"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."
"JMD repositories have records that come in thousands and millions, which takes a long time to process."
"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."
"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."