15 ans à aider les entreprises françaises
à choisir le meilleur logiciel

Avis clients sur Azure Synapse Analytics

En savoir plus sur Azure Synapse Analytics

Application web Data Warehouse avec fonctionnalité d'analyse SQL qui transforme les données de plusieurs sources en une base de données unique.

En savoir plus sur Azure Synapse Analytics

Avantages :

It has awesome data ingestion & preparation quality.

Inconvénients :

It is a very costly and less known service. It is least marketed product.

Azure Synapse Analytics - Notes

Note moyenne

Facilité d'utilisation
4,1
Service client
4,1
Fonctionnalités
4,3
Rapport qualité-prix
4,1

Probabilité de recommander le produit

7,7/10

Azure Synapse Analytics a reçu une note globale de 4,3 étoiles sur 5 d'après 32 avis d'utilisateurs publiés sur Capterra.

Avez-vous déjà utilisé Azure Synapse Analytics ?

Partagez vos expériences avec d'autres acheteurs de logiciels.

Filtrer les avis (32)

Shaunak
Shaunak
Data Platform Engineer (Inde)
Utilisateur LinkedIn vérifié
Services et technologies de l'information, 10 000+ employés
Temps d'utilisation du logiciel : plus d'un an
Source de l'avis

Awesome implementation of Data Warehouse and Apache Spark Capabilities!

5,0 l’année dernière

Commentaires : We are using Azure synapse to build out data pipelines. There are a lot of activities and templates available for no-code data movement setup. You can migrate from Databricks if you want.

Avantages :

Azure Synapse Analytics, according to me is very easy and convenient implementation of spark, SQL and data warehousing technologies.- You get notebooks to write ETL code and run it on distributed spark clusters.- Ingesting data to SQL pool is very easy.- Awesome and dedicated support via technical staff.- East US region now has Hardware Accelerated Spark Pools available for Deep Learning Capabilities. - All artifacts can easily be created via ARM templates.

Inconvénients :

There are no cons, but there are few difficulties that I have faced:1) In Pipelines, when notebook activities are being triggered it should have a flag that makes2) When a notebook job is submitted to spark pool, session takes too long time to be spin up. Can't they move it to Kubernetes instead of traditional VMs?

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Pétrole et énergies, 1 001–5 000 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Stable, cloud-based data warehouse service that continuously evolves

4,0 il y a 6 ans

Avantages :

Azure simplifies the creation, testing and management of cloud assets for us. It is relatively easy to use and offers full features for hosting web applications, websites, APIs, and a ton of others. It has good compatibility Windows and has been a fairly stable space in all the time we have worked with it. The ability to scale the services according to our needs is great especially for SME who may not have a physical office because we can eliminate the need to set-up physical servers. We can work from anywhere and access our files in the cloud which is very convenient.

Inconvénients :

For people who aren’t very big fans of Microsoft, working with this program might not be their cup of tea either. But for those who live and breathe Microsoft, this is sheer heaven. The sheer number of functions, services, apps make it hard to identify what the most effective solution is, but they try to compensate for this by coming up with pre-packaged solutions.

Joseph
Cashier (É.-U.)
Services aux consommateurs, 1 001–5 000 employés
Temps d'utilisation du logiciel : 1 à 5 mois
Source de l'avis

Azure Nightmare

2,0 il y a 2 ans

Commentaires : It wasn't the best I have dealt with better softwares in the past honestly

Avantages :

The match and merge was amazing and the data integration was really good as well

Inconvénients :

It was way too expensive for something that still had quite a few bugs in its software that needed worked out

Joseph
Joseph
Technical Project Manager (É.-U.)
Utilisateur LinkedIn vérifié
Entreposage, 201–500 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Azure SQL Data Warehouse

5,0 il y a 6 ans

Commentaires : Implementing a DW without the added cost and support issues of an on-site DW implementation.

Avantages :

As a cloud-based product, Azure SQl Data Warehouse is ready to go - no implementation headache. You can start to design your DW structure right away. Clear, easy to understand online instructions and a great user interface.

