Skip to main content

Connections

JAMS Connections are objects stored inside the Connection Store. You can use the Connection Store to create Database Connections, File Transfer Connections, Integration Connections, and Mailbox Connections. These Connections can be reused in multiple Jobs, making it easier to maintain the connection information in one place. You can also use Connections with Job Properties, Job Source, or Job Triggers.

note

When specifying a machine for the Connections, it is recommended to specify the machine rather than using localhost.

Connection Store screen​

The Connection Store screen lets you view all existing Connections, create new Connections, and modify existing Connections. Each Connection displays the following:

  • Connection Name – The name of Connection.
  • Description – An optional description of the Connection to provide more information.
  • Connection Type – The type of Connection that was defined, such as SQL, SFTP, or EWS.
  • Last Change UTC – The date and time the Connection was last changed.

Viewing all Connections​

  1. Click Execution from the main menu.
  2. Click Connections.
  3. Click a column heading to sort the column.

Adding a Connection​

You can add a various Connections in JAMS. See the links below for instructions on each type.

Modifying a Connection​

  1. Click Execution from the main menu.
  2. Click Connections.
  3. Click a Connection and select Properties.
  4. Modify the properties for the Connection as needed. The available properties vary based on the type of Connection.
  5. Click Save.

Deleting a Connection​

You can delete a Connection if it is no longer used. Before deleting a Connection, ensure all Jobs that currently use it have been updated to remove references to it.

  1. Click Execution from the main menu.
  2. Click Connections.
  3. Click a Connection.
  4. Click Delete.
  5. When you are prompted to confirm the deletion, click Delete.

Querying a Connection​

If you have many Connections, you can use the Query option to quickly find one or more specific Connections. If you navigate to another screen, the query is reset.

  1. Click Execution from the main menu.
  2. Click Connections.
  3. Click Query.
  4. In the Connection Name field, enter the name of the Connection. You can also use * as a wildcard character.
  5. Click OK. The list of matching Connections is displayed.

Inheriting a Connection from an Execution Method to a Job​

A Connection can also be defined on the Execution Method level to populate the Connection property of any Job that would use that Execution Method. It is recommended that you create a custom Execution Method if you are going to modify the Connection property.

Adding a Connection Property to a Custom Execution Method​

  1. Click Execution from the main menu.
  2. Click Execution Methods.
  3. Click Add.
  4. In the Method Name field, enter a name for the custom Execution Method.
  5. In the Base Method field, select an Execution Method to use as a template.
  6. Click Save and Continue to Edit.
  7. Click the Job Properties tab.
  8. Click Add .
  9. Select a Connection property, such as File Transfer Connection.
  10. Click Save.
  11. Create a Job based on this new Execution Method.

Overriding the Connection Property from an Execution Method​

The Connection property can also be added or overridden at the Folder or Job levels. Any property set at the Folder level will override the property on the Execution Method level and will inherit to every Job Definition within the Folder. Jobs that do not use this property will ignore it.

The property can be set or overridden on any individual Job within JAMS from the Job Properties tab.