You can run a workflow to add a database and configure the host connection parameters.
When you add a database that requires a secure connection, you must import the database SSL certificate. You can import the SSL certificate from the Network tab in the Orchestrator configuration interface.
Procedure
1 | Log in to the Orchestrator client as an administrator. |
2 | Click the Workflows view in the Orchestrator client. |
3 | In the workflows hierarchical list, select and navigate to the Add a database workflow. |
4 | Right-click the Add a database workflow and select Start workflow. |
5 | In the Name text box, type the name of the database.
After the workflow runs successfully, the database appears in the Inventory view of the Orchestrator client with the name that you specify.
|
6 | Select the type of the database. |
7 | In the Connection URL text box, type the address of the database.
|
|
|---|
|
Oracle
|
jdbc:oracle:thin:@database_url:port_number:SID
|
|
Microsoft SQL
|
jdbc:jtds:sqlserver://database_url:port_number/database_name
|
|
PostgreSQL
|
jdbc:postgresql://database_url:port_number/database_name
|
|
MySQL
|
jdbc:mysql://database_url:port_number/database_name
|
|
8 | Select the session mode that the plug-in uses to connect to the database.
|
|
|---|
|
Shared Session
|
The plug-in uses shared credentials to connect to the database. You must provide the database credentials for the shared session.
|
|
Session Per User
|
The Orchestrator client retrieves credentials from the user who is logged in.
|
|
9 | Click Submit to run the workflow. |
After the workflow runs successfully, the database and all tables that belong to it appear in the Inventory view.