Project Manager at a tech services company with 5,001-10,000 employees
Real User
2019-12-18T05:44:00Z
Dec 18, 2019
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 solution a seven out of ten.
Analytics Engineer at a tech services company with 51-200 employees
Real User
2019-12-15T05:58:00Z
Dec 15, 2019
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.
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 ten.
Practice Head BI at a tech vendor with 1,001-5,000 employees
MSP
2019-12-11T05:40:00Z
Dec 11, 2019
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 upgraded and updated to support a lot of analytic features, and it is a great tool to use. I would rate this solution a nine out of ten.
Managing Partner at a tech services company with 11-50 employees
Real User
2019-11-13T05:29:00Z
Nov 13, 2019
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 anymore. Microsoft is so big that people trust them, they will eventually get there but it will take time to get the features with quality. There are, however, some solutions available that are better and cheaper. You can purchase them instead of having to reprogram everything that you have already done. My advice would be to compare this solution with others. Snowflake would be a comparable solution. It's cheaper, faster, and better. I would rate this solution a seven out of ten.
Data Architect at a tech services company with 10,001+ employees
Real User
2019-11-13T05:28:00Z
Nov 13, 2019
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 evolving. We understand that. But, on the other hand, as they make so many changes to keep up with the technology, it remains hard to predict what the future of the product is. I might say to anyone that they wait for some time in 2020 and then start using the product. On a scale from one to ten where one is the worst and ten is the best, I would rate the product as somewhere between a seven or an eight. If I have to choose seven or eight, I would pick seven-out-of-10.
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees
Real User
2019-07-28T07:35:00Z
Jul 28, 2019
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 support for Microsoft, Google, and Amazon. Finally, look into other, better-niched providers, like Teradata. Scaling this solution is easy and the uptime is okay. It is easy to use, and the support is excellent. My biggest complaint is the cost. I would rate this solution a nine out of ten.
Microsoft Azure Synapse Analytics is an end-to-end analytics solution that successfully combines analytical services to merge big data analytics and enterprise data warehouses into a single unified platform. The solution can run intelligent distributed queries among nodes, and provides the ability to query both relational and non-relational data.
Microsoft Azure Synapse Analytics is built with these 4 components:
Synapse SQL
Spark
Synapse Pipeline
Studio
Microsoft Azure Synapse Analytics...
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 solution a seven out of ten.
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.
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 ten.
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 upgraded and updated to support a lot of analytic features, and it is a great tool to use. I would rate this solution a nine out of ten.
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 anymore. Microsoft is so big that people trust them, they will eventually get there but it will take time to get the features with quality. There are, however, some solutions available that are better and cheaper. You can purchase them instead of having to reprogram everything that you have already done. My advice would be to compare this solution with others. Snowflake would be a comparable solution. It's cheaper, faster, and better. I would rate this solution a seven out of ten.
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 evolving. We understand that. But, on the other hand, as they make so many changes to keep up with the technology, it remains hard to predict what the future of the product is. I might say to anyone that they wait for some time in 2020 and then start using the product. On a scale from one to ten where one is the worst and ten is the best, I would rate the product as somewhere between a seven or an eight. If I have to choose seven or eight, I would pick seven-out-of-10.
I will rate this solution an eight out of ten. Not a ten due to the lack of integration.
I would rate it a seven out of ten.
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 support for Microsoft, Google, and Amazon. Finally, look into other, better-niched providers, like Teradata. Scaling this solution is easy and the uptime is okay. It is easy to use, and the support is excellent. My biggest complaint is the cost. I would rate this solution a nine out of ten.