Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
Microsoft Azure Synapse Analytics is an end-to-end analytics solution that successfully combines analytical services to merge big data analytics and enterprise data warehouses into a single unified platform. The solution can run intelligent distributed queries among nodes, and provides the ability to query both relational and non-relational data.
Microsoft Azure Synapse Analytics is built with these 4 components:
Synapse SQL
Spark
Synapse Pipeline
Studio
Microsoft Azure Synapse Analytics...
The most valuable feature of the solution is the analytics and that it can connect with Power BI.
The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis.
The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.
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.
The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range.
The most valuable feature is the scalability.
The MPP (Massively Parallel Processing) architecture helps to make things a lot faster.
The initial setup was really easy and straightforward.
The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS.
Scaling this solution is easy and the uptime is okay.