Use the connections table to set up a Basic, JMS, JDBC, or HTTP(s) connection to a target host.

Connection Table

The Connection table (sys_connection) is the base table for all connection tables. You can set up connections for the following protocols:
  • Basic connection for PowerShell and SSH
  • JDBC
  • JMS
  • HTTP(s)
The connection table references the connection alias table, which couples the connection alias to connection information. Every connection records the following information:
Table 1. Base connection properties
FieldDescription
Name Name of the connection. This field must be unique on the table.
Credential Specify the credential to use with this connection. This is optional.
Connection alias The connection alias resolves your connection and credentials at run time. Only one connection is active per Connection alias at any one time.
Active Check to make the current connection active.
Domain Domain to which the connection belongs.

Credential is unique across active connections, if not empty.

Upgrading connection information

  • The JDBC connection [jdbc_connection] and JMS connection [orch_jms_ds] tables are existing Orchestration connection tables that now extend from the Connection [sys_connection] table. The tables originally extended from sys_metadata. The sys_metadata related data is removed.
  • The tables move from the Orchestration run time plugin [com.snc.runbook_automation.runtime] to the Credentials & Connections plugin.
  • The upgrade process obtains JDBC and JMS connection information and creates corresponding connection aliases and assigns the alias to its corresponding connection.
  • JDBC field name changes:
    • JDBC server is renamed to host
    • Database port is renamed to port
    • Data of the JDBC server and database migrates to host and port during the upgrade