Inconvénients :

A bit of a learning curve understanding the Azure environment if you are not used to it.

Brent
Brent
Director Of Information Technology (É.-U.)
Utilisateur LinkedIn vérifié
Institutions religieuses, 11–50 employés
Temps d'utilisation du logiciel : plus d'un an
Source de l'avis

Easy cloud based SQL hosting

5,0 il y a 6 ans

Avantages :

We can spin up/down our SQL dbs and adjust their speed dynamically. It partners with Azure to offer other things like automation scripts to dynamically scale DB tiers as needed to save on costs.

Inconvénients :

You have to download a SQL studio to do any visual data editing. The DBs themselves are able to be adjusted up/down in speed or on/off or restored... but you can't edit data online apart from running a SQL command.

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Santé, bien-être et fitness, 501–1 000 employés
Temps d'utilisation du logiciel : 6 à 12 mois
Source de l'avis

Azure all in one

4,0 il y a 2 ans

Commentaires : It's a good all in one tool with all sql capabilities and we can use spark.

Avantages :

We can integrate a lot of service in single portal and access management is easy. We can use ADF also in this. It also supports git integration. Ability to see all the running queries and kill them is good.

Inconvénients :

Desktop software, which is SSMS is worst, web UI is so good but it gets refreshed so unsaved progress get erased, otherwise features are good.

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Logiciels, 501–1 000 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Good Data Mart solution in Azure

4,0 il y a 5 ans

Avantages :

1. Very easy to use 2. Good support 3. Useful for Big Data Marts

Inconvénients :

1. Features customization is little difficult 2. New features are rolling out slowly

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Services et technologies de l'information, 201–500 employés
Temps d'utilisation du logiciel : 6 à 12 mois
Source de l'avis

My take on Azure Synapse

4,0 l’année dernière

Commentaires : A nice analytics platform which is a tool or a service that does multiple work so we need not download external softwares or use other services for each of the task.

Avantages :

Nice for data analysis even when it is at a large scale. Synapse has good user and data management capabilities with indexes that can be defined to the data in the platform. Also it integrates seamlessly with GIT so we can access anything from it with the help of few commands. Data management at all levels are accessible be it the table level or schema level, can import large datasets from various sources like Data Factory, Power BI and various other sources.

Inconvénients :

Finding out and debugging errors can sometimes be clueless and takes a lot of time for the queries to run and execute at times.

Moises R.
Moises R.
Enc. Monitoreo y Computos (République dominicaine)
Utilisateur LinkedIn vérifié
Services financiers, 1 001–5 000 employés
Temps d'utilisation du logiciel : 6 à 12 mois
Source de l'avis

The importance of DWH

5,0 il y a 5 ans

Commentaires : We use it from Monday to Friday for all the company's strong reporting.

Avantages :

For each company, the DWH is extremely important and more so for the reporting of the areas of operations.

Inconvénients :

For this system I like everything, it helps us minimize the use of resources in the main systems, azure is the best.

Charles
Charles
Data engineer (Brésil)
Utilisateur LinkedIn vérifié
Services et technologies de l'information, 501–1 000 employés
Temps d'utilisation du logiciel : 6 à 12 mois
Source de l'avis

Create pipelines with a lot of features

5,0 l’année dernière

Avantages :

The screen is very functional and we can do a lot of activities like read data from external servers, use a linked server from premisses and much more.

Inconvénients :

The native database is limited to SQL Server.

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Biens de consommation, 501–1 000 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

Great tool for a great price that you can scale up or down as needed.

5,0 il y a 5 ans

Commentaires : Finest experience I've had with any Microsoft product. Best of all it is Virtual and you can shut it off and not pay for it any time you want.

Avantages :

The simple plug and play into your environment was well received. I also liked the ability to scale your DW units up or down as needed and even found a way to schedule it to save money during non-peak times.

Inconvénients :

While better at managing views, the storage speed was a little slower than a simple SQL DB. We ended up winding it down in favor of a standard SQL DB as the speed was better for our need.

