Try our new research platform with insights from 80,000+ expert users
Aasif Bagdadi - PeerSpot reviewer
CTO at MarketOnce
Real User
Offers horizontal scalability, making it easy and cost-effective without additional effort from a DBA or DevOps team
Pros and Cons
  • "The fact that scalability can be achieved by simply configuring availability zones is very attractive."
  • "An improvement could include increasing the document size or providing a method to manage larger sets efficiently. If they want to keep a 2 MB limit, they should provide a way to chain multiple documents in a systematic way so that developers do not have to figure out what to do when a document is larger than 2 MB."
  • "A limitation in Azure Cosmos DB is the 2 MB document size. Developers need more systemic support in chaining multiple documents if more than 2 MB is required."

What is our primary use case?

I have three different products using Azure Cosmos DB. The most extensive use is in a survey platform we are developing as a SaaS product. Azure Cosmos DB serves as the primary OLTP database for this platform. We do not have any other RDBMS for this use case.

We also use it to store configuration information for campaigns for the other two products, but it is used extensively for the survey platform.

How has it helped my organization?

Azure Cosmos DB offers horizontal scalability, making it easy and cost-effective without additional effort from a DBA or DevOps team. Configuration for scaling is user-friendly through the UI.

It is easy to use and optimize once you understand the basics, partitions, and indexing. By default, it indexes every field and attribute, but you can customize it. The documentation is good. It makes logical sense. I have had some experience with other NoSQL solutions. It is easy to use. We do not find anything challenging. The way it indexes and does the filtering of data is easy.

What is most valuable?

The fact that scalability can be achieved by simply configuring availability zones is very attractive. We aimed to avoid managing a NoSQL database, especially when we did not have an upper limit on how much audio we would need while doing the initial development. The ability to easily scale with the increase in usage and adoption of our product is the most valued feature.

What needs improvement?

A limitation in Azure Cosmos DB is the 2 MB document size. Developers need more systemic support in chaining multiple documents if more than 2 MB is required. Compared to competitors like MongoDB, which allows for gigabyte-sized documents, Azure Cosmos DB's limit is small. An improvement could include increasing the document size or providing a method to manage larger sets efficiently. If they want to keep a 2 MB limit, they should provide a way to chain multiple documents in a systematic way so that developers do not have to figure out what to do when a document is larger than 2 MB. For some use cases, the 2 MB size is very small. If they improve this aspect, a lot of customers will benefit from it. 

Another area for improvement is making it available on different cloud providers. Currently, Azure Cosmos DB is an Azure-only offering. Not supporting other cloud providers results in Microsoft losing some customers.

Buyer's Guide
Microsoft Azure Cosmos DB
January 2025
Learn what your peers think about Microsoft Azure Cosmos DB. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,615 professionals have used our research since 2012.

For how long have I used the solution?

I have been using Azure Cosmos DB extensively for the last four years. Before that, it was more of hobby research.

How are customer service and support?

We have an account manager. We reach out to that account manager wherever we need level 2 or level 3 support. We have also followed the normal process of raising a ticket, but sometimes, it helps to speed up the process.

Ordinary issues are resolved through standard processes, but for complex matters, we leverage our account manager to access senior engineers. We have received great support. Support has been responsive and effective. I am very happy with their support.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

We have not replaced any solution with Azure Cosmos DB for this use case, but we have used MongoDB, Elastic, and other NoSQL databases.

Almost anything that you can do in Azure Cosmos DB can also be done in MongoDB, but one of the things that I like about Azure Cosmos DB is called change detection. Changes in each document can be persisted in some other technologies. It could be in fabric or SQL Server. This feature gives Azure Cosmos DB an edge over others in use cases where you need to detect a change and then connect it with other things. I also like the functions and stored procedures that Microsoft has implemented in Azure Cosmos DB, but the change detection feature is probably one of the best features. It works natively within the platform and Azure.

How was the initial setup?

The initial setup is very easy and seamless. An instance can be deployed in minutes, and the UI allows for easy configuration and scaling without disrupting operations.

