TrustRadius: an HG Insights company

Azure Synapse Analytics Manufacturing Reviews & Insights

Score6.8 out of 10

52 Reviews and Ratings

Get a Demo

Community insights

TrustRadius Insights for Azure Synapse Analytics are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Convenience of Data Integration Tools: Users appreciate the ease of accessing various data integration tools within Azure Data Factory, including low-code DataFlows and full-code Spark in a centralized orchestrator. Code-Free ETL Work Option: The platform's code-free ETL work option simplifies the process of building, scheduling, and monitoring complex data pipelines according to users. AI Integration Functionality: Users find the AI integration seamlessly integrated into the platform, enhancing their data integration processes. Advantageous Data Pipeline Creation: Some users have found creating data pipelines that connect multiple workspaces and external sources beneficial. OnPrem Data Capture Management: Users value the capability to manage connections and create runtimes for onPrem data capture. Efficient Integrated Solution: The efficiency of combining components like Spark MPP cluster, MPP SQL Servers, and ADFs under one roof is highly praised by users.

Azure Synapse Analytics Reviews

1 Review
ManufacturingSporting Goods1

Plays with Power BI nicely

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

Microsoft Azure Synapse Analytics (formally Azure SQL Data Warehouse) is being used as our marketing data warehouse. We are pulling data down from a number of different API's such as Facebook ads, Google ads and Google analytics, and then pumping that information back into the Azure Synapse Analytics Warehouse on a daily basis.

Pros

  • They unify many data sources easily
  • There is some "code free" ETL work it enables
  • There is some AI integration that works nice

Cons

  • The cost structure is difficult to understand
  • The job scheduling capabilities aren't easy to use
  • The logging metrics aren't easy to see

Likelihood to Recommend

Azure Synapse Analytics is very well suited for companies that are using the Microsoft Power BI analytics tool (business intelligence). The reason being, you don't need to provide a data gateway to move data from your database to the reporting service online if you are using this type of database. This is a huge win for processing data.
SK
Scott Kennedy
Director, eCommerce Analytics and Digital Marketing in Marketing at Franklin Sports (Sporting Goods, 201-500 employees)
Vetted Review
Azure Synapse Analytics
1 year of experience
View profile