Johan Andres
implementor (Colombie)
Logiciels, 11–50 employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

azure welcoming the future.

5,0 il y a 5 ans

Commentaires : I love it in general, when one hears Azure's name he gets scared, but he does not know how easy it is.

Avantages :

What I like most about this application is its ease of use, it is not that complicated and, due to my study, I must use it every day. It is very complete and I dare say that every day I learn new things and new features.

Inconvénients :

nothing is a very complete application, as I said every day I learned new things from her.

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Internet, 51–200 employés
Temps d'utilisation du logiciel : 6 à 12 mois
Source de l'avis

Clean and responsive tool

5,0 il y a 5 ans

Commentaires : Great tool for those used to clunky old software. It is clean and easy to work with. Responsive too.

Avantages :

To me Azure was a great alternative to other applications I used like SQL server. It feels more light weight and responsive. The interface is intuitive and you can do so much through shortcuts and the command pallet, however you never feel overwhelmed with features like SQL server sometimes do.

Inconvénients :

The setup process felt like a lot of steps I had to go through. At any given point I did not want to walk away due to the fact that i will loose all the work I have done. But it is generally easy to navigate and clear steps. So far i really like it.

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Services et technologies de l'information, 1 001–5 000 employés
Temps d'utilisation du logiciel : plus d'un an
Source de l'avis

Quickly moves data

5,0 il y a 5 ans

Commentaires : A good solid data warehouse. Quick analytical info at your fingertips.

Avantages :

We tend to write a lot of SQL queries and data in house. Having a way to quickly move this data from the source to an analytical store is key. Enter Azure...saving the day for us. Also gives us ability to control compute load. We can even pause it if needed.

Inconvénients :

I think they could make it a little easier to learn. It was slightly confusing when I first starting working with it years ago. Doesn't seem much has changed to make it more user friendly.

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Services et technologies de l'information, 1 001–5 000 employés
Temps d'utilisation du logiciel : 6 à 12 mois
Source de l'avis

Low Costs Data Mining

4,0 il y a 3 ans

Avantages :

To host the resources that create high costs when hosted within the company on the cloud, to process them and to reach the desired reports.

Inconvénients :

There is no negative side except that many data are outside the company due to its nature.

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Enseignement supérieur, 201–500 employés
Temps d'utilisation du logiciel : 6 à 12 mois
Source de l'avis

Very easy to use and to implement

4,0 il y a 6 ans

Commentaires : It is good for my part, because I used it to execute queries specially for our API.

Avantages :

This software have Great tools and great implementation support. I like this software's ability to make queries many times faster than SQL DB it also handle large volume data with massive storage and it has no storage limit.

Inconvénients :

Until now I don't experience any negative on using this software, but based on my research this software only support 32 concurrent connections and 1024 active connections. But still our company didn't reach this limit , so this software is still good for us.

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Hôpitaux et soins de santé, 201–500 employés
Temps d'utilisation du logiciel : 6 à 12 mois
Source de l'avis

Good data control and workload

5,0 il y a 5 ans

Commentaires : Microsoft SQL has allowed us to keep good track of all our information. In this way we have been able to keep a good track of our invoices and hours work every month. Whatever is your field of expertise, SQL will be able to help you

Avantages :

We have been able to set up SQL to work with Power BI and Power Apps. The data interchange goes smoothly and all our data can now be automated whatever we want it.

Inconvénients :

The set up for an SQL server is really important, and I think it would not be bad to make it a little more user friendly.

Amit
MS Systems Analyst (Inde)
Utilisateur LinkedIn vérifié
Logiciels
Temps d'utilisation du logiciel : 1 à 5 mois
Source de l'avis

High performing solution with security , a limited exposure though.

4,0 il y a 6 ans

Commentaires : We were able to mitigate issues that were arising from frequent requirement change and space constraints.

Avantages :

We moved to Azure when we were constantly struggling to maintain on premise hardware. It is so easy to scale out or scale up in Azure. Analytics can never be better than this.

