Azure Synapse
Azure Synapse Analytics is a popular cloud-based ETL and data integration service that allows you to create pipelines for moving and transforming data at scale. Automating execution from within Azure Synapse creates an additional island of automation for IT Operations to manage. This allows you to easily integrate Azure Synapse pipelines with your existing enterprise workload automation solution. Simply define your automated pipelines within Azure Synapse and allow your enterprise workload automation solution to manage the scheduling of these workflows. You are instantly inheriting the advanced capabilities of your enterprise solution to deliver your digital transformation quicker and more successfully. By extending your existing enterprise automation to Azure Synapse you maintain end-to-end visibility, regain centralized command and control, alerting, SLA management, reporting and auditing.
Benefits and Use Cases
- Schedule and execute Azure Synapse pipeline jobs in existing enterprise automation workflows to orchestrate complex data workflows and enforce dependencies.
- Monitor execution status in real time.
- Automatically restart failed pipelines from the point of failure to minimize downtime and improve resiliency.
Example Use Case: Data Pipeline Orchestration and Recovery
Trigger Azure Synapse pipelines to ingest and transform sales data from multiple sources, monitor each stage for execution status and performance, and automatically restart the pipeline from any failed activity for timely insights without manual intervention.
Automic Features
- Run and Monitor Azure Synapse pipelines to completion
- Restart Azure Synapse pipelines from failed activity
- View execution log for problem diagnosis
- Alert on failure of Azure Synapse pipeline jobs
- Incorporate Azure Synapse processing in existing enterprise automation workflows including dependency enforcement