Microsoft Azure Synapse Analytics Other Advice

Sunil Gidwani - PeerSpot reviewer
Cloud Solution Development Manager at Stryker Corporation

I rate Azure Synapse Analytics eight out of 10. No competitors provide the entire solution to one place like Synapse. For example, a database just focuses moving and manipulating data, etc. But Synapse is like an all-inclusive workspace. 

I advise other people to go with Databricks Notebook if you need a computation engine. It has a solid SQL storage procedure. 

Suppose you are dealing with complex transformation logic and manipulation of run-time data flows. In that case, it's better to use Databricks than any Microsoft ADF. DataBricks looks more promising in terms of computing in memory, so we integrated Databricks in Synapse.

View full review »
ShubhamSharma2 - PeerSpot reviewer
Project Trainee at Neal Analytics

It is easy to migrate data to the solution from other clouds, even for big organizations. A complete migration can be done in less than ten hours.  

The solution is better than other cloud platforms so I recommend it. 

I rate the solution a nine out of ten. 

View full review »
AT
Senior Director/ Advisory Architect at a tech vendor with 10,001+ employees

We are Microsoft partners. 

Potential customers should check out the ease of management. This solution is easier to maintain compared toother options. 

I'd rate the solution seven out of ten. There are some challenges related to this replication and then there is quite a lot of design thinking to be done.

View full review »
Buyer's Guide
Microsoft Azure Synapse Analytics
April 2024
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,065 professionals have used our research since 2012.
Herb Heltzel - PeerSpot reviewer
Data Solutions Architect at King County Gov

I am generally very satisfied with it. So, I would definitely recommend it.

I would rate it a nine out of ten.

View full review »
Matthew Spieth - PeerSpot reviewer
Senior Database Administrator at Summa Health System

My advice to those wanting to use this solution is to start small to get an understanding of how it operates.

I rate Microsoft Azure Synapse Analytics a nine out of ten.

View full review »
KS
Technical Manager at LTIMINDTREE

Many customers prefer using Microsoft Azure Synapse Analytics. It allows them to develop applications in Java and .NET. It provides security, flexibility, and efficient UI as well. It enables the ease of configuring APIs and overall configurability. As a certified cloud specialist, I advise others to consider use cases and requirements while purchasing.

I rate the product an eight out of ten.

View full review »
Debashish  Saha - PeerSpot reviewer
Technical Lead at Linde

There is a need to analyze the business objectives and technical needs before making a decision. If Synapse aligns with your business goals and meets your data warehousing requirements, you can proceed. Additionally, it's advisable to conduct price and scalability assessments and perhaps carry out a small proof of concept (POC) using production data before making a final decision.

I would rate the solution an eight out of ten.

View full review »
Peter Aderoju - PeerSpot reviewer
Student at University of Derby

It's about how it integrates into your work. If it's easy to integrate into your workflow, then I'd recommend it. It's quite easy to use, scalable, and has good processing time. Those are the major things for me. It's easy to use, scalable, and integrates well, then it's a good choice.  

Overall, I would rate the solution an eight out of ten.

View full review »
VarunJoshi - PeerSpot reviewer
Senior manager at Accenture

I'd recommend this solution to other users. 

I'd rate the solution eight out of ten.

View full review »
Ibrahim_Rasras - PeerSpot reviewer
Senior lead Enterprise Designer Architect at a government with 10,001+ employees

Overall, I would rate the solution a nine out of ten. 

View full review »
SS
Business Architect at YASH Technologies

There is going to be competition in the market with the release of SAP Cloud Analytics.

The solution does not require maintenance because it is sized-based.

I would recommend this solution to others. I have evaluated the fact sheet on the solution.

I rate Microsoft Azure Synapse Analytics an eight out of ten.

View full review »
VK
General Manager at itcinfotech

While we do not have a business relationship with Azure, we are trying to become partners. 

Most of our implementations happen on Azure itself. Wherever we go, we take the solutions and we go to the other customers and we propose them. We tend to recommend this solution.

