Ataccama ONE Platform vs Informatica PIM vs Microsoft MDS comparison

Cancel
You must select at least 2 products to compare!
Ataccama Logo
228 views|167 comparisons
100% willing to recommend
Informatica Logo
57 views|49 comparisons
85% willing to recommend
Microsoft Logo
1,944 views|965 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary

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.
To learn more, read our detailed Data Quality Report (Updated: April 2024).
770,292 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The ease of use of the user console is valuable.""The notable aspect lies in the workflow structure, where building the workflow aligns significantly with data governance.""The drag-and-drop feature is incredibly flexible and straightforward.""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."

More Ataccama ONE Platform Pros →

"A great product enrichment tool.""The most important features are the mastering of the data and the UI intuitiveness.""The staging and hierarchical features are the most valuable."

More Informatica PIM Pros →

"The solution is easy to install.""It is very easy to deploy and provision a machine.""The most valuable feature of Microsoft MDS is its management.""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.""The best thing about it is that it comes with the Microsoft package.""The most valuable feature is the administration console.""Unlike specialized tools, MDS is adaptable for various industries, making it a versatile choice for master data management.""It's very easy to use."

More Microsoft MDS Pros →

Cons
"There is a notable challenge in having to provide detailed filters before the site recognizes the search criteria.""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.""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."

More Ataccama ONE Platform Cons →

"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.""Database access is highly restricted particularly if you're using the cloud version."

More Informatica PIM Cons →

"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.""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.""It would be a better option to have an on-cloud version.""Microsoft MDS' language should be simple so everyone can use it easily.""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.""The stability could be improved.""The Microsoft license cost could be lower."

More Microsoft MDS Cons →

