2019-07-28T07:35:00Z
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
  • 0
  • 95

What do you like most about Microsoft Azure Synapse Analytics?

Hi Everyone,

What do you like most about Microsoft Azure Synapse Analytics?

Thanks for sharing your thoughts with the community!

52
PeerSpot user
52 Answers
RobertoMessora - PeerSpot reviewer
Head of Business Integration and Architecture at Jakala
Real User
Top 5
2022-10-21T13:22:26Z
Oct 21, 2022

The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution.

Search for a product comparison
AT
Senior Director/ Advisory Architect at Capgemini
Reseller
Top 5
2022-09-20T17:58:37Z
Sep 20, 2022

The setup is pretty simple.

BS
Founder and Managing Director at a tech services company with 1-10 employees
Consultant
2022-08-24T16:30:10Z
Aug 24, 2022

The most valuable feature of Microsoft Azure Synapse Analytics is the capabilities, and the integration with other Azure resources, such as Data Factory, Databricks, and Spark for data processing. The overall ability to compose the solution with other Azure resources is valuable.

Dhruv Singh - PeerSpot reviewer
Senior Architect (Data and AI) at a tech services company with 201-500 employees
Real User
Top 20
2022-08-04T09:59:00Z
Aug 4, 2022

The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge.

Muralidharan Lakshmanachar - PeerSpot reviewer
Director at Capgemini
Real User
Top 20
2022-07-20T11:46:35Z
Jul 20, 2022

Synapse Analytics' best feature is its ability to process large files.

JoseArguello - PeerSpot reviewer
Data Engineer at a manufacturing company with 10,001+ employees
Real User
Top 20
2022-07-05T18:48:31Z
Jul 5, 2022

The solution can scale.

Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
656,862 professionals have used our research since 2012.
VarunJoshi - PeerSpot reviewer
Senior manager at Accenture
Reseller
Top 20
2022-06-06T08:20:36Z
Jun 6, 2022

It's scalable; you can scale up and scale down.

Sunil Gidwani - PeerSpot reviewer
Cloud Solution Development Manager at Stryker Corporation
Real User
Top 20
2022-05-29T13:17:00Z
May 29, 2022

I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity.

Veerendra Karnam - PeerSpot reviewer
General Manager at itcinfotech
MSP
Top 20
2022-05-12T06:53:59Z
May 12, 2022

The initial setup is very simple.

Matthew Spieth - PeerSpot reviewer
Senior Database Administrator at Summa Health System
Real User
Top 5Leaderboard
2022-03-30T19:12:50Z
Mar 30, 2022

I have not used the technical support from Microsoft Azure Synapse Analytics, but I worked with the developers at Microsoft who were top-notch.

Fabio Xavier - PeerSpot reviewer
Director of Systems of the TCESP at a government with 501-1,000 employees
Real User
Top 5
2022-03-03T09:24:13Z
Mar 3, 2022

The most valuable features of Microsoft Azure Synapse Analytics are the user experience because it is easy to make analyses, load different databases, and different resources. Our end users can do the analysis by themselves without IT supervising. This is a great aspect of the solution, it's better for our environment.

PedroNavarro - PeerSpot reviewer
BI Development & Validation Manager at JT International SA
Real User
Top 5Leaderboard
2022-02-03T12:09:00Z
Feb 3, 2022

This is a stable solution with many functionalities.

HarishAjjarapu - PeerSpot reviewer
Associate Director at Accenture
Real User
Top 5
2022-01-26T14:11:00Z
Jan 26, 2022

The solution offers strong scalability opportunities.

VY
Chief Data Architect - Europe at Wipro Limited
Real User
Top 10
2021-12-27T19:04:00Z
Dec 27, 2021

Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution.

SZ
Data Platform Architect at APN Promise
Real User
Top 20
2021-11-24T05:15:04Z
Nov 24, 2021

Fills the gap between big data and classic data warehouses.

Chitra Govindasamy - PeerSpot reviewer
BI Consultant at a tech services company with 11-50 employees
Consultant
Top 10
2021-10-22T18:44:48Z
Oct 22, 2021

The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is a benefit.

VP
Sr. Principal, Vice President - Digital Transformation & Strategic Pursuits Leader at a tech services company with 10,001+ employees
Real User
Top 20
2021-09-14T10:13:56Z
Sep 14, 2021

We've had a good experience with technical support in general.

NT
Senior Systems Analyst at a non-profit with 201-500 employees
Real User
Top 10
2021-08-17T18:39:37Z
Aug 17, 2021

The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services.

MichelTimp - PeerSpot reviewer
CHTO at Timp-iT
Real User
Top 5
2021-05-17T12:28:28Z
May 17, 2021

The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems.

Anoop Anoop SLK - PeerSpot reviewer
Enterprise architect at a computer software company with 201-500 employees
Real User
Top 5Leaderboard
2021-03-11T12:40:17Z
Mar 11, 2021

Overall deployment and integration is pretty fast.

SB
Co-owner, Director at a tech services company with 1-10 employees
Real User
Top 20
2021-02-23T09:59:56Z
Feb 23, 2021

The whole solution is interesting for us.

Alexis Bustamante - PeerSpot reviewer
STI Data Leader at grupo gtd
Real User
Top 5Leaderboard
2021-02-17T03:48:28Z
Feb 17, 2021

The useability, the user interface, is very user-friendly.

NN
Data Architect at a insurance company with 1,001-5,000 employees
Real User
2021-02-12T18:16:50Z
Feb 12, 2021

The solution's scalability is very, very good. It's one of the most important aspects for us.

RaniG - PeerSpot reviewer
Azure Data Specialist at a financial services firm with 5,001-10,000 employees
Real User
Top 10
2021-02-06T07:34:59Z
Feb 6, 2021

Very interactive and provides flexibility.

ML
Managing Director at a consultancy with 1-10 employees
Real User
Top 20
2021-01-28T22:53:34Z
Jan 28, 2021

The stability is pretty good.

KG
Associate Manager at a consultancy with 501-1,000 employees
Real User
Top 5Leaderboard
2021-01-27T17:20:19Z
Jan 27, 2021

We have found that it is easy to develop and to do the analytics in the modules of data.

Mullai Selvan - PeerSpot reviewer
Project Manager at MAQ Software
Real User
Top 5
2020-12-31T08:39:34Z
Dec 31, 2020

The pricing seems to be quite fair.

Alexis Bustamante - PeerSpot reviewer
STI Data Leader at grupo gtd
Real User
Top 5Leaderboard
2020-12-31T07:00:12Z
Dec 31, 2020

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.

JL
Senior Architect at a tech services company with 51-200 employees
MSP
Top 20
2020-12-28T16:02:54Z
Dec 28, 2020

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.

HG
Director Of Software Development at a healthcare company with 5,001-10,000 employees
Real User
2020-12-23T01:30:36Z
Dec 23, 2020

The architecture, including compute and storage, is good.

EI
Manager: Data Analytics at a consultancy with 1,001-5,000 employees
Real User
Top 5
2020-12-16T06:41:32Z
Dec 16, 2020

They are very reliable and cost-effective.

EI
Manager: Data Analytics at a consultancy with 1,001-5,000 employees
Real User
Top 5
2020-12-15T23:36:52Z
Dec 15, 2020

It's user-friendly and has a good dashboard.

AP
Data Architect at a tech services company with 51-200 employees
Real User
2020-11-26T21:01:19Z
Nov 26, 2020

The most important feature for me is the integration with PolyBase.

JT
Senior Project Manager at a tech company with 501-1,000 employees
Real User
Top 10
2020-11-20T10:07:03Z
Nov 20, 2020

The product is very user friendly.

SR
Co Founder & CTO at a manufacturing company with 1-10 employees
Real User
2020-10-19T09:33:00Z
Oct 19, 2020

Our primary use case is for gathering data and analytics. We provide insights into vehicle data. We gather millions of records per second and we have various millions of vehicles running across.

RP
Software Engineer at a educational organization with 501-1,000 employees
Real User
2020-10-11T08:58:07Z
Oct 11, 2020

I like its performance. It is well-structured and offers a lot of practical options. Because of the visual design of the product, it is very easy to find icons and other visual elements.

It took me more than two weeks to understand how it works. I had an intensive training session to understand it, which was enough. It was not hard to understand how it works.

JS
Information Architect with 201-500 employees
Real User
Top 20
2020-09-13T07:02:24Z
Sep 13, 2020

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.

Mukul Biswas - PeerSpot reviewer
Enterprise Solutions at Celebal Technologies
Real User
2020-09-10T07:35:43Z
Sep 10, 2020

They are available on the Cloud, and the platform is very intuitive.

RV
Director at Nihil Solutions
Real User
2020-08-24T05:54:00Z
Aug 24, 2020

The speed is great and the architecture is excellent.

Ankit Mittal - PeerSpot reviewer
Director of Data Analytics Practice at a computer software company with 501-1,000 employees
Real User
2020-08-02T08:16:00Z
Aug 2, 2020

The most valuable feature is performance gains.

SS
Sr. Teradata Consultant at a tech services company with 201-500 employees
Consultant
2020-07-29T07:45:56Z
Jul 29, 2020

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.

JS
Solution Principal at a computer software company with 5,001-10,000 employees
Real User
2020-07-12T11:48:49Z
Jul 12, 2020

The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs.

JS
Project Manager at a tech services company with 5,001-10,000 employees
Real User
2019-12-18T05:44:00Z
Dec 18, 2019

The most valuable feature of the solution is the analytics and that it can connect with Power BI.

AveekDas - PeerSpot reviewer
Analytics Engineer at a tech services company with 51-200 employees
Real User
2019-12-15T05:58:00Z
Dec 15, 2019

The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis.

PradeepPV - PeerSpot reviewer
Vice President Technologies at Excelencia
Real User
2019-12-12T07:48:00Z
Dec 12, 2019

Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to.

BeverlyTshifularo - PeerSpot reviewer
Senior Business Analyst: BI Team Lead at a logistics company with 1,001-5,000 employees
Real User
2019-12-12T07:48:00Z
Dec 12, 2019

The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.

JS
Practice Head BI at a tech vendor with 1,001-5,000 employees
MSP
2019-12-11T05:40:00Z
Dec 11, 2019

The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range.

MD
Managing Partner at a tech services company with 11-50 employees
Real User
2019-11-13T05:29:00Z
Nov 13, 2019

The most valuable feature is the scalability.

EK
Data Architect at a tech services company with 10,001+ employees
Real User
2019-11-13T05:28:00Z
Nov 13, 2019

The MPP (Massively Parallel Processing) architecture helps to make things a lot faster.

RR
Executive Board Member / General Manager at a comms service provider with 51-200 employees
Real User
2019-10-15T05:02:00Z
Oct 15, 2019

The initial setup was really easy and straightforward.

CK
Consultant at a tech services company with 51-200 employees
Consultant
2019-09-23T06:34:00Z
Sep 23, 2019

The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS.

it_user937602 - PeerSpot reviewer
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

Scaling this solution is easy and the uptime is okay.

Related Questions
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Nov 1, 2021
How does Amazon Redshift compare with Microsoft Azure Synapse Analytics? Which is better and why?
See 1 answer
Nov 1, 2021
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different databases. It scales very easily and has a good cost-benefit ratio. It is very powerful and performs well. The data processing is very fast and can do analytics on the fly. Amazon Redshift should have more cloud-native tools that integrate with it as Microsoft does with the Azure ecosystem. There is some missing functionality that can make Redshift difficult to work in. If you are analyzing a lot of data, the load performance-wise can be very low. Microsoft Azure Synapse Analytics can handle large amounts of data - in the petabyte range. You can scale up and down as much as you want. It has a pay-as-you-go protocol, so you only pay for what you use. The speed is very good and the architecture is excellent. You are in control of what you need, which is a huge advantage. Microsoft Azure Synapse Analytics can be a very complicated product to use. The setup can be very complex. We had some issues with dashboard reporting - we found there were bugs in the platform when dealing with specific types of queries. This solution did not meet the necessary security protocols for some of our clients. Conclusion Both of these solutions are very stable, scalable, and flexible. Each of these products has their own unique ecosystems that are very competitive with each other, making them both great solutions to use. Although they are very similar, there are some features and functionalities that make them unique and attractive depending on the type of enterprise you operate. We are a smaller enterprise and overall our team felt based on ease of use, support, and where we are headed, we have started to migrate everything over to an AWS ecosystem and chose Amazon Redshift. It is the solution our clients liked best as well.
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Sep 3, 2021
And why?
See 1 answer
NitinKumar - PeerSpot reviewer
Director of Enginnering at Sigmoid
Sep 3, 2021
If you are dealing with semi-structured data like json Snowflake has great support in handling and querying json data. it is also good to use as data lake and can act as one stop solution for a data lake and cloud data warehouse. query performance and low maintainability is also what makes snowflake a great choice.
Download Free Report
Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
DOWNLOAD NOW
656,862 professionals have used our research since 2012.