I recently needed to upgrade an Azure Cosmos DB instance. In the UI, I clicked the option to scale it higher. It said that it could take a couple of hours. I thought it would take four or five hours, but it finished in two or three hours and notified me when the upgrade was completed. All this while, things were working and operational, and behind the scenes, it was upgrading to a bigger instance. It finished the upgrade in half the time. It can spin up a small instance in just a few minutes.

It took us about two weeks to do the PoC to make sure that Azure Cosmos DB was the right one for our use case. After the PoC, we started leveraging Azure Cosmos DB within a month. Our use cases have become more and more sophisticated because we are still developing software, which requires us to create different documents and different structures of those documents in Azure Cosmos DB. The onboarding itself was simple and natural. We did not feel that using Azure Cosmos DB slowed us. In fact, it was seamless because the JSON that our APIs needed could directly be persisted in Azure Cosmos DB. No other transformation was needed.

Its learning curve is small. It is easy to learn. The documentation of Azure Cosmos DB is good.

It does not require any maintenance, but a couple of times, we had to change our partition scheme and write a separate utility to transition from one partition scheme to the other. It was more of a migration that we had to do of the Azure Cosmos DB document that we had created. Because we changed the partitioning scheme, we had to migrate the old data to the new partition design. Azure Cosmos DB does not require any maintenance work. That is the beauty of how NoSQL, and Azure Cosmos DB in particular, have been designed.

What about the implementation team?

All implementations were done in-house without any external consultants. It is a one-person job.

What was our ROI?

The horizontal scalability helps lower the overall cost of ownership as compared to managing MongoDB or any RDBMS solution. Because of its ease of use and the fact that the scaling, configuration, and backup are managed in Azure, we do not need a dedicated DBA. We do not even need the DevOps people to manage it.

The management of Azure Cosmos DB is easy because of the UI and the way it scales. We have availability zones and multi-region load balancing. When you take all that into consideration, the total cost of ownership is much lower than others.

Azure Cosmos DB is costly, especially if you have not optimized it. However, we are very satisfied with it. It provides the value for what we are paying.

What's my experience with pricing, setup cost, and licensing?

Its price is very good for the basic stuff. When you go to a more complicated use case, especially when you need replication and availability zones, it gets a little costly.

It represents the biggest cost item for us. However, the cost is aligned with the value provided. It has served our needs perfectly, aligning with our scaling and development requirements, so the cost of ownership seems justified.

Which other solutions did I evaluate?

We did a number of PoCs to decide which NoSQL database to use, and we settled on Azure Cosmos DB. We could see its benefits when we incorporated the partition key with indexing. The performance started improving when our engineers started exploring some of the complex concepts.

What other advice do I have?

Overall, I would rate Azure Cosmos DB an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
PeerSpot user
Tiago Duarte - PeerSpot reviewer
CTO at Stellium Consulting
Real User
Top 10
You can scale it to add more capacity while providing the level of performance that customers expect
Pros and Cons
  • "We value the replication and regional availability features that Cosmos DB provides. The replication includes read replicas and write replicas. The recent addition of vectorization and similarity comparisons add values for AI workloads. The performance and scaling capabilities of Cosmos DB are excellent, allowing it to handle large workloads compared to other services such as Azure AI Search."
  • "Cosmos DB performs exceptionally well and has not caused any issues that necessitate adjustments in nodes for improved performance."
  • "A minor improvement would be enabling batch operations through the UI. Currently, to delete all documents in a collection, we must use an API, which some of my team finds inconvenient for admin tasks."

What is our primary use case?

We have been using Cosmos DB for everything involving non-relational data. Recently, we’ve been utilizing it more for AI purposes, especially for conversation histories.

How has it helped my organization?

Cosmos DB performs well with production workloads that have many gigabytes of information. You can scale it to add more capacity while providing the level of performance that customers expect.

What is most valuable?

We value the replication and regional availability features that Cosmos DB provides. The replication includes read replicas and write replicas. The recent addition of vectorization and similarity comparisons add values for AI workloads. The performance and scaling capabilities of Cosmos DB are excellent, allowing it to handle large workloads compared to other services such as Azure AI Search.

