How can I add a new database type in Control-M for Databases 9.0.00? - INCLUDES VIDEO

Version 5

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    Control-M for Databases


    Control-M for Databases


    Control-M for Databases 9.0.00


    How can I add a new database type in Control-M for Databases 9.0.00?



    The following example describes how to add a new database type based on a jdbc driver for Control-M for Databases 9.0.00

    Other languages:EspañolFrançais

    Note: There is a difference between adding a database type and adding a new connection profile. The Database type feature only includes generic information in regards to how to connect to a specific database type with a specific jdbc driver. In the connection URL there are place holders instead of a specific port, host and database name. A new connection profile is based on a database type and contains specific information on where the account should connect. This way, you are able to use one database type with different database servers on different hosts.

    New database types can be accessed from the following button:
    User-added image
     Adding a new Database type:
    1)    You need to get information from the relevant database provider for the following:
    Jdbc driver:  Usually one or few *.jar files
    Connection URL:  Same driver but connect by URL string.
    Example: jdbc:mysql://<HOST>:<PORT>/<DATABASE>
    Class name :  Java class name
    2)    Database name : Has to be uniqe, the name will be displayed when you add a new connection profile.
    3)    Connection string: Is an URL string that contains placeholders <HOST>, <PORT> and <DATABASE>, those place holders will be used by the connection profile.
    4)    Path to Driver folder : The path has point to a  folder and not to a file, because some vendors are using more than 1 jar. Important: This folder has to include only files that are relevant to the driver itself. It cannot contain text, readme files or other types of files, just jar files.
    5)    Class name : The driver’s fully qualified java class name should be provided with the jdbc driver details.
    Line comment and Statement Separator are for parsing on query usage. Most of the time it will be the default that is already provided in the form(“—“  and “;”)The following is an example screenshot of the the Add New Database type window and the parameters described in the procedure above:
    User-added image
    If you receive error EM28003 with the text "Bad or Unknown Request. Destination CTM_CM, request:Ctmdb_add_dbvendor_request" when clicking OK, please reference 000087301.
    User-added image 
    As you can see in the screenshot above, In the  list  there are 5 predefined database types that cannot be deleted or edited.
    Oracle, MSSQL, DB2, Sybase and PostgreSQL, they are in bold in the list.
    User-added image
    When you create a new database type and save it, it will appear in the list above as part of the database types. 
    User-added image
    When you create a new connection profile, the new Database type appears in database combo box.
    User-added image
    Continue to create a new connection profile with your parameters.
    User-added image
    Input parameters of specific MySQL server. 
    User-added image
    You can test your account details by clicking the test button before you finish the procedure.
    User-added image
    Click finish to add the new Connection Profile.
    User-added image
    The new connection profile based on MySQL database type will be shown in Connection Profile Management.
    In WLA you can start using the new connection profile MySQL
    User-added image


    Article Number:


    Article Type:


      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles