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
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:
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.
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:
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.
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.
When you create a new database type and save it, it will appear in the list above as part of the database types.
When you create a new connection profile, the new Database type appears in database combo box.
Continue to create a new connection profile with your parameters.
Input parameters of specific MySQL server.
You can test your account details by clicking the test button before you finish the procedure.
Click finish to add the new Connection Profile.
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