The solution is straightforward in terms of the interface, API set, and automation capabilities. The learning curve is short if you're familiar with the world of non-relational data. It takes about three to six months to learn about the distribution capabilities of Cosmos as a service. It takes a bit more time to learn the networking settings that you can use for Cosmos in South Asia, including virtual networks, private networks, finance, etc.

The vector database is interesting. We haven't used it before. We were using Azure AI search for that, but we've had great conversations with the product team, and we realize that a couple of workloads are more appropriate for Cosmos. The search results quality is still determined by Azure AI search, and we haven't used vector databases in production workloads. However, from what we've seen from a hands-on demo, it can help.

What needs improvement?

A minor improvement would be enabling batch operations through the UI. Currently, to delete all documents in a collection, we must use an API, which some of my team finds inconvenient for admin tasks.

For how long have I used the solution?

We have been using Cosmos DB for six years.

What do I think about the stability of the solution?

Cosmos DB performs exceptionally well and has not caused any issues that necessitate adjustments in nodes for improved performance.

What do I think about the scalability of the solution?

The solution scales exceptionally well. Partitioning, indexation for collections, and the dynamic scaling feature allow us to manage performance and costs effectively. We like that it can auto-scale to demand, ensuring we only pay for what we use.

Which solution did I use previously and why did I switch?

Before Cosmos DB, we used Python for non-relational data. However, choosing Cosmos was straightforward due to our focus on leveraging Microsoft services.

How was the initial setup?

For our migration, we had to integrate both products. The source had its own interface and APIs. In terms of syncing data, we had to incorporate it directly with Cosmos. Cosmos has excellent APIs and operation services. It was easy to orchestrate migration from one data center system to the other.

The challenges were more related to network performance than anything else. We had to build our migration very close to the Microsoft network. We were working with higher network latency by doing it inside a VM on Azure.

What about the implementation team?

Our team built a migration orchestration integrating both the source and Cosmos systems using APIs.

What was our ROI?

Since starting with Cosmos DB, we have seen an overall reduction in our total ownership cost of 5 to 10 percent.

What's my experience with pricing, setup cost, and licensing?

Everything could always be cheaper. I like that Cosmos DB allows us to auto-scale instead of pre-provisioning a certain capacity. It automatically scales to the demand, so we only pay for what we consume.

What other advice do I have?

I rate Cosmos DB nine out of 10.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
PeerSpot user
Buyer's Guide
Microsoft Azure Cosmos DB
January 2025
Learn what your peers think about Microsoft Azure Cosmos DB. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,615 professionals have used our research since 2012.
Christian Gomez Rua - PeerSpot reviewer
IT Data Architect & Manager at Ternium Mexico S.A. de C.V.
Real User
Top 10
It has improved efficiency and response times, but the interoperability with some solutions could be better
Pros and Cons
  • "Microsoft Azure Cosmos DB has helped to improve efficiency, providing good response times and allowing the storage of AI process results, which is crucial for feedback loops."
  • "Microsoft Azure Cosmos DB offers the response times needed for advanced analytics applications."
  • "The integration with other solutions needs to improve because Cosmos DB's interoperability is lacking in some scenarios. For example, I'm currently implementing Fabric. That involves migrating from environments without apps, processing data and users, and taking them to Fabric."
  • "Cosmos DB is expensive, and the RU-based pricing model is confusing."

What is our primary use case?

The primary use case is focused on advanced analytics. We use Microsoft Azure Cosmos DB for storing results from OpenAI models, acting as a temporary information repository for APIs, and for log systems. We also experiment with its Vector Search capability.

How has it helped my organization?

Microsoft Azure Cosmos DB has helped to improve efficiency, providing good response times and allowing the storage of AI process results, which is crucial for feedback loops. 

The tool makes it easier for us to store data in a database. Our company is a Microsoft shop using Azure, and our big data ecosystems are oriented to solve needs in the Azure architecture. We are looking at maintaining the tools within the same ecosystem without breaking the whole scenario of the solutions we have to set up. Cosmos DB helps us do those types of operations. 

The performance is so good it creates an ecosystem that allows data scientists to develop applications without clashing too much or losing the security and governance over the information.

What is most valuable?

Microsoft Azure Cosmos DB offers the response times needed for advanced analytics applications. It supports multiple use cases, including storage of AI model results and temporary information repositories. 

