Overall Satisfaction with Azure Synapse Analytics (Azure SQL Data Warehouse)
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.
- They unify many data sources easily
- There is some "code free" ETL work it enables
- There is some AI integration that works nice
- The cost structure is difficult to understand
- The job scheduling capabilities aren't easy to use
- The logging metrics aren't easy to see
- Ability to remove dependency on data gateway
- data processing speed
- serverless maintainance
- Easy database management using modern tools
- Easy integration with Power BI
- Cloud-native HTAP
Azure Synapse Analytics stacks up well against the competitors I mentioned above. Technically, Azure SQL Datawarehouse is an upgraded version of the Azure SQL Database. So, the choice to move from one to the other depends on the processing needs of your company. If you need more power, go with the data warehouse.
Do you think Azure Synapse Analytics delivers good value for the price?
Yes
Are you happy with Azure Synapse Analytics's feature set?
Yes
Did Azure Synapse Analytics live up to sales and marketing promises?
Yes
Did implementation of Azure Synapse Analytics go as expected?
Yes
Would you buy Azure Synapse Analytics again?
Yes