Azure Cosmos DB vs Informatica MDM

Likelihood to Recommend

Cosmos DB is fast, reliable, and highly available. We use it mostly in analytics and applications that leverage big data hosted on the Azure Datacenter. If you have a virtual private cloud in one of Azure sites, then you would definitely need Cosmos. It works well with on-premises applications and offers little to no latency.

Read full review

Verified User

Project Manager in Information Technology

Pharmaceuticals Company, 10,001+ employees

View all 5 answers on this topic

If your environment is clean and well organized, but at the same time has many application domains with their own data sources, Informatica MDM can be a really good factor in maintaining "single points of truth" for all this data. However, the more application domains you have, the less "clean" your environment becomes. If your application domain landscape consists of multiple technologies (C#, Oracle, JAVA, web-based, windows services, console apps, third-party tools, etc), your environment becomes a real nightmare to maintain unless you implement a service-oriented approach. And this is where Informatica MDM fails completely since it promotes a "point to point" scenario. At least this is my experience. It could be that Informatica MDM supports a service-oriented approach, but I have not seen this. I could be that the developers in my organization who have expert Informatica MDM knowledge are just more "point to point" oriented. But even if that is the case, it's a valid argument against Informatica MDM, since it's already hard enough to find developers who are dedicated to this product, it becomes impossible to find SOA oriented developers.

Read full review

Verified User

Employee in Information Technology

Consumer Services Company, 501-1000 employees

View all 3 answers on this topic

Feature Rating Comparison

Azure Cosmos DB

Informatica MDM

Performance

Availability

Concurrency

Security

Scalability

Data model flexibility

Deployment model flexibility

Pros

Injects unstructured data at a very high speed.
No real need for administrative work, it indexes everything on it's own.

Read full review

Verified User

Employee in Information Technology

Financial Services Company, 1001-5000 employees

View all 5 answers on this topic

Gather data.
Manage data.
Present data to the user.
Correlate data.
Data manipulation.

Read full review

Verified User

Director in Information Technology

Financial Services Company, 10,001+ employees

View all 3 answers on this topic

Cons

Cosmos DB can be very expensive if you're using it for scenarios that are better completed in regular old Azure Table Storage or Blob Storage, specifically if you put some thought into your partitioning schemes. No product is a good substitute for thoughtful system design.
It would be helpful if I had some more insight into how many resources (DTUs) an individual query uses.
The auto-indexing is great, but a little mysterious -- not usually an issue but it does require some intentional thought.

Read full review

Lars Kemmann

Solutions Architect

Netrix, LLCInformation Technology and Services, 201-500 employees

View all 5 answers on this topic

Mapping within the tool can be difficult. But that is slated for upgrade with the next version.
Many detailed screens for the developer interface. This makes it hard to find options sometimes.
Address validation sometimes leads to incorrect results. This is my biggest issue with the product.

Read full review

Brian Randolph

Data Integration Data Quality Specialist

CARFAXInformation Services, 501-1000 employees

View all 3 answers on this topic

Likelihood to Renew

Azure Cosmos DB 7.9

Based on 4 answers

The total cost of ownership is much higher than anticipated. The documentation for their API calls is still not complete. TCO did go up as a result as well. Having users learning another JQL-like language also added more complexity to it. Support of ANSI-SQL would be ideal. But the cost of managing it is much less compared to Redis, Mongo, or Cassandra.

Read full review

Verified User

Engineer in Engineering

Biotechnology Company, 11-50 employees

View all 4 answers on this topic

No score

No answers yet

No answers on this topic

Usability

Azure Cosmos DB 8.0

Based on 1 answer

Like I said, Cosmos is the way to go. From all of the services that Azure has, Cosmos is very robust in terms of usability. It's ever-evolving and integrates with other applications seamlessly. The interface is pretty easy to understand. I implemented various solutions for my company and Cosmos was one of them.

Read full review

Verified User

Project Manager in Information Technology

Pharmaceuticals Company, 10,001+ employees

View all 1 answers on this topic

No score

No answers yet

No answers on this topic

Support Rating

Azure Cosmos DB 10.0

Based on 1 answer

Microsoft is the best when it comes to after-sales support. They have a well-structured training and knowledge base portal that anyone can use. They are usually quick to respond to cases and are on point for on-call support. I have no complaints from a support standpoint. Pretty happy with the support.

Read full review

Verified User

Project Manager in Information Technology

Pharmaceuticals Company, 10,001+ employees

View all 1 answers on this topic

Informatica MDM 8.0

Based on 1 answer

I'm not sure since I never used support. My colleagues never had any issues with it, therefore my rating would be an 8 with a certain range of uncertainty.

Read full review

Verified User

Employee in Information Technology

Consumer Services Company, 501-1000 employees

View all 1 answers on this topic

Alternatives Considered

Azure Cosmos DB is a fully managed NoSQL database & globally distributed NoSQL database service. Its very fast and predictable performance, high availability, elastic scaling, global distribution, and ease of development DB platform compare to MongoDB.

Read full review

Verified User

Engineer in Engineering

Computer Software Company, 1001-5000 employees

View all 5 answers on this topic

Less expensive then the competitors, modules are self-sustained and able to function directly. It involves less coding, and a lot of things can be done in house!

Read full review

Verified User

Director in Information Technology

Financial Services Company, 10,001+ employees

View all 3 answers on this topic

Return on Investment

Azure Cosmos DB may be expensive on its own, but it was cheaper than increasing the size/power of our VMs running SQL Server instances enough to keep up with the volume and velocity of the unstructured data.
We got the JSON data out of our SQL Servers and they quit tipping over.

Read full review

Verified User

Employee in Information Technology

Financial Services Company, 1001-5000 employees

View all 5 answers on this topic

Informatica MDM allowed for a faster standup of our Salesforce environment.
Informatica MDM provided a means to keep our multiple source systems synchronized.
Informatica MDM can be pricey but is definitely a leader in the space.

Read full review

Brian Randolph

Data Integration Data Quality Specialist

CARFAXInformation Services, 501-1000 employees

View all 3 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Rating Summary

Azure Cosmos DB

Informatica MDM

Azure Cosmos DB

Informatica MDM

Azure Cosmos DB

Informatica MDM

Azure Cosmos DB

Informatica MDM

Azure Cosmos DB vs Informatica MDM

Azure Cosmos DB

Informatica MDM

Feature Rating Comparison

NoSQL Databases

Performance

Availability

Concurrency

Security

Scalability

Data model flexibility

Deployment model flexibility

Pros

Cons

Likelihood to Renew

Usability

Support Rating

Alternatives Considered

Return on Investment

Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Rating Summary

Likelihood to Recommend

Likelihood to Renew

Usability

Support Rating

Add comparison