I'd rate the solution seven out of ten. There is a scope for improvement. Eventually, as they come across different case by case, they'll enhance things. Currently, what I see here is the data governance part is missing here from a development life cycle point of view.

View full review »
Ashwin Baatjes - PeerSpot reviewer
Cloud Architect at Astute - The Financial Services Exchange

I rate Azure Synapse Analytics eight out of 10. I would recommend Synapse depending on the needs you're trying to address. You need to properly build out your users and see that the technology is going to address your use case. After that, you can make an informed decision about what's best for your company. 

Companies come in all shapes and sizes. Synapse may not be a good fit for one company, but it can work well for others. Try it out first and see if it's appropriate for you.

View full review »
SeshagiriSriram - PeerSpot reviewer
Head IT Architecture at a tech vendor with 11-50 employees

We have four DevOp engineers that do the maintenance of the solution.

If your data models are not accurate, and if you are not well-versed in data transformation and model security, the process will be extremely challenging. Thorough planning is essential for the data to be properly managed. You cannot simply execute or implement the process by reading about it. A significant amount of planning is required, including how the data flows will access the data, data security measures, data flow processes, and transformation requirements. All of these aspects must be carefully examined and planned beforehand to avoid complications later on.

I rate Microsoft Azure Synapse Analytics a ten out of ten.

View full review »
AA
Infrastructure Architect at a hospitality company with 1,001-5,000 employees

This is the first solution that we are trying out. But if we plan to compare it with another solution called Snowflake, it will open up more dimensions for our thoughts to work. 

However, based on what we have achieved so far, I can rate it as an eight out of ten overall.

View full review »
BS
Global IT Solution Architect at Campari Group

I would recommend using Microsoft Azure Synapse Analytics because it includes everything from integration to transformation and storage.

Overall, I would rate the solution an eight out of ten.

View full review »
RP
Senior Specialist at a comms service provider with 10,001+ employees

I rate the solution an eight out of ten. 

View full review »
Muralidharan Lakshmanachar - PeerSpot reviewer
Director at Capgemini

I'd give Synapse Analytics a rating of seven out of ten.

View full review »
JoseArguello - PeerSpot reviewer
Data Engineer at a manufacturing company with 10,001+ employees

We buy direct from Microsoft. Our company may be partners with them.

As Microsoft Azure Cloud, it only has one version. I don't know if there is a version number. 

I would advise users to start loading the data beforehand and understand very well how the tool works and how it's useful. That way, you can evaluate the best solution. Sometimes you need to start to load data and review all the alternatives in the solution.

I’d rate the solution a nine out of ten.

View full review »
PedroNavarro - PeerSpot reviewer
BI Development & Validation Manager at JT International SA

I would recommend others to use this product but urge them to understand that it is more of a technical database used to prepare data as opposed to serving it.

I would rate this solution a seven out of ten.

View full review »
Mukund Mishra - PeerSpot reviewer
Sr. Technology Architect at a tech services company with 10,001+ employees

I'm an architect and I'm using Microsoft Azure Synapse Analytics, and apart from that solution, I'm also using other types such as Big Data, AIML, SPARK, and Scala. I'm also into other languages and reporting services.

I'm using the solution for my clients. Currently, I'm using it for clients, particularly Netherland-based banking institutions that have a cloud setup on Azure, but the deployment is now hybrid because of an ongoing migration. It's not completely migrated yet, so there's still something left in the data center. The clients have an ongoing migration from Hadoop and SD inSITE as well, which would be moved completely to Azure Cloud, so as of now, the deployment of Microsoft Azure Synapse Analytics is still hybrid.

My rating for Microsoft Azure Synapse Analytics is seven out of ten as it combines many different features that you can use, so it's a good solution, and in the future, I'm expecting it to be better and better.

Several teams use Microsoft Azure Synapse Analytics, but then in my team, around twenty-five people use it, but that's not the complete number of users. Many people use the solution, with different features being used.

