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.

Setting Up Control-M for OCI Data Integration

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

Before You Begin

  • Verify that Automation API is installed, as described in Setting up the API.
  • Verify that Agent version 9.0.21.080 or later is installed.

Begin

  1. On the Agent host, set the Java environment variable by running one of the following commands through a command line:
    • Linux:
      • Bourne Shell/Bash: export BMC_INST_JAVA_HOME=<java_11_directory>
      • csh/tcsh: setenv BMC_INST_JAVA_HOME <java_11_directory>
    • Windows: set BMC_INST_JAVA_HOME="<java_11_directory>"
  2. Run one of the following API commands:
    • For a fresh installation, run the following provision image command:
      • Linux: ctm provision image OCI_Data_Integration_plugin.Linux
      • Windows: ctm provision image OCI_Data_Integration_plugin.Windows
    • To upgrade, run the following command:
      ctm provision agent::update
  3. Create an OCI Data Integration connection profile in Helix Control-M or Automation API, as follows:
  4. Define an OCI Data Integration job in Helix Control-M 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