To establish a connection to an external Orchestrator database, you must configure the database connection parameters.
Prerequisites
■
|
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.
|
Procedure
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.
|
|
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.
|
|
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.
|
|
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.