I don't see a product comparable to Microsoft Azure Synapse Analytics that's available on the cloud. Currently, there's no comparison, so you can't say whether it's good or bad, though room for improvement in any product will always be there. Based on all the features of Microsoft Azure Synapse Analytics, my rating for it is seven out of ten, at the moment, there's no competition for the solution because I've not come across any other tool that's comparable to Microsoft Azure Synapse Analytics.

View full review »
HV
Data Engineer at a financial services firm with 1-10 employees

It is important to have skilled Azure data engineers to manage the solution. 

I rate the solution an eight out of ten. The solution could improve its rating with an easier setup and more readily-available data connectors. 

View full review »
AB
Architect at a tech vendor with 10,001+ employees

My advice to others is to start with a reserved instance in order to test the waters and make sure it fits their needs before fully committing to using the solution. If, after experimentation, they decide to proceed with using Microsoft Azure Synapse Analytic over its competitors, then I would highly recommend going for a reserved instance to make the most cost-effective and efficient choice.

I rate Microsoft Azure Synapse Analytics an eight out of ten.

View full review »
RM
Head of Business Integration and Architecture at Jakala

Once a service is managed as a service in a cloud platform, the maintenance is very easy. You have to monitor it, but the maintenance infrastructure is extremely easy.

This solution is very easy once you have a Microsoft Azure subscription to go straight to Microsoft Azure Synapse Analytics because it's native. However, there are other kinds of technologies one can use. I would suggest before using this solution, look at other solutions, such as Databricks or Snowflake, and not stop at the first solution that you can receive in Microsoft Azure.

I rate Microsoft Azure Synapse Analytics an eight out of ten.

View full review »
Pankaj Rathod - PeerSpot reviewer
Data Architect at a retailer with 1,001-5,000 employees

I give the solution a nine out of ten.

Depending on the organization's use case, there are multiple options available. For example, if the workload is medium, there are different products available such as Azure SQL Database for small or medium-sized data, and Azure Synapse Analytics for extremely large volumes of data. Ultimately, it is the use case of the organization that will determine the need for these particular services.

View full review »
MandarGarge - PeerSpot reviewer
V.P. Digital Transformation at e-Zest Solutions

We have approximately 20-25 team members with knowledge of Azure Synapse service capabilities. 

With regards to deployment and maintenance, an Azure Synapse based solution may need anywhere between 3-15 people. This depends on what type of warehouse and analytics you want to create, the number of reports and visualization. Typically a small team size would be of 3-4 people and a large team size would be of around 12-14 members.

View full review »
Erick Oliveira Da Silva - PeerSpot reviewer
Senior Data Engineer at a tech company with 201-500 employees

On a scale from one to ten, I would rate Microsoft Azure Synapse Analytics at eight.

View full review »
Mithun Thirisseri - PeerSpot reviewer
IT Solutions Architect at a financial services firm with 10,001+ employees

My advice to others is this solution is not meant for small databases.

I rate Microsoft Azure Synapse Analytics an eight out of ten.

View full review »
YP
Senior Manager, Global Network Development at a comms service provider with 10,001+ employees

It has been good so far. I'd recommend it to others. I'd rate it an eight out of ten.

View full review »
SR
Vice President of Data Practice at a computer software company with 5,001-10,000 employees

I'd rate the solution seven out of ten. 

View full review »
HarishAjjarapu - PeerSpot reviewer
Associate Director at a tech services company with 10,001+ employees

Be sure to be clear about the ideal pipeline for Synapse, differentiate your needs, and validate based on use-case.

I would rate this solution a six out of ten overall.

View full review »
DE
Linux Platform System Administrator at a healthcare company with 10,001+ employees

The entire Microsoft Azure ecosystem is well connected and Microsoft has done well with the features.

My advice to others is to try out the solution, do your homework and research, and set up a POC environment.

I rate Microsoft Azure Synapse Analytics an eight out of ten.

View full review »
BS
Founder and Managing Director at a tech services company with 1-10 employees

My advice to others is they should leverage other Azure components if they can. If they are looking for an integrated solution that's easy to use, they should look at competitors.

I rate Microsoft Azure Synapse Analytics an eight out of ten.

View full review »
AB
STI Data Leader at grupo gtd

There is always room for improvement with Azure Synapse Analytics, but for our use cases it works very well. 

I would rate Microsoft Azure Synapse Analytics a seven out of ten.

View full review »
Kundan Amin - PeerSpot reviewer
Senior Consultant at Dynamic Elements AS

It's important to understand your business needs and choose an appropriate solution based on the industry you work in and what needs to be achieved. There are a lot of tools available on the market, it's important to get the right one. 

I rate this solution eight out of 10.

View full review »
Salam Romim - PeerSpot reviewer
Senior Intelligent Software Research & Development Engineer at Orange Innovation Egypt

Microsoft is a good platform because it's compatible with data warehouse, power analytics, and visualization, and you now have excellent machine learning and AI tools like GPT-4. The platform is also very stable, and support can be migrated for software.

I rate Microsoft Azure Synapse Analytics a ten out of ten.

View full review »
Alekhya  Golla - PeerSpot reviewer
Senior Software Engineer at a computer software company with 501-1,000 employees

I would give Synapse Analytics a rating of nine out of ten.

View full review »
NT
Senior Systems Analyst at a non-profit with 201-500 employees

It is beneficial to always plan exactly what the main aims are and then choose the solution that can do it. If you want something quick, I set something up without any knowledge with Azure in three weeks. Once you get going, everything will be at your fingertips.

I rate Microsoft Azure Synapse Analytics an eight out of ten.

View full review »
AM
Enterprise Solutions Architect at a consultancy with 1-10 employees

On a scale from one to ten, I would rate Microsoft Azure Synapse Analytics at seven. Other solutions have more user-friendly and intuitive interfaces.

View full review »
AB
STI Data Leader at grupo gtd

We are both partners and end-users of the product. We use it internally and we use it with some of our clients.

I would caution new users that there is one parameter they need to watch carefully. That is the size of the data warehouse. If you don't configure this parameter to be as small as possible, your costs will be quite high.

I would rate the solution at a seven out of ten. It's a stable platform, however, the price model is questionable in comparison to Amazon and Google and the contact with support is a problem for me. 

View full review »
Dhruv Singh - PeerSpot reviewer
Senior Architect (Data and AI) at a tech services company with 1,001-5,000 employees

I rate the solution an eight out of ten. 

View full review »
RG
Azure Data Specialist at a financial services firm with 5,001-10,000 employees

I think Synapse Analytics is definitely better than the traditional high solution data solutions that we've previously used. It's definitely worth considering and I haven't come across anything negative, only advantages for now.

I would rate this solution an eight out of 10. 

View full review »
JS
Information Architect at a analyst firm with 201-500 employees

Clients will look at Pro Dell Compare. They use the tool to determine how simple it is or how complicated it will be to move their data. They consider whether they need to make use of one of Microsoft's partners to have them help, or can they do it themselves, and they determine how risky it is along with how simple it will be. Will they have enough manpower, and whether or not they're going to have to hire external consultants to help them. They also consider whether they are going to move their applications or are they going to wait? and what's going to come first. They create a plan.

You want your onsite team to look at, our use cases, look at what we're getting back for information, and then problem-solve. Think about any additional questions, and is this really feasible, because it's not free. You can start out using it for free for a short amount of time.

Microsoft is improving and as they grow, I see that they are pushing towards the enterprise. If you don't quite fit, then you are pushed into it whether you are ready or not.

You really have to consider where you want to be and what you are currently doing.

Anyone looking to use Microsoft Azure SQL Data Warehouse, I would advise them to do the research, hire an architect, screen them well, and know their background to ensure that they are going to provide a service for you. Have them work alongside the project manager to identify the resources and what needs to take place and build a plan.

I would rate this solution a nine out of ten.

View full review »
JS
Solution Principal at a computer software company with 5,001-10,000 employees

The Azure SQL Data Warehouse has been renamed to Synapse, although not all of the features have been implemented yet. I am looking forward to a more mature version of this product in the future.

I would rate this solution a seven out of ten.

View full review »
MT
CHTO at Timp-iT

My advice to those wanting to implement this solution would be to "Think big and act small." See what is up ahead. One of the organizations that I am working for, the big picture is population health management. We are not going to start with that, we are going to start to improve one small process, which is a cumbersome process that is been difficult for many years. That is the process that we are going to make transparent towards the organization, to see where the bottlenecks could be or are, and improve that process. 

We want the user experience to improve and that the amount of time you can save is monitored, which can be used for other care processes. Start with a cumbersome problem, resolve them first. You can actually tell within the organization, if the solution is already working, not on the larger scale, but on the small scale. Once you start seeing these results move on to the next problem.

The solution is secure. However, the organization has to be aware that if you use the security by default, the security is there. It has security by design. It is not the optimal security, I would always recommend that organizations use multi-factor authentication for an additional security layer. Additionally, if possible, have a next-generation firewall within their network in use or, if not, start implementing that if they are planning to move forward into an outsource Azure platform-based eco landscape.

I rate Microsoft Azure Synapse Analytics an eight out of ten.

View full review »
HF
Data engineer at Inicon S.r.l.

Synapse is useful for very big loads of data. 

I would rate this solution a seven out of ten. 

View full review »
JL
Senior Architect at a tech services company with 51-200 employees

I would recommend this solution to others who are interested in using it.

I think it's definitely something that they should consider. It's come a long way from where it started. 

It's just finished out a public preview and it's great if you're looking to combine a lot of tools into one and you're running a smaller shop. I think it's a great tool.

I would rate this solution a seven out of ten.

View full review »
MD
Managing Partner at a tech services company with 11-50 employees

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.

View full review »
EK
Data Architect at a tech services company with 10,001+ employees

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.

View full review »
SA
Lead Architect at a financial services firm with 10,001+ employees

I rate Microsoft Azure Synapse Analytics a seven out of ten. It is a fantastic product; we are satisfied with its features and performance. However, there could be more information available about the platform.

View full review »
CG
BI Consultant at a tech services company with 11-50 employees

I would recommend this solution to others. The client that I am working for, their preferred database is Synapse.

I rate Microsoft Azure Synapse Analytics a seven out of ten.

View full review »
VP
Sr. Principal, Vice President - Digital Transformation & Strategic Pursuits Leader at a tech services company with 10,001+ employees

We're just customers and end-users. My company does not have any relationship. It's our client who has a relationship with Microsoft.

I'm not sure which version we are using, however, I would guess it is the latest version. I'm not 100% sure.

Since the solution is still new to me, and I am having issues with performance, it's too early to say if I would recommend the solution to other users or companies. 

I'd rate the solution at an eight out of ten.

View full review »
AP
Data Architect at a tech services company with 51-200 employees

The suitability of this product really depends on the use case. It is good if your company is using only Microsoft products and you don't want to use another stack. If you want to use other platforms then you should consider Snowflake, which is also deployed on Azure. It really depends on what it is that you need.

I would rate this solution an eight out of ten.

View full review »
Mullai Selvan - PeerSpot reviewer
Project Manager at MAQ Software

We're just end-users and customers. We don't have a business relationship with the organization.

We're using the latest version of the solution right now.

I'd recommend the solution to other organizations.

I'd rate the solution at a nine out of ten.

View full review »
IH
Advisory Software Engineer at a tech services company with 1,001-5,000 employees

At this point, Synapse Analytics is fulfilling all of our requirements for the use cases that we have.

I would rate this solution a seven out of ten.

View full review »
JM
Practice Director at a tech services company with 51-200 employees

I don't use it personally, as I'm a consultant. However, if I implement it for clients, I do use it.

I'd rate the solution at a seven out of ten. There's still some work that needs to be done on the product that can make it a lot better.

I would recommend the solution to a company if they were a Microsoft shop. In that case, it's the obvious thing for them to do and it's a good choice.

View full review »
EI
Manager: Data Analytics at a consultancy with 1,001-5,000 employees

I highly recommend this solution to others, and we recommend it to our clients.

Overall, it's exceptionally good.

I would rate this solution a nine out of ten.

View full review »
EI
Manager: Data Analytics at a consultancy with 1,001-5,000 employees

I would highly recommend this solution to others who are interested in using it. We recommend it to our clients.

It's exceptionally good, and our clients and other partners find it both stable and scalable.

I would rate this solution a nine out of ten.

View full review »
SS
Sr. Teradata Consultant at a tech services company with 201-500 employees

We're a Microsoft partner.

I have experience with the Microsoft Cloud Data Warehouse specifically within the Unix cloud environment.

We're using the latest version of the solution.

It's important for organizations considering the solution to consider their business requirements and expectations. They need to be clear about what type of cloud solution they are looking for. We help our clients do this and interview them to find out what their needs are so that the best platform can be chosen for them. It may be Azure. It may be Snowflake. It depends on the company's needs.

At the end of the day, the customer will always want the best possible pricing. They'll typically ask how they can save money but have high throughput or more input with less price. If that's the case, Microsoft may be the perfect solution.

I'd rate the solution eight out of ten.

View full review »
AD
Analytics Engineer at a tech services company with 51-200 employees

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.

View full review »
VY
Chief Data Architect - Europe at a computer software company with 10,001+ employees

There are many available versions of Azure Synapse, such as Azure Synapse SQL Datawarehouse, Azure Synapse Analytics, and Azure Synapse Analytics workspace. You need to be aware of the features that you are looking for and accordingly choose the offering.

I would rate it a five out of 10.

View full review »
EB
Data Warehouse Architect and Developer at a wholesaler/distributor with 51-200 employees

I rate Microsoft Azure Synapse Analytics a nine out of ten.

View full review »
NN
Data Architect at a insurance company with 1,001-5,000 employees

We are using the latest version of the solution.

I would rate the solution at an eight out of ten.

I would recommend Synapse, however, it depends on which industry an organization is working in. It can be complex, and often, you have to choose between several tools. They're all able to do the same job, they're just more industry-specific in some cases. 

If you want to transform your data, you can choose between the database, data factory, and SQL, and even other tools.

This means it is very flexible, however, it also makes it difficult to administer. It's not that one of these sources is harder per se. It's more about what is the best for the job. Sometimes you create something and it doesn't perform and you have to start from scratch.

View full review »
ML
Managing Director at a consultancy with 1-10 employees

I'm just an end-user and customer.

I'd rate the solution at a seven out of ten.

I'd rate them higher if they could make it more user-friendly in terms of those more sophisticated capabilities that the system offers. Also, the training requires long hours. That's something difficult to organize when people have to be allocated to specific training sessions, instead of being on the projects. There's a kind of complex way of balancing the possibility of some people using the more sophisticated solutions and getting trained. 

View full review »
HG
Director Of Software Development at a healthcare company with 5,001-10,000 employees

I would rate this solution an eight out of ten.

View full review »
RP
Software Engineer at a educational organization with 501-1,000 employees

It is a powerful asset if we can use it and learn more about it. If Microsoft can give some free training sessions for students and amateurs, it would be helpful in knowing more about this product from inside. 

I would rate Microsoft Azure SQL Data Warehouse an eight out of ten.

View full review »
JS
Project Manager at a tech services company with 5,001-10,000 employees

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.

View full review »
DR
Director, Consulting, Technology Services at a financial services firm with 1,001-5,000 employees

For working with Synapse, you need to have an understanding and knowledge of the product to take full advantage of it. Synapse has a lot of features in terms of scalability, such as resource management, distribution, and partitioning. There are a lot of things that you need to consider when you go for it. It is not a simple database that you put in there, and it is running itself. 

