You can run a workflow from the vRealize Orchestrator Client to generate a JDBC connection URL.

Prerequisites

Verify that the user account you are logged in with has the necessary permissions to run JDBC workflows.

Procedure

  1. Log in to the vRealize Orchestrator Client.
  2. Navigate to Library > Workflows and enter the jdbc tag in the workflow search box.
  3. Locate the JDBC URL generator workflow and click Run.
  4. On the General tab, select the type of database for which to generate a URL.
    Note: If you use a Microsoft database, select the Microsoft tab and provide the database instance name and database user domain name.
  5. Provide the required information to generate a database URL.
    1. Enter a database server name or IP address.
    2. Enter a database name.
    3. (Optional) Enter a database port number.
      If you do not specify a port number, the workflow uses a default port number.
    4. Enter a user name to access the database.
    5. Enter a password to access the database.
  6. Click Run.