We just raised a $30M Series A: Read our story

Microsoft Azure Synapse Analytics Pros and Cons

Microsoft Azure Synapse Analytics Pros

JS
Information Architect at Systems Analysis & Design Engineering
We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud.
View full review »
CHTO at Timp-iT
The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems.
View full review »
SS
Sr. Teradata Consultant at a tech services company with 201-500 employees
Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task.
View full review »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
552,136 professionals have used our research since 2012.
STI Data Leader at grupo gtd
We use Azure Synapse Analytics in many different areas and industries, so I like that you can administrate and create pipelines for difference sources of data and later integrate and deploy it to other internal areas, such as separate dashboards for financials, and so on.
View full review »
DR
Director, Consulting, Technology Services at a financial services firm with 1,001-5,000 employees
The ability to scale out services on-demand and scale them down when they are not required is most valuable. You are in control of your expenditures, and you are also in control of the horsepower that you need. That's a major advantage.
View full review »
Enterprise Solutions at Celebal Technologies
They are available on the Cloud, and the platform is very intuitive.
View full review »
ML
Managing Director at a consultancy with 1-10 employees
The stability is pretty good.
View full review »
Analytics Engineer at a tech services company with 51-200 employees
The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis.
View full review »
JL
Senior Architect at a tech services company with 51-200 employees
I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics.
View full review »
NN
Data Architect at a insurance company with 1,001-5,000 employees
The solution's scalability is very, very good. It's one of the most important aspects for us.
View full review »

Microsoft Azure Synapse Analytics Cons

JS
Information Architect at Systems Analysis & Design Engineering
It would be beneficial to take the top vendors and identify some kind of straightforward action to work with them. Instead of having to employ a separate vendor tool to be able to move this, it would be nice to be able to go through Microsoft.
View full review »
CHTO at Timp-iT
Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful.
View full review »
SS
Sr. Teradata Consultant at a tech services company with 201-500 employees
The performance needs to improve in future releases.
View full review »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
552,136 professionals have used our research since 2012.
STI Data Leader at grupo gtd
Unfortunately, we have had some issues with the dashboard reporting. Sometimes, the data for specific periods would just appear blank on the dashboard. To investigate this, we worked with a Microsoft incident agent and it turned out to be a result of bugs in the platform when dealing with specific types of queries in Azure Data Factory.
View full review »
DR
Director, Consulting, Technology Services at a financial services firm with 1,001-5,000 employees
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.
View full review »
Enterprise Solutions at Celebal Technologies
It needs strong support for social media, internet data, and native support for NoSQL.
View full review »
ML
Managing Director at a consultancy with 1-10 employees
The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them.
View full review »
Analytics Engineer at a tech services company with 51-200 employees
I would like to see version control implemented into the data warehouse.
View full review »
JL
Senior Architect at a tech services company with 51-200 employees
It's a complicated product.
View full review »
NN
Data Architect at a insurance company with 1,001-5,000 employees
While the solution is flexible, sometimes this works against the user.
View full review »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
552,136 professionals have used our research since 2012.