Database Stored Procedure Window

Use this window to configure where and how the data is retrieved from the database, when using a stored procedure

Navigation

In AgilePoint Envision, open a process template.
Navigate to the Database stencil.
On the Database stencil, drag the Query Database AgilePart, and drop it on the process template.
On the SQL Type list, select Stored Procedure.
On the Configure field, click the ElLipses button.

Field Name	Definition
ConnectionString	The connection string that will be used to connect to the database at runtime. Click Choose to select a connection string from the list of shared custom attributes (defined and managed in Enterprise Manager.) Click Create to create a new connection string. to create a new connection string.
Stored Procedure Name	The name of the stored procedure.
Parameters	The parameters for the stored procedure.

Field Name

Definition

ConnectionString

The connection string that will be used to connect to the database at runtime.

Click Choose to select a connection string from the list of shared custom attributes (defined and managed in Enterprise Manager.)
Click Create to create a new connection string. to create a new connection string.

Stored Procedure Name

The name of the stored procedure.

Parameters

The parameters for the stored procedure.