We performed a comparison between Ataccama ONE Platform, Informatica PIM, 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 notable aspect lies in the workflow structure, where building the workflow aligns significantly with data governance."
"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 product’s important feature is data profiling and quality check."
"The ease of use of the user console is valuable."
"The drag-and-drop feature is incredibly flexible and straightforward."
"The most important features are the mastering of the data and the UI intuitiveness."
"The staging and hierarchical features are the most valuable."
"A great product enrichment tool."
"The best thing about it is that it comes with the Microsoft package."
"One of the main features I have found useful is the integration with Azure active directory."
"More generic related things can be included in the services."
"The tool is easy to use."
"The ease of use is valuable."
"Enables non-technical people to directly interact with the BI system."
"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 is very easy to deploy and provision a machine."
"There is a notable challenge in having to provide detailed filters before the site recognizes the search criteria."
"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."
"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."
"Data movement is a pain."
"It is complicated to fetch 20-25 reports when we profile the data."
"Database access is highly restricted particularly if you're using the cloud version."
"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."
"Microsoft MDS' language should be simple so everyone can use it easily."
"From my understanding, MS, as of 2021, will not maintain the product going forward."
"The stability could be improved."
"The Microsoft license cost could be lower."
"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."
"There are occasions when the solution maintains SD and we get duplications of MDS."
"Microsoft MDS isn't getting strong support because Microsoft is focusing more on cloud solutions."
"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."
Earn 20 points