Get started with connections
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:
| Field | Description |
|---|---|
| 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
Create a basic connection for PowerShell and SSH
Configure connection information to use with a custom activity or action that uses the PowerShell or Secure Shell (SSH) protocol.- Create an HTTP(s) connection
The HTTP(s) connection provides the information custom HTTP(s) actions or activities use to connect. - Create a JDBC connection
The JDBC Connection provides the information custom JDBC actions or activities use to connect to various target databases. - Create a JMS connection
Configure your system to use Java Messaging Service (JMS) with a custom JMS activity or action. - Create connection attributes for IntegrationHub
Define connection-specific variables that you can use in Integration Hub integration steps.
Parent Topic:Connections and Credentials