Setting DbExecute connections

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

Before you begin

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.

For containerized Content Platform Engine deployments, see topic ../com.ibm.p8.containers.doc/containers_externaljars.html for how to include the JDBC driver libraries.

About this task

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.

Procedure

To create a new DbExecute connection:

  1. Click the Create icon from the toolbar of the Name pane.
  2. Select and name the new database connection with a unique name.
  3. Select a database type from the Database type list.
  4. 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.
    Note: If you are using Microsoft SQL Server 10.x JDBC driver in non-SSL mode, the jdbc driver requires encypt=false in Workflow System > DBExecute Connections > JDBC Driver URL, which can be done in ACCE. For example:jdbc:sqlserver://<server_name>\<SQL_instance>:<port>;DatabaseName=<DB Name>;encrypt=false.
  5. In the Database User field, type the database user name.
  6. In the Database Password field, type the database password.
  7. 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.