Performance and security are valuable features, particularly when using Cosmos DB for MongoDB emulation and NoSQL. The platform's ability to efficiently tokenize AI models for later consumption is also a benefit.

Within the layer, we're using it with OpenAI. That is the main one. If we use document intelligence from the entire database layer,  it is where we have our developments deployed on Kubernetes pods that connect and leave data.

What needs improvement?

The integration with other solutions needs to improve because Cosmos DB's interoperability is lacking in some scenarios. For example, I'm currently implementing Fabric. That involves migrating from environments without apps, processing data and users, and taking them to Fabric. 

When I have the pile of information that I need a data scientist to look at, I tell them to use Fabric as the development center. They can't connect to Cosmo DB, but I have data there. The documentation could be clearer, especially concerning infrastructure aspects.

For how long have I used the solution?

We have used Microsoft Azure Cosmos DB for about two years.

What do I think about the stability of the solution?

We haven't experienced significant stability issues with Cosmos DB. Occasionally, latency occurs between applications, but it has not caused major problems.

What do I think about the scalability of the solution?

While the scalability of Microsoft Azure Cosmos DB is theoretically simple and efficient, there is a degree of uncertainty. Dynamic scalability doesn't instill full confidence and can lead to increased costs if not managed correctly.

How was the initial setup?

The initial setup requires a steep learning curve due to the differences between the query language in MongoDB and NoSQL, making it a demanding task for developers.

It requires an educational process that can't be achieved quickly. It took us about four to six months. It's an adaptive process that's not difficult, but it is time-consuming. 

What about the implementation team?

The training for using Microsoft Azure Cosmos DB has been ongoing for four to six months, indicating a lengthy adaptation process for the development team.

What's my experience with pricing, setup cost, and licensing?

Cosmos DB is expensive, and the RU-based pricing model is confusing. Although they have a serverless layer, there are deficiencies in what I can define and assign to a database. Estimating infrastructure needs is not straightforward, making it challenging to manage costs.

What other advice do I have?

I rate Microsoft Azure Cosmos DB seven out of 10. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Jeff Yeh - PeerSpot reviewer
Senior Manager at eCloudvalley
Real User
Top 10
Stands out with global sync, cost-effectiveness, and fast performance
Pros and Cons
  • "The global synchronization feature of Azure Cosmos DB stands out as the most valuable for me."
  • "The global synchronization feature of Azure Cosmos DB stands out as the most valuable for me."
  • "I do not have any specific suggestions for improvements at the moment. However, having more AI capabilities in the future would be beneficial."

What is our primary use case?

Our primary use case for Azure Cosmos DB is mainly as a Document DB and vector DB.

How has it helped my organization?

Azure Cosmos DB is very easy to use. We do not have to spend a lot of time on its optimization.

There is a lot of reference code we can use. It is very easy. We could grab some code to interact with the database.

We have integrated the vector database with some of the IoT applications and recently, some AI-related topics because it is a cloud-native service. Our company offers professional services to help customers bring their own applications to the cloud. The cost and performance are some of the main benefits of the vector database. 

The integration of the vector database with Azure AI services is great. In most applications right now, we use the logic of vector search and the traditional way of using full-text search. It is easier for the applications to get those search results.

I am more on the presales side. Most of the time, we do a quick demo for our customers. We only spend about fifteen minutes building a simple application with the RAG functionality with the customer's own data. That is very impressive.

It provides good SLAs and requires less effort in maintenance.

What is most valuable?

The global synchronization feature of Azure Cosmos DB stands out as the most valuable for me. It is a reliable and consistent storage solution, suitable for various data types. It is always available. Additionally, it is cost-effective.

What needs improvement?

I do not have any specific suggestions for improvements at the moment. However, having more AI capabilities in the future would be beneficial.

For how long have I used the solution?

I have been using Azure Cosmos DB for three or four years.

What do I think about the stability of the solution?

The stability of Azure Cosmos DB is very nice, with features like cross-region synchronization that allows fast and reliable performance.

The latency and availability of Azure Cosmos DB are very nice. There are cross-region synchronization features. The speed is very fast.