I would rate Microsoft Azure Synapse Analytics a seven out of ten.

View full review »
AM
Director of Data Analytics Practice at a computer software company with 501-1,000 employees

My advice would be to move your on-premises data warehouse to the cloud. Move it there faster, as you can get more performance gains and it's also a robust infrastructure.

I would rate this solution an eight out of ten.

View full review »
SZ
Data Platform Architect at APN Promise

One of the main pros of Synapse is the ability to work with the classic data warehouse and the big data. Another is the ability to use the Spark engine for preparation. Before implementing this product, consider whether it will provide the results you want. If you are already using Microsoft products, Synapse is easy to integrate. I would score this solution as eight out of ten.

View full review »
AS
Enterprise architect at a computer software company with 201-500 employees

I rate this solution a nine out of 10. 

View full review »
MB
Enterprise Solutions at Celebal Technologies

We use the serverless platform as a service, that is only available with Microsoft Azure.

You don't have to hire experienced engineers to set up and implement the solution, saving you money, because it is very intuitive and the turnaround time is very low compared to other data warehouses. I would put it in par with solutions such as Redshift and BigQuery.

It's very modern, easy, and intuitive.

Most of the services are cheaper than other vendors.

This definitely falls into one of the top three or top four solutions and platforms in the world. I would definitely recommend it. If someone should ask me if they should use Microsoft Azure SQL Data Warehouse, I would say yes.

Personally, I don't see one great solution that exceeds in all aspects. Every solution has some good points and I think they have very beautifully found their strength and they're building upon it.

When asked what would best suit me, I would assess their environment requirements and could easily recommend any of the top four, being AWS Redshift, Google, Big Query, and Microsoft Azure.

I would rate this solution an eight out of ten.

View full review »
SN
President at a tech company with self employed

This is the only product I've ever used, as such, it's extremely difficult for me to say anything about it. For example, if I needed a bike, and now I have one and am riding it. If you ask me some questions, it's difficult for me to say, "Oh, I really missed this one on my first bike," unless I've ridden a few bikes. I'm not sure why everything is the way it is. I had a need, and I'm only using it now.

I'm trying to understand what else is out there and how it compares to what is out there.

I am able to use it. If I am able to use it, I would rate Microsoft Azure Synapse Analytics an eight out of ten.

View full review »
JT
Senior Project Manager at a tech company with 501-1,000 employees

I'd recommend the solution to other organizations. If they have time, I would suggest a company spends more effort looking at some different offerings. That said, generally, if you don't have a whole lot of money to do something, it's a decent option.

We haven't used the solution for too long, however, it's offered us everything we need in terms of features and capabilities. On a scale from one to ten, I'd rate it at an eight.

View full review »
PP
Vice President Technologies at Excelencia

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.

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

I would recommend this solution to others.

I rate Microsoft Azure Synapse Analytics a nine out of ten.

View full review »
JS
Practice Head BI at a tech vendor with 1,001-5,000 employees

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.

View full review »
RV
Director at Nihil Solutions

I would recommend this solution to other enterprises.

On a scale from one to ten, I would give this solution a rating of seven.

View full review »
it_user937602 - PeerSpot reviewer
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees

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.

View full review »
SR
Co Founder & CTO at a manufacturing company with 1-10 employees

I would rate Microsoft Azure SQL Data Warehouse a nine out of ten. 

View full review »
SB
Co-owner, Director at a tech services company with 1-10 employees

I would rate Microsoft Azure Synapse Analytics a nine out of ten.

View full review »
CK
Consultant at a non-profit with 11-50 employees

I would rate it a seven out of ten. 

View full review »
RR
Executive Board Member / General Manager at a comms service provider with 51-200 employees

I will rate this solution an eight out of ten. Not a ten due to the lack of integration.

View full review »
Buyer's Guide
Microsoft Azure Synapse Analytics
April 2024
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,065 professionals have used our research since 2012.