InetSoft Software Clarification: Creating Stored Procedures using InetSoft's BI Software, Difference from SQL Query

Stored procedures are compiled and stored in a database. There are a few major differences between a stored procedure and a SQL query:

A stored procedure is invoked as a function call instead of a SQL query.
Stored procedures can have parameters for both passing values into the procedure and returning values from the call.
Results can be returned as a result set, or as an OUT parameter cursor.

View a five-minute Flash demo to get an overview of what InetSoft's business intelligence software, Style Intelligence, can do and how easy it is to use.

Stored procedures are listed on the same tree as tables and views. Only one stored procedure may be selected per query. The stored procedure parameters are listed on the middle pane. Specify values for the parameters by selecting each parameter on the tree and entering a value or variable name.

If the result column list is not populated, select the ‘Column Info’ button to retrieve it. Select the ‘Preview’ button to preview the query. If any parameter is left as null or specified as ‘Prompt User’, when the query is executed a parameter dialog will pop up to prompt for the remaining parameters.

Due to the different ways database vendors implement stored procedures, not all stored procedures are supported by JDBC. If a stored procedure cannot be used in the Data Modeler, it could be executed by custom code, and setup as a Java object data source.

The following is a list of known restrictions on stored procedures:

Only one dataset is allowed in a stored procedure.
In Oracle, only one cursor is allowed and it has to be the last parameter in the stored procedure.
In Oracle, only standard SQL types should be used in the parameters (user defined types are not allowed).
In MySQL, older drivers do not return procedure meta-data.

Customer Testimonial

Sharna Morelli, Senior Vice President at Morpace explains that the information visualization and reporting technology of Style Intelligence that is embedded in Morpace’s Web-based market research platform will deliver insights gained from customer satisfaction feedback surveys to the front line staff at major retailers who in turn will be able to take immediate action when and where it matters most, in the store. Morelli cited the ease of development, the report user interface, security features, and total cost of ownership as factors in Morpace’s selection of InetSoft’s enterprise class BI platform.

“The data modeler, data mashup and reporting interfaces are designed for the skill sets of each area of expertise. The modeler is familiar for database designers with a strong DBA background, while the reporting tools are appropriate for creative users designing report aesthetics,” said Morelli. “And rather than develop different reports and portals for each user group, the built-in report security allows us to securely deliver the feedback to the appropriate areas - a timesaving benefit that developers will greatly appreciate.”

Next Topic: Accessing Multidimensional Databases

More Resources:

		Business Intelligence Software Flash Demo
		Download a Free Trial
		Ask a Question
		Drill Down Reporting