Creating a Soft Coding Record for a Database Connection
On the Orchestrator Studio Home page, click the Connections icon.
On the Connections side panel, click the New button and select Database from the drop-down list.
On the Connection design page, complete these fields:
Name. Enter a unique name for the database connection.
Description. Enter a description to identify the connection. For example, if you are creating more than one soft coding record to connect to different locations, you should include the respective location in the description of each of the soft coding records.
The Type of connection is displayed next to the Description field.
User/Role. Enter the user who is authorized to run the originating orchestration, which is the orchestration on the local system that will call the external database. The user can be an EnterpriseOne user, role, or *PUBLIC.
Environment. Enter the environment where the local orchestrations reside.
In the Database Connection area, complete these fields:
Connection. Enter the URL to the database.
Important: Oracle strongly recommends that all external calls use the SSL protocol (https) with a certificate from a reputable certificate authority.User. Enter the database user.
Password. Enter the database user password.
Driver. Enter the driver for the type of database you are accessing. You need to make sure that the driver is specified on the AIS Server class path.
Click Save.