Retrieving Data from a Database

To retrieve data from the database using SQL statements or stored procedures, do the following.

Navigation

In AgilePoint Envision, open a process template.
Navigate to the Database stencil.
On the Database stencil, drag the Query Database AgileShape, and drop it on the process template.
To view the entire list of properties, in the Design Tasks pane, click Show Properties.
On the SQLType list, select SQL.
On the Configure field, click the Ellipses button.

On the Database Queries window, complete the following fields as required.

Field Name	Value
Connection String	Definition: Specifies the connection string that is used to connect to the database. 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. Allowed Values: A valid SQL connection string. Default Value: server=myserver;database=pubs;trusted_Connection=yes Custom Attributes: Yes Example: server=DataServer;database=StoreDb;trusted_Connection=yes
Add	Opens the Following Window: Custom Attribute and Query Window Purpose of this Window: Specifies adding or editing the SQL query which are executed at runtime.

Field Name

Value

Connection String

Definition:

Specifies the connection string that is used to connect to the database.

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.

Allowed Values:

A valid SQL connection string.

Default Value:

server=myserver;database=pubs;trusted_Connection=yes

Custom Attributes:

Yes

Example:

server=DataServer;database=StoreDb;trusted_Connection=yes

Add

Opens the Following Window:: Custom Attribute and Query Window
Purpose of this Window:: Specifies adding or editing the SQL query which are executed at runtime.

Complete any additional configuration for this AgileShape according to your requirements: