Overview of Procedures in Information Designer


Database Procedures

A database procedure is a set of SQL statements that can be stored in the database. Once this has been done, clients do not need to keep reissuing the individual statements but can refer to the database procedure instead.

Database procedures can be useful in many situations:

Database Procedures in Information Designer

Using Information Designer you select pre-made database procedures and configure these to be accessible in information links. These information links are available to the Spotfire users to retrieve or manipulate data.

In Information Designer you select a database procedure from your available data sources, and define which input parameters that the procedure should prompt for, and any potential resulting columns and joins.

Then you configure a complete information link with one or more combinations of procedures and columns from other tables.

The Three Kinds of Procedures

Information Designer defines three kinds of procedures:

Note: If using Oracle stored procedures that return data, Information Designer only support procedures that return data of the type REF CURSOR (also known as Table Function).

See also:

Creating a Pre- or Post-update Procedure

Creating a Query Procedure

Procedure Element Tab

 

Connecting to Stored Procedures Using Data Connections