Pricing and Cost Advice
  • "The product is reasonably priced."
  • "Despite not being extremely low-cost, the pricing appears reasonable, making it a profitable and viable choice for companies that prioritize data security and adhere to specific policies."
  • "Our licensing model wasn't user-specific; instead, we paid fees for the engine and maintenance. As we didn't have a support contract, maintenance fees were likely nonexistent. Regarding the upgrade, we had an account for the initial two or three years, and considering the features provided by the solution, the pricing was reasonable."
  • More Ataccama ONE Platform Pricing and Cost Advice →

  • "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."
  • More Informatica PIM Pricing and Cost Advice →

  • "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."
  • "Microsoft MDS is an expensive solution."
  • More Microsoft MDS Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Quality solutions are best for your needs.
    770,292 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Here are some thoughts on how to fill the gaps in Ataccama's Metadata Management capabilities, as reported by others… more »
    Top Answer:The notable aspect lies in the workflow structure, where building the workflow aligns significantly with data… more »
    Top Answer:The focus for future improvements lies in strengthening the handling of unstructured data. This entails adapting to new… more »
    Ask a question

    Earn 20 points

    Top Answer:Unlike specialized tools, MDS is adaptable for various industries, making it a versatile choice for master data… more »
    Top Answer:Microsoft MDS is cost-effective because it comes with SQL Server Enterprise Edition at no extra software cost. The main… more »
    Top Answer:Microsoft MDS isn't getting strong support because Microsoft is focusing more on cloud solutions. Profisee initially… more »
    Ranking
    8th
    out of 56 in Data Quality
    Views
    228
    Comparisons
    167
    Reviews
    5
    Average Words per Review
    535
    Rating
    7.8
    Views
    57
    Comparisons
    49
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    Views
    1,944
    Comparisons
    965
    Reviews
    7
    Average Words per Review
    391
    Rating
    8.0
    Comparisons
    Also Known As
    PIM, Product 360, Heiler
    Microsoft Master Data Services, Microsoft MDM, Microsoft SQL Server Master Data Services, MS MDS
    Learn More
    Overview

    Ataccama ONE Platform is a comprehensive data management and governance solution designed to address the challenges faced by organizations in managing and leveraging their data assets. Its primary use case is to enable organizations to gain control over their data, improve data quality, and ensure compliance with data regulations.

    The most valuable functionality of Ataccama ONE includes data profiling, data quality management, data integration, master data management, and metadata management. These features allow organizations to understand the quality and structure of their data, integrate data from various sources, create a single view of their master data, and manage metadata to ensure data lineage and governance.

    By leveraging Ataccama ONE, organizations can achieve several benefits. Firstly, it helps in improving data quality by identifying and resolving data issues, ensuring accurate and reliable data for decision-making. Secondly, it enables organizations to streamline data integration processes, reducing the time and effort required for data integration projects. Thirdly, it facilitates effective master data management, enabling organizations to have a consistent and accurate view of their critical data entities. Lastly, it helps organizations in complying with data regulations by providing data lineage, data privacy, and data governance capabilities.

    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.

    Microsoft Master Data Services (MDS) is an SQL server solution for master data. MDS enables users to organize and manage a business's master set of data into models while also creating rules for updating the data and control over who can edit it. In addition, the master dataset can be shared with other people in your organization through Excel.

    In Master Data Services, you create a model, which is the highest level container in the structure of your master data. This model can then be used to group similar data. Within the model, there can be one or more entities that are similar to a table. Those entities contain members that are the data records. For example, your model can include commodities such as style, color, and product if you manage online product data. The color entity may contain members for various colors. Models may also have attributes that contain values that describe entity members and can be defined within the entities.

    There are also attributes that contain values that help describe entities within entity members. There are two different types of attributes:

    • Free-form attributes - include numbers, dates, text, or files.
    • Domain-based attributes - includes values that can be used as attribute values for other entities.

    Features of Microsoft MDS

    Microsoft MDS offers a variety of features that provide a central management of master data, while accommodating access to editors and other consumers of the information. These features include:

    • Data Validation: With a proactive monitoring process in Business Rules, users can ensure data validity before the lists are used.

    • Domain Agnostic: Any data type or data schema can be supported by the MDS system.

    • Security: Without risking unauthorized changes, IT teams are empowered to control access at the attribute, entity, and record levels.

    • Web-based UI: There is no need to install software, as the web-based user interface gives access to a vast user base.

    • Versioning: Each model in MDS can be versioned, allowing for users to tab particular versions for subscribing systems.

    • Hierarchy Management: MDS offers functional and versatile management of business hierarchies with various hierarchy types and specialized controls.

    • Transaction Logging: MDS offers a transaction log to keep track of changes, as well as the ability to explain why changes were made.

    Reviews from Real Users

    For those managing large quantities of master data, Microsoft MDS is a solution of choice for a number of reasons. Two of those are its ability to empower everyone to interact with the BI system as well as its integration with Azure active directory.

    Satyam S., a senior software developer at a manufacturing company, notes, "Enables non-technical people to directly interact with the BI system."

    An individual contributor at a pharma/biotech company writes, "One of the main features I have found useful is the integration with Azure active directory."

    Sample Customers
    Société Générale, First Data, Raiffeisenbank International, T-Mobile, Avast, RSA, Toronto Public Library
    Puma, Saint Gobain, Unilever
    ETA a.s., Apeejay Surrendra Group, Blue Star Infotech, Rotherham Doncaster and South Humber NHS Foundation, The Sydney Children's Hospitals Network, New Belgium Brewing
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Computer Software Company12%
    Insurance Company9%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Manufacturing Company17%
    Computer Software Company14%
    Retailer12%
    Financial Services Firm6%
    REVIEWERS
    Non Profit17%
    Manufacturing Company17%
    Retailer8%
    Government8%
    VISITORS READING REVIEWS
    Computer Software Company15%
    Financial Services Firm10%
    Manufacturing Company9%
    Healthcare Company7%
    Company Size
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise71%
    REVIEWERS
    Midsize Enterprise29%
    Large Enterprise71%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise12%
    Large Enterprise69%
    REVIEWERS
    Small Business40%
    Midsize Enterprise10%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise15%
    Large Enterprise69%
    Buyer's Guide
    Data Quality
    April 2024
    Find out what your peers are saying about Informatica, SAP, Talend and others in Data Quality. Updated: April 2024.
    770,292 professionals have used our research since 2012.