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.

Procedure

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

Note Note

When you browse to the location of your stored procedures in the Find Data Services task panel, certain items in the list may be displayed in red. This is an indication that the names of those procedures include characters not supported by the connected back-end system. To correct this, access the source system, copy the procedure and rename it with standard characters.

End of the note.

Be aware that because the output of stored procedures is dynamic, the output table fields are not listed automatically in the Configure Element task panel. Therefore, to determine the contents of the output table, you should:

  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 button right. The fields listed in the pane are assigned to the displayed output ports, overwriting any other fields that may have been assigned to those ports.

Result

To check the new output, display the Configure task panel for the output element (such as a table). The fields assigned previously are displayed.