Creating iViews for Databases (JDBC) 
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
Launch the iView Wizard, as described in Launching the iView Wizard and General Information.
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 
Portal Content 
Templates Template
iViews 
.