IBM FileNet P8, Version 5.2.1            

Setting DbExecute connections

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

Start of changeBefore 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.End of change

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:

  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.
  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.


Last updated: October 2015
bpfc079.htm

© Copyright IBM Corporation 2015.