Show TOC

Procedure documentationWorking with Stored Procedures Locate this document in the navigation structure

 

Visual Composer can import any third-party JDBC-based stored procedure through the SAP_JDBC connector, which is an integral part of the standard portal connectivity framework.

You add a JDBC-based stored procedure to the model as you do any other data service. For more information, see Discovering Data Services

Note Note

To define a JDBC system with Visual Composer for SAP NetWeaver Developer Studio, see Creating a JDBC Connection Profile.

End of the note.

Prerequisites

You have set up and configured the JDBC system to work with Visual Composer, as described in the Visual Composer Configuration Guide.

More information: Configuring Visual Composer to Consume Data Sources

Procedure

With JDBC, the output of stored procedures is dynamic. Therefore, the output table fields are not listed automatically in the Configure task panel. The following procedure enables you to determine the contents of the output table.

  1. Right-click the data service and choose Test Data Service from the context menu. The Test Data Service dialog box is displayed for the stored procedure.

  2. Execute a test and display the field output from the stored procedure.

  3. Click the Add Fields button at the bottom. The fields listed are assigned to the displayed output ports, overwriting any other fields that might have been assigned to those ports.

Result

To check the new output, right-click the output element (such as a table) and choose Define Data from the context menu. The fields assigned previously are displayed.