IT Central Station is now PeerSpot: Here's why

Microsoft Azure Synapse Analytics Pros

JS
Information Architect with 201-500 employees
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 »
MichelTimp - PeerSpot reviewer
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 »
Alexis Bustamante - PeerSpot reviewer
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 »
Buyer's Guide
Microsoft Azure Synapse Analytics
July 2022
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
622,063 professionals have used our research since 2012.
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 »
Mukul Biswas - PeerSpot reviewer
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 »
MandarGarge - PeerSpot reviewer
V.P. Digital Transformation at e-Zest Solutions
One central workspace to manage everything for your data warehouse including visualization.
View full review »
Matthew Spieth - PeerSpot reviewer
Senior Database Administrator at Summa Health System
I have not used the technical support from Microsoft Azure Synapse Analytics, but I worked with the developers at Microsoft who were top-notch.
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 »
Veerendra Karnam - PeerSpot reviewer
General Manager at itcinfotech
The initial setup is very simple.
View full review »

Microsoft Azure Synapse Analytics Cons

JS
Information Architect with 201-500 employees
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 »
MichelTimp - PeerSpot reviewer
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 »
Alexis Bustamante - PeerSpot reviewer
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 »
Buyer's Guide
Microsoft Azure Synapse Analytics
July 2022
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
622,063 professionals have used our research since 2012.
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 »
Mukul Biswas - PeerSpot reviewer
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 »
MandarGarge - PeerSpot reviewer
V.P. Digital Transformation at e-Zest Solutions
I'd like to see part of the service de-coupled.
View full review »
Matthew Spieth - PeerSpot reviewer
Senior Database Administrator at Summa Health System
Microsoft Azure Synapse Analytics could improve its compatibility with Visual Studio. One of the challenges for people moving from an on-premise to a cloud solution, such as Microsoft Azure Synapse Analytics, is that you're constantly working in a browser. There are people that have been working for decades on desktop applications. For them to start working in a browser, it's quite a change. Allowing people to work and do their work inside Visual Studio than in the browser, would be a large advantage.
View full review »
JL
Senior Architect at a tech services company with 51-200 employees
It's a complicated product.
View full review »
Veerendra Karnam - PeerSpot reviewer
General Manager at itcinfotech
The only concern for us is the cost part. When it comes to the implementation and the support and maintenance, we see high-cost implications.
View full review »
Buyer's Guide
Microsoft Azure Synapse Analytics
July 2022
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
622,063 professionals have used our research since 2012.