What do I think about the scalability of the solution?

Azure Cosmos DB scales well, both in terms of capacity and performance. You can adjust the Request Units (RUs) as needed, and the cross-region synchronization allows easy scaling across different locations.

As compared to a traditional RDBMS, Azure Cosmos DB’s dynamic scaling decreases an organization’s overhead costs by half.

Which solution did I use previously and why did I switch?

We previously used Redis and Postgres for vector databases before they were supported in Azure Cosmos DB. In the beginning, the vector database was not supported with Azure Cosmos DB, so we had to use the Redis or Postgres database, which was expensive. Azure Cosmos DB is cheaper.

Our company offers consulting services for Microsoft-related products. This is one of the reasons for recommending Azure Cosmos DB, but sometimes our customers use MongoDB and other solutions.

How was the initial setup?

The initial setup of Azure Cosmos DB was easy. During the migration or implementation of Azure Cosmos DB, there are sometimes some incompatibility issues, but they are minor issues.

It was easy for our team to use. It took them one week to know the system and work with it. It takes our team members about four weeks to earn their certification for Azure Cosmos DB. There is a special certification for Azure Cosmos DB.

What's my experience with pricing, setup cost, and licensing?

It is cost-effective. They offer two pricing models. One is the serverless model and the other one is the vCore model that allows provisioning the resources as necessary. For our pilot projects, we can utilize the serverless model, monitor the usage, and adjust resources as needed.

What other advice do I have?

I would rate Azure Cosmos DB an eight out of ten. There is room for growth, but Microsoft is constantly releasing new features and moving very fast.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
PeerSpot user
reviewer2595795 - PeerSpot reviewer
Lead Solutions Architect at a energy/utilities company with 10,001+ employees
Real User
Top 20
Dynamic scaling has reduced our overhead
Pros and Cons
  • "The ability to scale automatically is very valuable. Additionally, multi-region support automatically synchronizing to a different region for multi-region applications is a cool feature. It's more of a lift with other databases to configure that extra region and set up replication, even if it's on the cloud. With Azure, it's just a button click. It's that simple."
  • "The ability to scale automatically is very valuable."
  • "The auto-scaling feature adjusts hourly. We have many processes that write stuff in batches, so we must ensure that the load is spread evenly throughout the hour. It would be much easier if it were done by the minute. I'm looking forward to the vector database search that they are adding. It's a pretty cool new feature."

What is our primary use case?

Our primary use case for Cosmos is the storage of shell-fed signs and our pricing systems. We use it as a transactional database on the back end.

What is most valuable?

The ability to scale automatically is very valuable. Additionally, multi-region support automatically synchronizing to a different region for multi-region applications is a cool feature. It's more of a lift with other databases to configure that extra region and set up replication, even if it's on the cloud. With Azure, it's just a button click. It's that simple. 

The learning curve depends on your background. It takes time to learn if you're from a relational database background like us. However, it's fairly straightforward from a scalability perspective once you get the hang of it. You need to be aware of certain concepts like partitions and partition keys. Once you get those, I think it's fairly okay.

What needs improvement?

The auto-scaling feature adjusts hourly. We have many processes that write stuff in batches, so we must ensure that the load is spread evenly throughout the hour. It would be much easier if it were done by the minute. I'm looking forward to the vector database search that they are adding. It's a pretty cool new feature. 

For how long have I used the solution?

I have used Cosmos for about five years.

What do I think about the stability of the solution?

The latency and availability are good. I don't have any complaints there. It goes back to how you're retrieving data and whether it's structured correctly. 

What do I think about the scalability of the solution?

Cosmos can definitely scale well, but it comes with a cost. One of our databases is quite large and scaled up significantly due to our needs.

How was the initial setup?

We have two databases, so it was challenging to define the partition key and ensure the workloads are spread out. We have millions of records in our Cosmos database, so spreading that out was difficult. We had to spread out the load to avoid a 429 error for a request that was too large. Partition key is more of a learning experience to understand the right thing to do. The entire process took around six months. It wasn't too hard.

What was our ROI?

We have reduced our overhead through dynamic scaling. I can't say precisely how much we've reduced our total cost of ownership using Cosmos DB, but we have a similar on-prem workload running on SQL, and we only pay a fraction for Cosmos.

What's my experience with pricing, setup cost, and licensing?

Cosmos is cheaper than other solutions, but you must be smart about how you use it to keep costs down. We've made mistakes where the cost has increased more than we expected. You have the opportunity for it to be cheap or costly.

Which other solutions did I evaluate?

We were looking for a multi-region document database, and the ease of configuring multi-region in Cosmos was a significant factor in our choosing the solution. We also wanted to bring costs down, which was the other reason.

What other advice do I have?

I would rate Cosmos an eight out of ten. Be cautious about spreading out the load evenly, especially when dealing with large volumes to prevent getting errors.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Kunal Mukerjee - PeerSpot reviewer
Vice President, Technology, Strategy & Architecture at Docusign
Real User
Top 20
The solution has improved search result quality, throughput, and query latency
Pros and Cons
  • "It is integral to our business because it helps manage schema and metadata for all our documents and customers. The AI insights we glean based on Azure OpenAI also end up in Cosmos DB. We need a NoSQL store because the schema is dynamic and flexible, so Cosmos DB is a great fit. It has four nines or possibly five nines availability, excellent geo-distribution, and auto-scaling."
  • "Cosmos DB is effective at handling large queries."
  • "The challenge for us is always scale."

What is our primary use case?

I'm the primary systems architect at DocuSign. We just launched a product at called Intelligent Agreement Management, and a central pillar of that is schema understanding. We use Microsoft Azure Cosmos DB as our schema store. It's the brains of our entire system. 

How has it helped my organization?

It is integral to our business because it helps manage schema and metadata for all our documents and customers. The AI insights we glean based on Azure OpenAI also end up in Cosmos DB. We need a NoSQL store because the schema is dynamic and flexible, so Cosmos DB is a great fit. It has four nines or possibly five nines availability, excellent geo-distribution, and auto-scaling. 

Cosmos DB has improved search result quality, throughput, and query latency. There are trade-offs to finding the sweet spot among all of these. Having a NoSQL solution that can do that in a 100 percent Azure shop is the best fit we could want. 

What is most valuable?

The features that stand out as most valuable are the autoscaling and hierarchical partition keys. We use account IDs at a higher level and entity IDs at a lower level. That gives us optimal query performance for our workloads.

AI has been a game-changer for new people without expertise, making it easier to use and optimize. You can ask GPT or Copilot for optimization strategies. If you have queries that are not performing well, you can feed the same queries, execution plan, and other things to the AI. The AI returns reasonable recommendations for what to do. 

Cosmos DB is effective at handling large queries. At DocuSign, we're processing over a billion signers and massive agreements and contracts. These things are being used for business-critical workloads, so performance, scale handling, and latency are crucial. Without these, we wouldn't have a product that anyone would want to use. 

For how long have I used the solution?

I have worked with Cosmos DB at my company for the past 18 months, but I have used Cosmos at Microsoft for nearly a decade.

What do I think about the stability of the solution?

Cosmos DB provides impressive stability due to its high availability and ability to handle massive data volumes, which is essential for our business-critical workloads.

What do I think about the scalability of the solution?

We have found Cosmos DB’s scalability to be exceptional, enabling horizontal and vertical sharding and supporting massive scale with efficient auto-scaling.

How are customer service and support?

The team behind Cosmos DB has been highly responsive, providing excellent transparency and high-quality postmortem reviews during incidents, ensuring continuous support and improvement.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup was straightforward. Cosmos DB's integration went quickly due to the team's prior experience with Azure services, allowing us to prototype within a couple of months.

The challenge for us is always scale. We needed to move all the tables in lockstep that are involved in join queries. In some cases, we came up with a structured pipeline where stage one would go to SQL, and some of the query hints for the Cosmos DB thing would come from that first stage and so on. That was a migration challenge in normalizing the data, bringing it into Cosmos, and then, again, denormalizing some of the data. 

What about the implementation team?

The critical mass of internal expertise, particularly from people previously working with Azure, enabled a smooth implementation with Cosmos DB.

What was our ROI?

