Control-M for Databases

Control-M for Databases is a plug-in that enables you to do the following:

  • Define and monitor Stored Procedures, SQL Scripts, SQL Server Integration Services (SSIS) Packages, and Embedded Query database jobs.

  • Connect to any supported database from a single computer with secure login, which eliminates the need to provide authentication.

  • Integrate Databases jobs with other Control-M jobs into a single scheduling environment.

  • Attach an SLA job to your Databases jobs.

  • Introduce all Control-M capabilities to Control-M for Databases, including advanced scheduling criteria, complex dependencies, Resource Pools, Lock Resources, and variables.

Compatibility

The following table lists the Control-M for Databases plug-in prerequisites, each with its minimum required version.

Prerequisites

Version

Control-M/EM

9.0.19 or higher

Control-M/Server

9.0.19 or higher

Control-M/Agent

9.0.19 or higher

Oracle Database

Any

MSSQL Database

  • 2022

  • 2019

  • 2017

  • 2016

  • 2014

  • 2012

  • 2008

  • 2005

DB2 Database

Any

Sybase Database

Any

PostreSQL Database

Any

SAP ASE Database

Any

Setting Up Control-M for Databases

This procedure describes how to install the Databases plug-in, create a connection profile, and define a Databases job in Control-M Web and in Automation API.

Begin

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

  2. Download the Control-M for Databases plug-in.

  3. Install Control-M for Databases, as described in Control-M for Databases Installation.

  4. Create a Databases connection profile, as follows:

  5. (Optional) Add a database type to Control-M for Databases, which enables you to connect to any SQL database that has a JDBC driver, as described in Adding a Database Type.

  6. Define a Databases job, as follows: