Database requirements
The BMC Network Automation application server requires a database. Currently, BMC Network Automation supports the following databases:
- Embedded PostgreSQL
- Remote PostgreSQL (RPostgreSQL)
- Oracle
- Microsoft SQL Server
For the supported versions of these databases, see Database support.
The embedded PostgreSQL database is packaged and installed with the product. It is configured to function with minimal maintenance.
The product administrator is responsible for configuring options for the external databases. This topic describes a few database considerations for the external databases.
- Considerations during a fresh BMC Network Automation installation
- Oracle and SQL Server database requirements
- Related topics
Considerations during a fresh BMC Network Automation installation
- For MS SQL and RPostgreSQL databases, you can create a new database or use a existing one. When using an existing database, the existing database must be clean or empty.
- For an Oracle database, you can create a new database or use a existing one. When using an existing database, the database schema must be fresh.
- For an Embedded PostgreSQL database, BMC Network Automation handles the database requirements.
- Disable database compression.
Oracle and SQL Server database requirements
The following table lists the parameters supported by Oracle and Microsoft SQL Server database servers:
Parameter | Supported by | Supported by |
|---|---|---|
Are_there_heap_tables | Yes | Yes |
Require_DBM (Database Mirroring) | No | No |
Preferred Fill Factor for indexes | Default | Default |
Is_Data_Archievable | Yes | Yes |
Is_Application_logging_in_DB1 | No | No |
Is_Linked_Sever_leveraged | No | No |
Is_Bulk_Data_Loaded | No | No |
Is_SQLCLR_leveraged (Dot Net CLR) | No | No |
Is_Non_Default_Collation_leveraged | No | No |
Are_Extended_SPROCs_leveraged (Extended Stored Procedures) | No | No |
Is Master_DB called (For SQL Server) | No | No |
Is_Partitioning_leveraged | No | No |
Are_Materialzied_Views_leveraged | No | No |
Are_Triggers_leveraged | No | No |
Is_Auditing_leveraged | No | No |
Is_Dynamic_SQL_leveraged | Yes | Yes |
Is_DB_Trustworthy_Enabled | No | No |
Is_forced_parameterization_leveraged | No | No |
is_db_chaining_leveraged | No | No |
Is_Encryption_leveraged | No | No |
Is_Object_Level_Encrytion_leveraged | No | No |
Is_Replication_leveraged | No | No |
Is_Service_Broker_leveraged | No | No |
Is_TDE_Encryption_leveraged | No | No |
Is_Full_Text_leveraged | No | No |
Is_FileStream_Leveraged | No | No |
1 This parameter is used to determine whether the application stores its logs on the application server or in the database.
Related topics
Configuring databases for Windows
Configuring databases for Linux