Inconvénients :

Administrating process is little bit tedious and lengthy. plus it comes with lot of additional one time overhead owing to its limitations over traditional in house warehouse.

Prabhu
Prabhu
associate projects (Inde)
Utilisateur LinkedIn vérifié
Services et technologies de l'information, 10 000+ employés
Temps d'utilisation du logiciel : 1 à 5 mois
Source de l'avis

Thanks to massive parallel processing(MPP) architecture

5,0 il y a 4 ans

Commentaires : I have worked over 3 years in Microsoft native Sql server Data warehouse. I know how much difficulty to transfer the data to Data warehouse and also need to optimize the query for high throughput.
Now with help of Azure Synapse analytics it provides 10x speed than native data transfer and also with right implementation we able to provide high throughput and low latency to customers.

Avantages :

1. Efficient polybase architecture for massive parallel processing(MPP). 2. separate billing for storage and query transactions(DWU). 3. Manual and automatic pause for DWU when service not in use (helps to manage cost).

Inconvénients :

1. Need to decide proper monitoring and alert methods. 2. Need to Choose perfect partition key to implement the DW or else it will cost a lot of DWU. 3. Storing logs and analyse it will charge you an extra amount.

Mallikarjuna
Lead consultant (É.-U.)
Services et technologies de l'information, 10 000+ employés
Temps d'utilisation du logiciel : Essai gratuit
Source de l'avis

Review on Azure synapse analytics

5,0 il y a 3 ans

Commentaires : I would strongly recommend to use and explore your project needs

Avantages :

It’s translating detailed requirements into data structure that are scalable,resilient and sustainable.Also it’s very ticketing process

Inconvénients :

It’s very flexible to analysis of existing reports and key performance indicators also very flexible for data mining needs

Jason
Jason
Supervisor (É.-U.)
Utilisateur LinkedIn vérifié
Santé, bien-être et fitness, 10 000+ employés
Temps d'utilisation du logiciel : 6 à 12 mois
Source de l'avis

Data freedom

3,0 il y a 4 ans

Commentaires : overall i think its a great platform and they put a lot of energy into it

Avantages :

Azure allows us great access to our data. it allows us to make decisions with accuracy and knowing that what we are seeing is accurate

Inconvénients :

i think they need to improve the UI of the product. it allows us to get the data but takes time and patience

Chris
Chris
owner (É.-U.)
Utilisateur LinkedIn vérifié
Immobilier, 2–10 employés
Temps d'utilisation du logiciel : plus d'un an
Source de l'avis

More people using

5,0 il y a 4 ans

Commentaires : We couldn't have completed our task without it. Very helpful!

Avantages :

This software from Microsoft does not disappoint like most of its other software. I had used it in my last larger business that has since been sold, but is still in use today with that team.

Inconvénients :

I never noticed anything that stood out, but you are the type of person that knows more about computers than the average Joe if you are using this.

Ryan
Developer (É.-U.)
Logiciels, 51–200 employés
Temps d'utilisation du logiciel : 1 à 5 mois
Source de l'avis

Excellent DBaaS solution for businesses

5,0 il y a 5 ans

Avantages :

Incredibly robust features set; easy to use; includes machine learning capabilities

Inconvénients :

Best for structured data but cube database was tough to work with

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Marketing et publicité, 51–200 employés
Temps d'utilisation du logiciel : 1 à 5 mois
Source de l'avis

MS Azure SQL Server DW

3,0 il y a 6 ans

Avantages :

Don't have to setup an infrastructure to use it.

Inconvénients :

There are not options to pick other database engines...you can only do MS-SQL

Utilisateur vérifié
Utilisateur LinkedIn vérifié
Services et technologies de l'information, 10 000+ employés
Temps d'utilisation du logiciel : plus de deux ans
Source de l'avis

SQL Data Warehouse

5,0 il y a 5 ans

Avantages :

Easy to scale and store data. Provides most of the functionality as the normal MSSQL value.

Inconvénients :

Could have better indexing functionality.