Skip to Content

Control-M for OCI Data Integration

OCI Data Integration is an Oracle Cloud Infrastructure (OCI) platform, that enables data extraction, transformation, and loading (ETL) processes across various sources and targets within the Oracle Cloud.

Control-M for OCI Data Integration enables you to do the following:

  • Execute OCI Data Integration jobs that run specified versions of predefined OCI Data Integration functions.
  • Manage OCI Data Integration credentials in a secure connection profile.
  • Connect to any OCI Data Integration endpoint.
  • Introduce all Control-M capabilities to Control-M for OCI Data Integration, including advanced scheduling criteria, complex dependencies, Resource Pools, Lock Resources, and variables.
  • Integrate OCI Data Integration jobs with other Control-M jobs into a single scheduling environment.
  • Monitor the job status, results, and output of OCI Data Integration jobs.
  • Attach an SLA job to the OCI Data Integration jobs.

Control-M for OCI Data Integration Compatibility

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

Component

Version

Control-M/EM

9.0.21.200

Control-M/Agent

9.0.21.200

Control-M Application Integrator

9.0.21.200

Control-M Automation API

9.0.21.200

Control-M for OCI Data Integration is supported on Control-M Web and Control-M Automation API, but not on the Control-M client.

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

Setting up Control-M for OCI Data Integration

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

Warning

Note

Integration plug-ins released by BMC require an Application Integrator installation. However, these plug-ins are not editable and you cannot import them into Application Integrator. To deploy these integrations to your Control-M environment, 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 OCI Data Integration plug-in from the Control-M for OCI Data Integration download page in the EPD site.
  3. Install the OCI Data Integration plug-in using 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 OCI_Data_Integration_plugin.Linux
      • Windows: ctm provision image OCI_Data_Integration_plugin.Windows
  4. Create a OCI Data Integration connection profile in Control-M Web or Automation API, as follows:
  5. Define a OCI Data Integration job in Control-M Web or Automation API, as follows:
Warning

Note

To remove this plug-in from an Agent, see Removing a Plug-in. The plug-in ID is ODI032024.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Control-M