Cosmos DB has always met our targets. However, we've always had our schema store on Cosmos DB, so it's not like we started with something expensive and brought our TCO down using Cosmos. Still, it's an excellent option for NoSQL or semi-structured data because our agreements start as a morass of raw data from PDF, OCR PDF, or paper OCR scans. 

After that, we match the structure with a known entity and for that known customer and run queries on Cosmos DB to bring out the rest of the structure and use AI to enhance it even further. In some cases, the customer will add custom fields to their entities. Cosmos gives us a low turnaround time from when the dynamic nature kicks into when the results return from that new schema information back to the same customer. It's a rich, complex scenario, but also a massive scale of data and customers.

What's my experience with pricing, setup cost, and licensing?

The pricing model for Cosmos DB has aligned well with our budget expectations. We did not encounter pain points related to costs and found it cost-effective compared to high-end SQL solutions initially considered.

Which other solutions did I evaluate?

When I joined, the company was already invested in Azure, so there was never a bake-off between Cosmos DB and offerings from AWS. We implemented Cosmos initially because we have a massive transaction database on SQL. On things like the total cost of ownership, Cosmos DB shines. It seems to be the correct approach for our semi-structured data and our schema and entity store. A combination of Cosmos DB and SQL Azure was how we shaped our architecture on this journey, but we didn't evaluate Cosmos DB against non-Azure NoSQL databases.

What other advice do I have?

I would rate Cosmos DB as an eight out of 10 for its overall capabilities, responsiveness, and alignment with our needs.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Noman Saeed - PeerSpot reviewer
Principal Consultant - D365 F & O Technical Solution Architect at Visionet Systems Inc.
Consultant
It provides concrete and optimized data when searching for new products on the site
Pros and Cons
  • "Cosmos is preferred because of its speed, robustness, and utilization. We have all the merchandising information in Cosmos DB, which provides concrete and optimized data when searching for new products on the site. It is faster than other relational databases."
  • "Cosmos is preferred because of its speed, robustness, and utilization."
  • "The main area of improvement is the cost, as the expense is high. Also, when writing processes into Cosmos, sometimes the threshold is met, which can be a problem if developers have not written the code properly, limiting calls to five thousand. These aspects need addressing."
  • "The main area of improvement is the cost, as the expense is high. Also, when writing processes into Cosmos, sometimes the threshold is met, which can be a problem if developers have not written the code properly, limiting calls to five thousand."

What is our primary use case?

We use Cosmos DB as a database for the cache mechanism. We have a product integrating e-commerce platforms with backend ERPs, pulling merchandising data. We maintain millions of products in the ERP and store them in Cosmos DB in document format. When a query comes from the e-commerce platform, it goes directly to Cosmos.  

How has it helped my organization?

Cosmos is preferred because of its speed, robustness, and utilization. We have all the merchandising information in Cosmos DB, which provides concrete and optimized data when searching for new products on the site. It is faster than other relational databases.

It can query large amounts of data efficiently, depending on how you write the queries. This is a Document Database, and the system needs to read the whole document. If that is correctly clustered, then it will be faster, but if the developer makes some mistakes, it won't be optimized. 

What is most valuable?

The most valuable feature is the data writing process, where we write data into batch segments. The built-in vector database is helpful. There's one vector for the product and another for the price. I don't have much experience with vectors because we use Cosmos as a cache DB. You won't see any major challenges when you use it as a more significant enterprise application. I would rate the vector database's interoperability with other solutions an eight out of 10. 

What needs improvement?

The main area of improvement is the cost, as the expense is high. Also, when writing processes into Cosmos, sometimes the threshold is met, which can be a problem if developers have not written the code properly, limiting calls to five thousand. These aspects need addressing.

For how long have I used the solution?

I have been using Cosmos DB for three years.

What do I think about the scalability of the solution?

I would rate the interoperability of the vector database with other solutions as eight out of ten. It's good, but the performance depends on how well queries are written.

Which solution did I use previously and why did I switch?

We compared MongoDB and Cosmos DB. Cosmos DB is easier to configure, and our team is already familiar with managing it, providing an advantage.

How was the initial setup?

The initial setup was straightforward, with no major challenges. We onboarded the team in no more than three days. 

What's my experience with pricing, setup cost, and licensing?

The cost of using Cosmos DB is high, which sometimes raises concerns from clients regarding the increased solution cost. While it has helped decrease the overall cost of ownership, the specific figures are not readily available.

What other advice do I have?

I would rate Azure Cosmos DB eight out of 10. The solution is variously challenging but manageable once the team is familiar.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Disclosure: My company has a business relationship with this vendor other than being a customer:
Flag as inappropriate
PeerSpot user
Mohamed Ait  Salah - PeerSpot reviewer
Cloud Solutions Architect and Microsoft Principal Consultant for EMEA at a tech vendor with 10,001+ employees
Real User
Top 10
It is available in every region, allowing quick information storage and retrieval
Pros and Cons
  • "Azure Cosmos DB's resiliency is valuable. It is available in every Azure region, allowing quick information storage and retrieval. We can partition it to improve indexing, enabling us to retrieve information and recreate website content quickly."
  • "Cosmos DB has helped our organization handle large amounts of data."
  • "Cosmos DB should continue evolving in AI features. We expect Cosmos DB to lead on that. There is potential for improved security features, which is important for data storage, especially for Dell Technologies. We must ensure data security remains the top priority."
  • "We expect Cosmos DB to lead on that. There is potential for improved security features, which is important for data storage, especially for Dell Technologies."

What is our primary use case?

Our primary use case for Azure Cosmos DB is storing information for our large accounting application, which integrates several sites on SharePoint Online. We use event programming to store all calls in Cosmos DB, so we can redo them and have them persist in the database.

How has it helped my organization?

Cosmos DB has helped our organization handle large amounts of data. For example, we had a customer who collected data from 100,000 sites, and we increased that to a million without significantly increasing search query time. We can now search in nearly real-time, which has been crucial, especially with AI workloads.

What is most valuable?

Azure Cosmos DB's resiliency is valuable. It is available in every Azure region, allowing quick information storage and retrieval. We can partition it to improve indexing, enabling us to retrieve information and recreate website content quickly. 

It's easy to use for our use case because we use it to store and retrieve information, but it will be more complex if you are configuring a Redis cache or something similar. 

Cosmos DB also integrates well with Azure app services and functions, allowing us to scale by efficiently storing calls. Its ability to scale workloads is impressive, and features like partitioning and Azure replication enhance its scalability. Its interoperability with solutions is better than that of other NoSQL databases we assessed. It's native to Azure and integrates with the networks and security.

What needs improvement?

Cosmos DB should continue evolving in AI features. We expect Cosmos DB to lead on that. There is potential for improved security features, which is important for data storage, especially for Dell Technologies. We must ensure data security remains the top priority.

For how long have I used the solution?

I have been using Cosmos DB for over eight years, starting from its preview release.

What do I think about the stability of the solution?

There have been no notable issues with the stability of Cosmos DB. Any problems encountered were not directly related to Cosmos DB but perhaps coding errors or usage methods.

What do I think about the scalability of the solution?

Cosmos DB scales workloads impressively through features such as partitioning and Azure replication. Its design as a NoSQL database has helped us transition from traditional SQL, impacting costs positively.

Which solution did I use previously and why did I switch?

We previously used MongoDB, but Cosmos DB's integration within Azure provided better network and security options, making it a preferred choice. I've worked on Microsoft technologies since the beginning, and I love how Microsoft solutions are integrated. Everything works together securely, and moving from one technology to another is simple.

How was the initial setup?

The initial setup was easy. The transition from MongoDB was seamless as Cosmos DB has improved upon existing NoSQL structures without reinventing them.

What was our ROI?

Cosmos DB has decreased our organization's total cost of ownership, particularly with decreasing overhead costs due to its scalable features.

What's my experience with pricing, setup cost, and licensing?

We prioritized fine-tuning operations to optimize costs, and Cosmos DB’s pricing model allows room for improvement. We are assessing its use in other areas to potentially eliminate third-party solutions.

What other advice do I have?

I rate Microsoft Azure Cosmos DB nine out of 10. To avoid migration challenges, data storage methods in Cosmos DB should be carefully considered.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Flag as inappropriate
PeerSpot user