Try our new research platform with insights from 80,000+ expert users

Kovair Data Lake vs Microsoft Azure Synapse Analytics comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Kovair Data Lake
Average Rating
8.0
Reviews Sentiment
7.2
Number of Reviews
2
Ranking in other categories
Data Warehouse (18th)
Microsoft Azure Synapse Ana...
Average Rating
8.0
Reviews Sentiment
7.0
Number of Reviews
92
Ranking in other categories
Cloud Data Warehouse (2nd)
 

Featured Reviews

LuizKazan - PeerSpot reviewer
Ability to interact with teachers in real-time and manage lessons after class
The deployment process is very fast. We have prepared the product to be easily installed, and we have had successful cases where it could be implemented in less than a few weeks. Moreover, Around three or four people in a call center are involved in maintaining the solution. We have a project manager, a service manager, and at least two or three system analysts who handle the maintenance. If there are any issues, we can open a support ticket for them to address.
Renee Hoon - PeerSpot reviewer
Scalable performance tuning and optimization for finance and supply chain jobs
We run our finance and supply chain jobs using SQL BW, and we visualize our data loads on Power BI. We are using SQL Data Warehouse for data warehousing In terms of cost savings, we don't need specialization in skills as advanced as Teradata. We used to pay extensive licensing fees for Teradata,…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable feature is the ability to interact with teachers in real-time and manage lessons after class."
"The tool's most valuable features for us are its combination of formatting, ETL, analytics, and storage capabilities."
"The product provides a seamless and adaptable approach to data processing and analytics."
"The most valuable feature of Microsoft Azure Synapse Analytics is the capabilities, and the integration with other Azure resources, such as Data Factory, Databricks, and Spark for data processing. The overall ability to compose the solution with other Azure resources is valuable."
"The initial setup process is straightforward."
"The stability is pretty good."
"I have been working with Microsoft, and they have been very helpful."
"I love the way all the application resources from Microsoft can synchronize, help me with a lot of stuff, and reduce the time or hour of having maybe a resource for an hour a day while also being able to use artificial intelligence."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"Synapse Analytics' best features are notebooks, pipelines, and monitoring."
 

Cons

"The solution is expensive. For future releases, it would be beneficial if Kovair Data Lake could enhance its ETL and data capabilities."
"Maybe the chat conversation feature could be improved."
"I would like to see better integration with Active Directory, because we have had problems, and we still do."
"This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query."
"The performance and data consistency need to be improved."
"Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great."
"It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."
"Right now, we are really struggling with the performance. it's not as good as we had hoped."
"The major challenge that we're seeing with Azure Synapse is around security concerns. The way it is working right now, it has Managed VNet by Microsoft option, similar to the implementation of Azure Databricks, which may pose a concern for financial institutions. For managed environments, the banks have very strict policies around data being onboarded to those environments. For some confidential applications, the banks have the policy to encrypt it with their own key, so it is sort of like Bring Your Own Key, but it is not possible to manage the resources with Microsoft or Databricks, which is probably the major challenge with Azure Synapse. There should be more compatibility with SQL Server. It should be easier to migrate solutions between different environments because right now, it is not really competitive. It is not like you can go and install SQL Database in some other environment. You will have to go through some migration projects, which probably is one of the major showstoppers for any bank. When they consider Synapse, they not only consider the investment in the actual service; they also consider the cost of the migration process. When you scale out or scale down your system, it becomes unavailable for a few minutes. Because it is a data warehouse environment, it is not such a huge deal, but it would be great if they can improve it so that the platform is available during the change of configuration."
"The support and price could improve."
 

Pricing and Cost Advice

"I rate the tool's pricing a five out of ten."
"All of the prices are available online."
"We only have to pay for what we use in the solution. It's easy for the customers. It's not more than some companies, not more than 300 to 400 users. They do not need to buy other license products, such as SAP B1, or analytics tools in the market, such as Tableau."
"The product is expensive."
"The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte."
"I'm not sure of the exact cost, however, it is around $100,000 a year."
"This is a cost-effective product."
"We normally pay between $300 and $500 per month, which is quite expensive for how much we actually use it, performance- and usage-wise. They have a cheap version and an expensive version, and our usage usually falls in the middle ground, which makes it not as cost-effective as it could be."
"We are on a monthly payment plan for the use of Microsoft Azure Synapse Analytics."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
850,028 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Educational Organization
51%
Computer Software Company
5%
Financial Services Firm
5%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Kovair Data Lake?
The tool's most valuable features for us are its combination of formatting, ETL, analytics, and storage capabilities.
What needs improvement with Kovair Data Lake?
The solution is expensive. For future releases, it would be beneficial if Kovair Data Lake could enhance its ETL and data capabilities.
What is your primary use case for Kovair Data Lake?
I primarily use Kovair Data Lake for data analytics use cases. This involves data cleansing and gaining business intelligence.
How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Microsoft Azure Synapse Analytics?
The product is easy to use, and anybody can easily migrate to advanced DB.
What is your experience regarding pricing and costs for Microsoft Azure Synapse Analytics?
We use an enterprise-level subscription for Microsoft Azure Synapse Analytics. I would rate our satisfaction with the price around five, as I have not focused much on cost aspects presently.
 

Also Known As

No data available
Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
 

Overview

 

Sample Customers

HSBC, NVIDIA, APPLIED MATERIALS, Allscripts, CISCO, Honeywell
Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
Find out what your peers are saying about Kovair Data Lake vs. Microsoft Azure Synapse Analytics and other solutions. Updated: April 2025.
850,028 professionals have used our research since 2012.