Control-M for Azure Synapse

Azure Synapse Analytics enables you to perform data integration and big data analytics.

Control-M for Azure Synapse enables you to do the following:

  • Execute Azure Synapse pipelines.
  • Manage Azure Synapse credentials in a secure connection profile.
  • Connect to any Azure Synapse endpoint.
  • Integrate Azure Synapse jobs with other Control-M jobs into a single scheduling environment.
  • Monitor the status, results, and output of Azure Synapse jobs in the Monitoring domain.
  • Attach an SLA job to your Azure Synapse jobs.
  • Introduce all Control-M capabilities to Control-M for Azure Synapse including advanced scheduling criteria, complex dependencies, Resource Pools, Lock Resources, and variables.
  • Run 50 Azure Synapse jobs simultaneously per Agent.

Control-M for Azure Synapse Compatibility

The following table lists the prerequisites that are required to use the Azure Synapse plug-in, each with its minimum required version.

ComponentVersion
Control-M/EM9.0.20.200
Control-M/Agent9.0.20.200
Control-M Application Integrator9.0.20.201
Control-M Web9.0.20.200
Control-M Automation API9.0.20.250

Control-M for Azure Synapse is supported on Control-M Web and Control-M Automation API, but not on Control-M client.

To download the required installation files for each prerequisite, see Obtaining Control-M Installation Files.

Setting up Control-M for Azure Synapse

This procedure describes how to deploy the Azure Synapse plug-in, create a connection profile, and define an Azure Synapse job in Control-M Web and Automation API.

Note

Integration plug-ins released by BMC require an Application Integrator installation at your site. However, these plug-ins are not editable and you cannot import them into Application Integrator. To deploy these integrations to your Control-M environment, you import them directly into Control-M using Control-M Automation API.

Before You Begin

Verify that Automation API is installed, as described in Automation API Installation.

Begin

  1. Create a temporary directory to save the downloaded files.

  2. Download the Azure Synapse plug-in from the Control-M for Azure Synapse download page in the EPD site.
  3. Install the Azure Synapse plug-in via one of the following methods:
    • (9.0.21 or higher) Use the Automation API Provision service:
      1. Log in to the Control-M/EM Server machine as an Administrator and store the downloaded zip file in the one of the following locations (within several minutes, the job type appears in Control-M Web):
        • Linux: $HOME/ctm_em/AUTO_DEPLOY
        • Windows: <EM_HOME>\AUTO_DEPLOY
      2. Log in to the Control-M/Agent machine and run the provision image command, as follows:
        • Linux: ctm provision image ZSY_plugin.Linux
        • Windows: ctm provision image ZSY_plugin.Windows
    • (9.0.20.200 or lower) Use the Automation API Deploy service, as described in deploy jobtype.
  4. Create an Azure Synapse connection profile in Control-M Web or Automation API, as follows:
  5. Define an Azure Synapse job in Control-M Web or Automation API, as follows:


Note

To remove this plug-in from an Agent, follow the instructions in Removing a Plug-in. The plug-in ID is ZSY062022.

Change Log

The following table provides details about changes that were introduced in new versions of this plug-in:

Plug-in VersionDetails
1.0.01

Improved body structure of the completion step.

1.0.02

Functionality of cancelling child pipelines (recursive abort) is added to the existing manual abort step. 

Was this page helpful? Yes No Submitting... Thank you

Comments