Configuring external database type in BMC Atrium Orchestrator

Use information provided in this topic to configure an external database type other than the one automatically configured by the BMC Change Automation installer. The BMC Change Automation installer automatically configures Derby database to store the incoming data from an automation system and a change management system.

If you are using database other than Derby, you must configure the database type in BMC Atrium Orchestrator. For example, if you are using Oracle 12c database for BMC Change Automation, ensure that you set the value of database type as ORACLE in BMC Atrium Orchestrator.

• • Supported database types in BMC Change Automation
  •  
  • Supported database types in BMC Atrium Orchestrator
  •  
  • To configure an external database type

Supported database types in BMC Change Automation

BMC Change Automation is certified against the following database types:

• Derby
• Oracle 12c
• SQL Server 2012

Supported database types in BMC Atrium Orchestrator

BMC Atrium Orchestrator supports following database types:

• MYSQL
• SQLSERVER
• DERBY
• ORACLE
• DB2
• SYBASE

To configure an external database type

1. In BMC Atrium Orchestrator Grid Manager, navigate to Manage > Modules > BMC-SA-CLA-ITSM-Integration.
   
   
2. In Current Grid: My Grid, navigate to Configuration > Tables > DatabaseType.
   
    

3. In Current Operation: Edit Module Configuration, enter a value from the following in the Value (String) field.
   Note that the value is case sensitive.

   • MYSQL
   • SQLSERVER
   • DERBY
   • ORACLE
   • DB2
   • SYBASE

   

4. Click OK.