Query Database

This AgileShape can be used to execute dynamic SQL statements and/or call database stored procedures in order to retrieve data from the database.

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.

Field Name	Definition
Configure	Opens the one of the following windows, depending upon the setting of the SQL Type field: SQL - Database Queries dialog box, where you can configure where and how the data is retrieved from the database, using a SQL statement. Stored Procedure - Database Stored Procedure window, where you can configure where and how the data is retrieved from the database, using a stored procedure.
DatabaseType	The type of database that will be used.
Timeout	Default value: 600 Specifies the maximum amount of time (in seconds) that should be allowed for the completion of the web service call for this AgileShape.
SQLType	Default value: SQL This property determines whether this AgileShape will retrieve the data from the database using a database stored procedure, or using (one or more) dynamic SQL statements. This property can be set to the following specific values: SQL - This value indicates that the data will be retrieved from the database using one or more dynamic SQL statements. StoredProcedure - This value indicates that the data will be retrieved from the database using one database stored procedure. If the SqlType property is set to SQL when you click the Ellipses button, it will open a configuration dialog like the one shown below.

The properties of the basic AgilePart AgileShape are also included in this AgileShape. For more information, see AgilePart.