Setting DbExecute connections
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.
Before you begin
About this task
You can configure the external connections for the workflow system by specifying database
parameters. The database parameters that you specify form the JDBC driver URL. The JDBC driver URL
enables a database connection for the workflow system. Alternatively, you can configure a JDBC
driver URL manually if you know the format for the database type (such as DB2®, Oracle, or Microsoft SQL
Server) of the external database. You can also test the database connection to confirm that the JDBC
driver URL, database user name, and password are valid.
Note: If you are using Microsoft SQL Server
10.x JDBC driver in non-SSL mode, the jdbc driver requires
encypt=false
in
, which can be done in ACCE. For
example:jdbc:sqlserver://<server_name>\<SQL_instance>:<port>;DatabaseName=<DB
Name>;encrypt=false.Procedure
To set a DbExecute connection: