Use the DbExecute connections window
to configure external connections for the workflow system.

Before you create a new DbExecute connection,
you must configure XA and non-XA JDBC providers for the database type
of the DBExecute database on the application server to ensure that
the appropriate JDBC drivers are configured.

A DbExecute connection enables a workflow to access and
run a procedure that is stored in an external database through the
DbExecute system function in Process Designer.
From the database
parameters information that is gathered from this window, a JDBC driver
URL is formed, which enables a database connection for the workflow
system. Alternatively, you can choose to enter a JDBC driver URL manually
if you know the format for the database type (such as DB2®, Oracle, or SQL Server) of the external database.
To create a new DbExecute connection:
- Click the Create icon from the toolbar
of the Name pane.
- Select and name the new database connection with a unique
name.
- Select a database type from the Database type list.
- In the JDBC panel, choose one of
the following options:
Option |
Action |
To have the JDBC driver URL formed for you: |
Click Database Parameters and provide
the information for the following fields:- Database name
- Database host
- Database port
|
To manually enter the JDBC driver URL: |
Click JDBC Driver URL and type the
JDBC driver URL string in the field. |
- In the Database User field, type
the database user name.
- In the Database Password field,
type the database password.
- Click OK to save the DbExecute connection
configuration. Changes to the DbExecute connection settings
do not require the Commit action. The changes take effect immediately.