Creating iViews for Databases (JDBC) 

Use

The SAP Enterprise Portal iView wizard framework provides a wizard for creating iViews over database applications. The wizard enables you to launch 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.

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 Propertiesdialog, 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.

       2.      Choose the template JDBC Stored Procedure iView, to initiate the 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