Informatica Cloud Test Data Management vs Microsoft MDS comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
2,016 views|990 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Informatica Cloud Test Data Management and Microsoft MDS based on real PeerSpot user reviews.

Find out what your peers are saying about Delphix, Broadcom, DATPROF and others in Test Data Management.
To learn more, read our detailed Test Data Management Report (Updated: April 2024).
767,667 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 solution's scalability is high.""One of the most valuable features is that I don't need to buy a subscription for any functionality. With Informatica Cloud Data Management, I have all the functionality and features available. If I need to make an integration, I can go to that integration service. If I need to mask, provide, or clean some information, I can easily just pick up that feature and use it. It's very simple, and I have all the functions and capabilities I need to work with data."

More Informatica Cloud Test Data Management Pros →

"Technical support is very good.""Unlike specialized tools, MDS is adaptable for various industries, making it a versatile choice for master data management.""The best thing about it is that it comes with the Microsoft package.""The tool is easy to use.""The ease of use is valuable.""Enables non-technical people to directly interact with the BI system.""It's very easy to use.""The backup and restore functionality are the solution's most valuable aspects."

More Microsoft MDS Pros →

Cons
"One thing Informatica could improve is the way IPUs are used. Each customer purchases a certain amount of IPUs per month, but you can use more or less than that defined quantity. The only problem is if you don't use the all your IPUs, they don't carry over into the next month. I think customers should have the ability to transfer unused IPUs into the next month or year. This improvement could help give customers more flexibility, especially since cloud solutions need flexibility in how we use and pay for them.""Its cloud-based version has a few limitations compared to the on-premise version."

More Informatica Cloud Test Data Management Cons →

"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.""JMD repositories have records that come in thousands and millions, which takes a long time to process.""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.""Microsoft MDS' language should be simple so everyone can use it easily.""Microsoft MDS isn't getting strong support because Microsoft is focusing more on cloud solutions.""The solution could be better integrated into Microsoft's other products.""From my understanding, MS, as of 2021, will not maintain the product going forward.""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."

More Microsoft MDS Cons →

Pricing and Cost Advice
  • "You pay for this solution based on IPUs, Informatica Processing Units. This depends on how much data you process and how much memory you consume from the cloud provider, and you pay as you go."
  • More Informatica Cloud Test Data Management 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 Test Data Management solutions are best for your needs.
    767,667 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The solution's cloud-based version has a few limitations compared to its on-premise version.
    Top Answer:I advise others to know their company's requirements before implementing the solution. I rate it an eight out of ten.
    Top Answer:Unlike specialized tools, MDS is adaptable for various industries, making it a versatile choice for master data management.
    Top Answer:Microsoft MDS is cost-effective because it comes with SQL Server Enterprise Edition at no extra software cost. The main expenses are for deployment, but it saves money by reducing the need for custom… more »
    Top Answer:Microsoft MDS isn't getting strong support because Microsoft is focusing more on cloud solutions. Profisee initially made MDS, which Microsoft bought. Profisee now handles the cloud version. There are… more »
    Ranking
    10th
    Views
    15
    Comparisons
    4
    Reviews
    1
    Average Words per Review
    253
    Rating
    8.0
    Views
    2,016
    Comparisons
    990
    Reviews
    7
    Average Words per Review
    391
    Rating
    8.0
    Comparisons
    Also Known As
    Cloud MDM, Data Scout, Informatica Cloud Data Management
    Microsoft Master Data Services, Microsoft MDM, Microsoft SQL Server Master Data Services, MS MDS
    Learn More
    Overview
    Information Not Available

    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
    Information Not Available
    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
    No Data Available
    REVIEWERS
    Non Profit17%
    Manufacturing Company17%
    Retailer8%
    Government8%
    VISITORS READING REVIEWS
    Computer Software Company15%
    Financial Services Firm10%
    Manufacturing Company9%
    Government7%
    Company Size
    No Data Available
    REVIEWERS
    Small Business40%
    Midsize Enterprise10%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise15%
    Large Enterprise69%
    Buyer's Guide
    Test Data Management
    April 2024
    Find out what your peers are saying about Delphix, Broadcom, DATPROF and others in Test Data Management. Updated: April 2024.
    767,667 professionals have used our research since 2012.

    Informatica Cloud Test Data Management is ranked 10th in Test Data Management with 2 reviews while Microsoft MDS is ranked 2nd in Master Data Management (MDM) Software with 18 reviews. Informatica Cloud Test Data Management is rated 8.6, while Microsoft MDS is rated 7.6. The top reviewer of Informatica Cloud Test Data Management writes "Has good stability and an easy initial setup process". On the other hand, the top reviewer of Microsoft MDS writes "Useful Excel plug-in, good scalability, and good integration with SQL Server and other Microsoft products". Informatica Cloud Test Data Management is most compared with , whereas Microsoft MDS is most compared with Informatica MDM, Profisee, SAP Master Data Governance, TIBCO EBX and Reltio Cloud.

    We monitor all Test 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.