Skip to main content

Connections to Database Servers

The Connection Store lets you create Connections to Oracle and SQL Servers. This connection information is saved in one place and can be referenced in one or more Jobs.

Adding a Connection to an Oracle Database Server​

This option is available only if the Oracle Integration has been installed.

Ensure you have created a Credential within JAMS that contains the credentials for connecting to the Oracle database.

  1. Click Execution from the main menu.
  2. Click Connections.
  3. Click Add.
  4. In the Connection Name field, enter the name, such as OraDatabase.
  5. In the Connection Type field, select Oracle.
  6. In the Description field, enter a description.
  7. Click Save and Continue to Edit.
  8. Prepare your Oracle Connection String to the Oracle Database. Within the following string, replace the following:
    HOST with the Oracle database host name.
    SID with the Oracle database service name.
    Orac(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST>)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = <SID>)));
note

After updating the HOST and SID, copy the Connection String because you need this to update the Connection String field. Use tnsnames.ora as the reference to look up the required values for the Connection String.

  1. Click the Properties tab.
  2. Under Oracle, click the Connection String field and paste the Connection String.
note

Do not include Data Source = in the Connection String as JAMS automatically inserts it.

  1. In the Credential field, select a Credential in JAMS.
  2. Click Save.

Adding a Connection to a SQL Server​

Ensure you have created a Credential within JAMS that contains the credentials for connecting to the SQL Server database. The Credential can use a domain service account for use with Integration security or a SQL Server user account (username/password) for use with SQL Authentication. This can be overridden on the Job level. The Credential can also be used for the Impersonation User.

  1. Click Execution from the main menu.
  2. Click Connections.
  3. Click Add.
  4. In the Connection Name field, enter the name, such as SQLDatabase.
  5. In the Connection Type field, select SQL Server.
  6. In the Description field, enter a description.
  7. Click Save and Continue to Edit.
  8. Click the Properties tab.
  9. Click the Connection String field.
  10. Paste the Connection String into the field.
  11. In the Credential field, select a Credential in JAMS.
  12. Click Save.

SQL Connection​

You can define the SQL Connection in the Stored Connection field under the Source tab of the Job Definition of a Job that uses a SQL Execution Method, such as SSISDirect.