Show TOC

Creating iViews for Databases (JDBC)Locate this document in the navigation structure

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 JDBC System Properties .

  • A system alias pointing to the above system has been defined. See Managing System Aliases .

  • 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 Creating Systems .

Procedure

  1. Launch the iView Wizard, as described in Launching the iView Wizard and General Information .

  2. Choose the template JDBC Stored Procedure iView , to initiate the wizard and choose Next to continue.

Note

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 Start of the navigation path Portal Content Next navigation step Templates Next navigation step  Template iViews End of the navigation path.

More Information