Azure Synapse Analytics Reviews & Product Details

Azure Synapse Analytics helps with data migration, data orchestration, and analyzing large amounts of data, supporting multiple functionalities for petabytes of data at the organizational level. It supports creating data pipelines that function like the SSIS tool but in a cloud version. Review collected by and hosted on G2.com.

Sometimes rectifying an error is very difficult. Although it has multiple functionalities, some features are still missing, like data flow not being supported in all regions. Review collected by and hosted on G2.com.

Supports native SQL and cloud based no code approach to connect systems, create data warehouse and run analytics and reports Review collected by and hosted on G2.com.

Challenge implementing outside Azure in a multi cloud environment Review collected by and hosted on G2.com.

I'm a fan of it when we need to do data migration, orchestration - pipeline for ETL/ELT, spark technologies for big data, integration with other services like Power BI, Cosmos DB, and Azure ML or need to use the best of SQL technologies. Review collected by and hosted on G2.com.

Sometimes it doesn't support some of the scenarios or some datasets. Throws some weird errors which sometimes are unable to sort out. Review collected by and hosted on G2.com.

Azure Synapse Analytics helps with providing insights and analytics of stored data which can be used for decision making. It gives you the freedom to query data on your terms, using either serverless or dedicated resources at scale. Review collected by and hosted on G2.com.

Not much they should have a better UI and customer support should be extended to 24*7 Review collected by and hosted on G2.com.

Operates as a PaaS with data warehouse features Review collected by and hosted on G2.com.

I dislike the cost of the system. Even when not using it they charge you Review collected by and hosted on G2.com.

Really it is very decent software for storing and retrieving data. It is very simple and responsive. It is the same as SQL Server. It is robust and integrated software. It is very secure. I like PaaS and data mining. Review collected by and hosted on G2.com.

Nothing! Really it is good. Sometimes it lags when RAM is less. Review collected by and hosted on G2.com.

I work with implementations where Azure SQL DWH is used and the scalability it provides is best in the market Review collected by and hosted on G2.com.

Pricing. The pricing is high considering the open source competitors, Review collected by and hosted on G2.com.

I like below features of azure sql data warehouse.

1)It support cloud computing. This makes it high availability.

2) It allows to create Virtual machine. It is easy and saves time.

3)Its GUI is simple. It is easy to use. Review collected by and hosted on G2.com.

1) It do not support some features of T-SQL like Error_LIne.

2)It do not provide support for entity framework.

3) The column store tables do not support secondary non-clustered indexes.

4)SQL azure database do not support sql jobs as provided by sql agent. Review collected by and hosted on G2.com.

Flexibility, and scalability also don't have to worry about maintaining it can also do schedule maintenance Review collected by and hosted on G2.com.

Security still seems like not up to the mark also security and role could be more similar to setup and it would have been great if I could setup a security based on region Review collected by and hosted on G2.com.

I like how all Azure technologies work side-by-side. Having Azure Storage and Azure Functions setup in our cloud enabled us to deliver solutions to our clients faster. With Azure SQL Data Warehouse, data management becomes a walk in a park in our team. It's easy to use. I feel safe when I'm experimenting with it for the first time. Support is awesome. Review collected by and hosted on G2.com.

There is a learning curve to managing data and security. Review collected by and hosted on G2.com.