Microsoft Azure Synapse Analytics Pros and Cons

Microsoft Azure Synapse Analytics Pros

JS
Jael Sande
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 »
SS
reviewer1394304
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 »
Alexis Bustamante
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 »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: March 2021.
474,038 professionals have used our research since 2012.
DR
reviewer1521174
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
Enterprise Solutions at Celebal Technologies
They are available on the Cloud, and the platform is very intuitive.
View full review »
MD
reviewer1003956
Managing Partner at a tech services company with 11-50 employees
The most valuable feature is the scalability.
View full review »
ML
reviewer1072665
Managing Director at a consultancy with 1-10 employees
The stability is pretty good.
View full review »
CS
EmeaIT677
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees
Scaling this solution is easy and the uptime is okay.
View full review »
EK
reviewer1052472
Data Architect at a tech services company with 10,001+ employees
The MPP (Massively Parallel Processing) architecture helps to make things a lot faster.
View full review »
AveekDas
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 »

Microsoft Azure Synapse Analytics Cons

JS
Jael Sande
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 »
SS
reviewer1394304
Sr. Teradata Consultant at a tech services company with 201-500 employees
The performance needs to improve in future releases.
View full review »
Alexis Bustamante
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 »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: March 2021.
474,038 professionals have used our research since 2012.
DR
reviewer1521174
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
Enterprise Solutions at Celebal Technologies
It needs strong support for social media, internet data, and native support for NoSQL.
View full review »
MD
reviewer1003956
Managing Partner at a tech services company with 11-50 employees
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.
View full review »
ML
reviewer1072665
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 »
CS
EmeaIT677
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees
I would like to see better integration with Active Directory, because we have had problems, and we still do.
View full review »
EK
reviewer1052472
Data Architect at a tech services company with 10,001+ employees
This is a young product in transition to the cloud and it needs more work before it is both settled as a product and competitive in the market.
View full review »
AveekDas
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 »
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: March 2021.
474,038 professionals have used our research since 2012.