Adding a Database Type

This procedure describes how to add a database type for Control-M for Databases, which enables you to connect to any SQL database that has a JDBC driver.

When loading a new JDBC driver to use with Control-M for Databases, you need to verify it in a test environment before running jobs on a production environment. Control-M cannot be verified in the lab with all the available Database JDBCs.

Begin

  1. From the Configuration domain, click and then select Plug-ins.

  2. Select a Databases Plug-in that resides on an Agent where the JDBC driver is installed and then click Configuration.

    The Databases Type Manager pane appears.

  3. Click .

    The Add Database Type pane appears.

  4. For each field, define the required parameters, as described in New Database Type Parameters.

  5. Click Add.

    The new database appears in the Database Type drop-down list when you create a new connection profile, as described in,

  6. Create a Database connection profile, as described in Creating a Centralized Connection Profile and from the Database Type drop-down list, type the name of the new database.

    The next time you want to create a Database connection profile with this new database type, it will appear in the Database Type drop-down list.

New Database Type Parameters

The following table describes the add new database type parameters:

Parameter

Description

Database Name

Defines the name of the new specified database.

Connection String

Specifies the URL that connects to the database.

Path to driver folder

Indicates the path to the directory containing the JDBC driver and its dependencies, which must reside on an Agent.

The JDBC driver must meet the JDBC 3 or 4 driver specification.

Class Name

Defines the fully qualified class name of the JDBC driver.

Line Comment

Indicates an SQL comment.

Statement Separator

Specifies a separator between SQL statements.