You can run a workflow to add a database to the Orchestrator server and configure the host connection parameters.

About this task

When you add a database that requires a secure connection, you must import the database SSL certificate. You can import the SSL certificate by using the options available in 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 Library > SQL > Configuration 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.
  6. Select the type of the database.
  7. In the Connection URL text box, type the address of the database.

    Database Type

    Syntax

    Oracle

    jdbc:oracle:thin:@database_url:port_number:SID

    Microsoft SQL (with SQL authentication)

    jdbc:jtds:sqlserver://database_url:port_number/database_name

    Microsoft SQL (with Windows account authentication)

    jdbc:jtds:sqlserver://database_url:port_number/database_name;useNTLMv2=true;domain=domain_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.

    Option

    Description

    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.

    Note:

    To use session per user mode, you must authenticate by using a user name only. You should not use domain\user or user@domain for authentication.

  9. Click Submit to run the workflow.

Results

After the workflow runs successfully, the database and all tables that belong to it appear in the Inventory view.