Creating iViews for Databases (JDBC) 

Use

The SAP Enterprise Portal iView wizard framework provides two wizards for creating iViews over database applications. These wizards enable you to launch either a customized SQL query or a function based on a predefined stored procedure in the database.

A function call obtains a database connection via a JDBC connector supplied with the portal. The customized query is handled by the portal Distributed Query Engine (DQE) service.

Prerequisites

·        A system based on the JDBC template has been defined and configured. See Editing JDBC System Properties.

·        A system alias pointing to the above system has been defined. See Maintaining a System Alias List.

·        If the iView you are creating retrieves data from an MS SQL database, the security settings for the database, in the Security tab of the SQL Server Properties dialog, must be defined as follows: Authentication set to SQL Server and Windows. (Windows only not supported).

For more information, see Running the System Landscape Wizard.

Procedure

...

       1.      Launch the iView Wizard, as described in Launching the iView Wizard and First Steps.

       2.      Choose one of the following templates, Query iView or JDBC Stored Procedure iView, to initiate the appropriate wizard and choose Next to continue.

You may create copies of this default iView template and then choose to create new Database (JDBC) iViews based on them. The default iView template is located in the Portal Catalog, under Portal Content ® Templates ® Template iViews.

See also:

Creating iViews Based on Stored Functions

Creating iViews Based on Custom Queries