Azure Synapse Analytics
Azure Synapse Analytics
Introduction
Maintainer: DBA Demo Admins DBA_Demo_Admins@bmc.com
Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated resources—at scale. Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, manage, and serve data for immediate BI and machine learning needs.
Use Case Overview
This workflow allows businesses to automate and schedule data integration and analytics workflows alongside other enterprise processes. This use case enables centralized monitoring and management of big data analytics and data pipelines, ensuring efficient data processing and timely execution. By integrating Synapse Analytics with existing workflows, companies can enhance data-driven decision-making, improve operational efficiency, and accelerate business insights.
Use Case Technical Discussion
This pipeline will trigger an Azure Synapse pipeline: HelloWorldPipeline_copy1 twice using 2 different authentication mechanisms, Service Principal and Managed Identity.
Demo Environment Jobs
| Job Name | Execution | Pipeline Name | Connection Profile |
|---|---|---|---|
| zzz-azure-synapse-job | Executes Azure Synapse job using Service Principal access | HelloWorldPipeline_copy1 | ASA_STANDARD_CP |
| zzz-azure-synapse-mi | Executes Azure Synapse job using Managed Identity | HelloWorldPipeline_copy1 | ASA_STANDARD_MI |
Demo Environment Information
| Environment | Status | Hosts/Hosts Group | Connection Profile | Site Standard | Folder Name |
|---|---|---|---|---|---|
| Helix Production | Available | zzz-linux-agents | ASA_STANDARD_CP, ASA_STANDARD_MI | SE Demo System Standard | zzz-azure-synapse-analytics |
| Helix Pre-Prod | Not Available | ||||
| Helix Sandbox | Not Available |
Duration: Takes about 6 Minutes to complete.
For additional information on the Helix Control-M Azure Synapse job type, select the following links: