Visual Composer can import third-party JDBC-based stored procedures for use as sources of data in your model.
You add a JDBC-based stored procedure to the model as you do any other data service. For more information, see Discovering Data Services
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.
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.
Execute a test and display the field output from the stored procedure.
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.
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.