Microsoft Azure Synapse Analytics

What differentiates Microsoft Azure Synapse Analytics from other similar products?

One can do everything related to creating a pipeline with this single tool. We can extract the data, transform it, orchestrate the pipeline and even store the data which I think is not feasible with any other tool to my knowledge.

What is your favorite aspect of this product?

We can integrate it directly with Data Factory to facilitate any data transformations. We can also integrate it with other services and even external dashboarding tools which can be then used to create reports.

What do you dislike most about this product?

We need to start and switch off the storage cluster manually in this service. Also, the costing for persistent tables is high as compared to other Data warehousing tools.

What recommendations would you give to someone considering this product?

Always remember to switch off the cluster whenever not being used since not doing this would increase your costing exponentially.

What differentiates Microsoft Azure Synapse Analytics from other similar products?

It is easy to use, we can create multiple jobs using synapse studio it could be azure data factory, databricks and SQL data warehouse. it supports all the processes and it easily handles a big amount of data we can easily define indexes and dimensions in the synapse analytics platform. Connection with other Microsoft applications is easy and sustainable

What is your favorite aspect of this product?

My favourite aspect of this product: 1) SQL pool 2) Copy Job - You can create a copy job from any of the multiple connectors within the workspace. 3) Data Flow 4) Data pipeline 5) Machine learning 6) Visualization and analytics

What do you dislike most about this product?

Nothing as of now

What recommendations would you give to someone considering this product?

If you are looking for following feature this is must use solution: Reduce time to market Enhance decision making Improve business process agility Drive revenue growth Drive innovation Create internal/operational efficiencies Cost management Improve business process outcomes Improve compliance & risk management

What differentiates Microsoft Azure Synapse Analytics from other similar products?

Microsoft Azure Synapse Analytics is comparatively fine-tuning, monitoring, flexibility, and automation. If one wants to use Microsoft Data Platform then Azure is better alternate to work on a large data.

What is your favorite aspect of this product?

Microsoft Azure Synapse Analytics is simple to use as well customizable. It allows easy and quick configuration and integration. It facilitates data discovery, classification, data masking, and complex security models.

What do you dislike most about this product?

Microsoft Azure Synapse Analytics has no conversion tool for code. Poor support and lack of features are also observed. In case of large data queries it gets hanging. Deployment can be difficult.

What recommendations would you give to someone considering this product?

Autoscale without downtime may be made available. Microsoft Azure Synapse Analytics notebook needs maturity. User interface could provide links to external additional content to help new users. Integration to Azure active directory needs to be strong enough.