To establish a connection to an external Orchestrator database, you must configure the database connection parameters.

If you are using an SQL Server database, verify that the SQL Server Browser service is running.

To store characters in the correct format in an Oracle database, set the NLS_CHARACTER_SET parameter to AL32UTF8 before you configure the database connection and build the table structure for Orchestrator. This setting is crucial for an internationalized environment.

To configure Orchestrator to communicate with the database over a secure connection, make sure that you import the database SSL certificate. For more information, see Import the Database SSL Certificate.

1

Log in to the Orchestrator configuration interface as vmware.

2

Click Database.

3

From the Select the database type drop-down menu, select the type of database that you want Orchestrator server to use.

Option

Description

Oracle

Configures Orchestrator to work with an Oracle database instance.

SQL Server

Configures Orchestrator to work with a Microsoft SQL Server or Microsoft SQL Server Express database instance.

MySQL

Configures Orchestrator to work with a MySQL database instance.

PostgreSQL

Configures Orchestrator to work with a PostgreSQL database instance.

4

Define the database connection parameters and click Apply changes.

Option

Description

User name

The user name that Orchestrator uses to connect and operate the selected database. The name you select must be a valid user on the target database with db_owner rights.

This option is applicable for all databases.

Password (if any)

The password for the user name.

This option is applicable for all databases.

Use SSL

Specifies whether you want to use SSL connection to the database. To use this option you must make sure that you import the database SSL certificate into Orchestrator.

This option is applicable for all databases.

Database server IP address or DNS name

The database server IP address or DNS name.

This option is applicable for all databases.

Port

The database server port that allows communication to your database.

This option is applicable for all databases.

Database name

The full unique name of your database. The database name is specified by the SERVICE_NAMES parameter in the initialization parameter file.

This option is valid only for SQL Server, MySQL, and PostgreSQL databases.

Instance name (if any)

The name of the database instance that can be identified by the INSTANCE_NAME parameter in the database initialization parameter file.

This option is valid only for SQL Server and Oracle databases.

Domain

To use Windows authentication, type the domain name of the SQL Server machine, for example company.org.

To use SQL authentication, leave this text box blank.

This option is valid only for SQL server and specifies whether you want to use Windows or SQL Server authentication.

Use Windows authentication mode (NTLMv2)

Select to send NTLMv2 responses when using Windows authentication.

This option is valid only for SQL Server.

If the specified parameters are correct, a message states that the connection to the database is successful.

Note

Although Orchestrator has established a connection to the database, the database configuration is not yet complete. You must build or update the database table structure.

5

(Optional) Build or update the table structure for Orchestrator.

Option

Description

Install the database

Builds a new table structure for the Orchestrator database.

Update the database

Uses the database from your previous Orchestrator installation and updates the table structure.

After the database is populated, you can reset the database access rights to db_dataread and db_datawrite.

6

Click Apply changes.

The database connection is successfully configured.