Azure Synapse Analytics

"Azure SQL Data Warehouse"

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.

"Stable, cloud-based data warehouse service that continuously evolves"

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.

"Continue connection"

Kommentare: the application offers many options and these options are very useful

Vorteile: This application has more options than other applications and its schemes are more lively

Nachteile: connection speed is fast but may pause after connecting

"Data freedom"

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

"Thanks to massive parallel processing(MPP) architecture"

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.