Microsoft Azure SQL Data Warehouse Reviews
Nov 17 2019
What is most valuable?The most valuable feature is the scalability. It scales out, so you can build a large database and not have to think about whether it performs, or about connecting to the servers to become larger.
What needs improvement?There are several specific features and functions available on the on-premises version that do not work with the cloud version. There are many issues regarding migration. They are building it more and more, but if you have the same version on local you cannot just go to the cloud because some of the… more»
What's my experience with pricing, setup cost, and licensing?This solution starts at €1000.00 a month for just the basics and can go up to €300,000.00 per month for the fastest version. 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… more»
What other advice do I have?It's a nice solution for a simple data warehousing, but it's still an immature solution. It is stable but it takes a lot of time. Smaller companies have better products, but the problem will always be there and the smaller company will not survive. Customers will have tools that are not supported… more»
Jul 30 2019
What is most valuable?The most valuable features of this solution are its easy setup and ease of use. The SQL functions are ok. I've been working with Microsoft SQL Server, MySQL, and PostgreSQL for a long time, and… more»
What needs improvement?There are several things that I would like to see improved with this solution, including: * The price of this solution could be improved. * I would like to see better integration with Active… more»
What's my experience with pricing, setup cost, and licensing?This is a pricey solution.
Which solution did I use previously and why did I switch?We used Power BI before choosing this solution.
What other advice do I have?My advice for anybody researching this or a similar solution is to list the pros and cons, along with the price, and estimate your needs before starting the project. I would also suggest contacting… more»
Which other solutions did I evaluate?This solution was my recommendation, and I made it because we are a big Microsoft customer and, as such, felt that the integration would be smoother. It probably was. We did evaluate other options… more»
Find out what your peers are saying about Microsoft, Snowflake Computing, Amazon and others in Cloud Data Warehouse. Updated: December 2019.
391,122 professionals have used our research since 2012.
Nov 14 2019
What is most valuable?What I like the most would be MPP (Massively Parallel Processing) architecture. Because we had to migrate a lot of data and it helps us a lot to make things faster.
What needs improvement?As far as improvements to the product, I think the Data Factory integration should be enhanced to be properly implemented because right now it is still lagging behind other vendors like Informatica. We ended up having to use Data Factory because we don't have any expertise in Informatica. But I want to see Data Factory get better overall. An enhancement I would like to see is in data loading for… more»
What other advice do I have?My advice to other people considering this solution is that this is a great product. But there is one problem and that is the rate that Microsoft is changing its software implementations. The rapid changes could make it hard to keep up with upgrades. Some of the features get enabled and disabled very quickly. So we are waiting now until everything settles down because cloud technology is still… more»
Dec 17 2019
What is most valuable?The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis. We have a nightly load where all of the data is updated, and it is a very good feature. The transaction log shipping gives us the ability to replicate the database onto different… more»
What needs improvement?The major concern is that I have a hard time with having to version control the data warehouse all the time. As it is now, I have to open all of the ports and push everything onto the server. I would like to see version control implemented into the data warehouse. This would make the tool perfect.
Which solution did I use previously and why did I switch?I began with Microsoft SQL Server and have been on the Microsoft platform ever since.
What other advice do I have?There are certain design concepts that can be used to design a data warehouse. My advice to anybody who is implementing this solution is to first study the user's needs, and then go with that approach. The design will be specific to the needs. I would rate this solution an eight out of ten.
Dec 12 2019
What is most valuable?The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range. When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage.
What needs improvement?With respect to what needs to be improved, concurrent connectivity has some limitations.
What other advice do I have?This solution is being changed from day-to-day. Now it has become Synapse Analytics and a lot of things are being added to it. I'm curious to see how that turns out. They have a lot of new integrations and features, including predictive analysis and big data integration. They may have solved the issues with concurrent connectivity, so I'm curious to put my hands on it. The product is being… more»
Dec 16 2019
What is most valuable?The best part is the easy and user-friendly administration and handling of the data.
How has it helped my organization?Using Azure SQL Data Warehouse means that you don't have to worry about big servers.
What needs improvement?The configuration for things like high-availability could be more user-friendly for non-technical users.
What's my experience with pricing, setup cost, and licensing?The licensing fees for this solution are on a pay-per-use basis, and not very expensive.
What other advice do I have?The core strength of Microsoft technologies is ease of use and administration, regardless of the type of product. This is a good solution to go with, the cost is reasonable, and I recommend it. I would rate this solution an eight out of… more»
Dec 15 2019
What is most valuable?The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.
How has it helped my organization?We haven't really implemented any SSIS. I haven't been in a project where it was implemented as part of the data we have been building.
What needs improvement?So far, with the current SQL that I'm using compared to what we've previously used, I'm happy with it. I wouldn't necessarily point out anything that needs improvement. From my point of view from what we have implemented recently, I'm happy… more»
What's my experience with pricing, setup cost, and licensing?The enterprise services are pretty expensive.
Which solution did I use previously and why did I switch?I've used Tableau, I've used SQL DB, I've used SAP DB.
Dec 19 2019
What is most valuable?The most valuable feature of the solution is the analytics and that it can connect with Power BI. I found it quite interesting and very compelling in terms of detail within a single stack.
What needs improvement?I would like my team to be able to build pipelines that integrate with the Azure Data Factory. Some of the best-in-class ETL products that are available in the market, such as Informatica ETL, are far more mature than this solution.
Which solution did I use previously and why did I switch?In addition to Azure SQL Data Warehouse, we work with the version that is on-premises. We are also working with Oracle Data Warehouse and we plan to continue using both of these solutions.
What other advice do I have?If you are using Microsoft products, such as Office 365, then this solution is good because it can take the data from multiple sources. This is a good product, but when you compare to Oracle Data Warehouse there are differences in scalability, high availability, and implementation. I would rate this… more»
See 2 More Microsoft Azure SQL Data Warehouse Reviews
User Assessments By Topic About Microsoft Azure SQL Data Warehouse
Microsoft Azure SQL Data Warehouse Questions
What is Microsoft Azure SQL Data Warehouse?
Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.
Also known asMicrosoft Azure SQL DW, Azure SQL Data Warehouse
Microsoft Azure SQL Data Warehouse customers
Toshiba, Carnival, LG Electronics, Jet.com, Adobe,