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

Version 5
    Share:|

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


    PRODUCT:

    Control-M for Databases


    COMPONENT:

    Control-M for Databases


    APPLIES TO:

    Control-M for Databases 9.0.00



    QUESTION:

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


    ANSWER:

     

    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:

    000099986


    Article Type:

    FAQ/Procedural



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