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 tool's most valuable features for us are its combination of formatting, ETL, analytics, and storage capabilities."
"The most valuable feature is the ability to interact with teachers in real-time and manage lessons after class."
"The solution's scalability is very, very good. It's one of the most important aspects for us."
"Synapse Analytics' best features are notebooks, pipelines, and monitoring."
"The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS."
"The most important feature for me is the integration with PolyBase."
"I have been working with Microsoft, and they have been very helpful."
"The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis."
"I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"The solution's best feature is its predictive analytics."
 

Cons

"Maybe the chat conversation feature could be improved."
"The solution is expensive. For future releases, it would be beneficial if Kovair Data Lake could enhance its ETL and data capabilities."
"The linked services can be improved. We can create dynamic linked services to access a lot of databases but only those of the same type. For example, I can use the same linked services to access 11 SQL databases. However, if I have 11 SQL databases and five Oracle databases, I need two dynamic linked services. I cannot do it with only one linked service. The UI also needs to be improved. When I have used Azure Synapse for programming with PySpark, Scala, or .NET, for example, the UI has been unstable. If I open two notebooks for programming, one notebook will queue the session of the other."
"Non-structured data is unavailable with this product."
"It could be beneficial to focus on integration with various data sources and similar enhancements."
"It's pay as you go, so you never know what your bill is going to be beforehand, and that's scary for customers. If you have someone who makes a mistake and the program's a loop that is running all night, you could receive a very expensive bill."
"It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database."
"The support and price could improve."
"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."
"Microsoft Azure Synapse Analytics could improve in usability. I have found the same issue with all Microsoft solutions."
 

Pricing and Cost Advice

"I rate the tool's pricing a five out of ten."
"It goes by the usage, and there are some limits. Synapse goes by particular pricing, and it is expensive. Both Azure Synapse Analytics and Snowflake are pretty expensive. They don't have standard pricing. They deal with each customer differently."
"Price varies by use-case. You pay for the database itself in addition to any consumed data within Serverless plus other fees if you use the Data Factory that is inside."
"The solution is very expensive because it often requires the purchase of additional storage."
"The price of Microsoft Azure Synapse Analytics can vary. Other solutions are typically fixed prices and a fixed cost regardless of usage, but this solution is based on usage or consumption."
"The price of the package not expensive and depends on how much it is used."
"The solution is subscription-based. You can also pay to use the product as you go."
"It requires a less expensive version because currently, not every customer is able to buy it. If it could have a smaller setup that doesn't require so many resources, it would be helpful, and we would be able to use it in more cases. We are a small country, and most of our customers are quite small businesses."
"There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
847,959 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Educational Organization
52%
Computer Software Company
5%
Manufacturing Company
5%
Financial Services Firm
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.
847,959 professionals have used our research since 2012.