Wir helfen Unternehmen in Deutschland
seit 15 Jahren bei der Softwareauswahl

Azure Synapse Analytics Erfahrungen

Über Azure Synapse Analytics

Webbasierte Data-Warehouse-Anwendung mit SQL-Analytics-Funktionalität, die Daten aus mehreren Quellen in einer Datenbank erfasst.

Erfahre mehr über Azure Synapse Analytics

Vorteile:

It has awesome data ingestion & preparation quality.

Nachteile:

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

Bewertungen zu Azure Synapse Analytics

Durchschnittliche Bewertung

Benutzerfreundlichkeit
4,1
Kundenservice
4,1
Funktionen
4,3
Preis-Leistungs-Verhältnis
4,1

Weiterempfehlungsquote

7,7/10

Azure Synapse Analytics hat eine Gesamtbewertung von 4,3 von 5 Sternen basierend auf 32 Nutzerbewertungen auf Capterra.

Hast du Azure Synapse Analytics bereits verwendet?

Teile deine Erfahrungen mit anderen Softwareinteressenten.

Nutzerbewertungen filtern (32)

Shaunak
Shaunak
Data Platform Engineer in Indien
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Awesome implementation of Data Warehouse and Apache Spark Capabilities!

5,0 letztes Jahr

Kommentare: 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.

Vorteile:

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.

Nachteile:

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?

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Öl & Energie, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Stable, cloud-based data warehouse service that continuously evolves

4,0 vor 6 Jahren

Vorteile:

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.

Nachteile:

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 in USA
Verbraucherdienste, 1.001–5.000 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Azure Nightmare

2,0 vor 2 Jahren

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

Vorteile:

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

Nachteile:

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 in USA
Verifizierter Nutzer auf LinkedIn
Lagerung, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Azure SQL Data Warehouse

5,0 vor 6 Jahren

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

Vorteile:

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.

Nachteile:

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

Brent
Brent
Director Of Information Technology in USA
Verifizierter Nutzer auf LinkedIn
Religiöse Einrichtungen, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Easy cloud based SQL hosting

5,0 vor 6 Jahren

Vorteile:

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.

Nachteile:

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Gesundheit, Wellness & Fitness, 501–1.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Azure all in one

4,0 vor 2 Jahren

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

Vorteile:

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.

Nachteile:

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Computer-Software, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Good Data Mart solution in Azure

4,0 vor 5 Jahren

Vorteile:

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

Nachteile:

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 201–500 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

My take on Azure Synapse

4,0 letztes Jahr

Kommentare: 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.

Vorteile:

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.

Nachteile:

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 in Dominikanische Republik
Verifizierter Nutzer auf LinkedIn
Finanzdienstleistungen, 1.001–5.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

The importance of DWH

5,0 vor 5 Jahren

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

Vorteile:

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

Nachteile:

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 in Brasilien
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 501–1.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Create pipelines with a lot of features

5,0 letztes Jahr

Vorteile:

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.

Nachteile:

The native database is limited to SQL Server.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Konsumgüter, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

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

5,0 vor 5 Jahren

Kommentare: 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.

Vorteile:

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.

Nachteile:

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 in Kolumbien
Computer-Software, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

azure welcoming the future.

5,0 vor 5 Jahren

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

Vorteile:

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.

Nachteile:

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Internet, 51–200 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Clean and responsive tool

5,0 vor 5 Jahren

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

Vorteile:

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.

Nachteile:

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Quickly moves data

5,0 vor 5 Jahren

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

Vorteile:

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.

Nachteile:

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 1.001–5.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Low Costs Data Mining

4,0 vor 3 Jahren

Vorteile:

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.

Nachteile:

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Hochschulbildung, 201–500 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Very easy to use and to implement

4,0 vor 6 Jahren

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

Vorteile:

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.

Nachteile:

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Krankenhausversorgung & Gesundheitswesen, 201–500 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Good data control and workload

5,0 vor 5 Jahren

Kommentare: 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

Vorteile:

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.

Nachteile:

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 in Indien
Verifizierter Nutzer auf LinkedIn
Computer-Software
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

High performing solution with security , a limited exposure though.

4,0 vor 6 Jahren

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

Vorteile:

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.

Nachteile:

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 in Indien
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 10.000+ Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Thanks to massive parallel processing(MPP) architecture

5,0 vor 4 Jahren

Kommentare: 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.

Vorteile:

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).

Nachteile:

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 in USA
Informationstechnologie & -dienste, 10.000+ Mitarbeiter
Verwendete die Software für: Kostenlose Testversion
Herkunft der Bewertung

Review on Azure synapse analytics

5,0 vor 3 Jahren

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

Vorteile:

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

Nachteile:

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

Jason
Jason
Supervisor in USA
Verifizierter Nutzer auf LinkedIn
Gesundheit, Wellness & Fitness, 10.000+ Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Data freedom

3,0 vor 4 Jahren

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

Vorteile:

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

Nachteile:

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 in USA
Verifizierter Nutzer auf LinkedIn
Immobilien, 2–10 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

More people using

5,0 vor 4 Jahren

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

Vorteile:

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.

Nachteile:

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 in USA
Computer-Software, 51–200 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Excellent DBaaS solution for businesses

5,0 vor 5 Jahren

Vorteile:

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

Nachteile:

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Marketing & Werbung, 51–200 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

MS Azure SQL Server DW

3,0 vor 6 Jahren

Vorteile:

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

Nachteile:

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

SQL Data Warehouse

5,0 vor 5 Jahren

Vorteile:

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

Nachteile:

Could have better indexing functionality.