Creating a Stored Procedure Data Source

To create a stored procedure data source with system parameters, perform the following steps in Sigma Studio:

1. Click the Data Source  icon on an existing database connection.

   To create a database connection in Sigma Studio, refer Creating a Database Connection.

   
   
   
   

   The Create Datasource screen appears.
   
   
   
   

2. Enter a unique data source name in the Data Source Name field, e.g. STORED PROCEDURE DS.

   The Choose Connection is a non-editable field. By default, the selected connection name will appear in the Choose Connection field. The Is SQL? toggle is an optional field. This field is used to facilitate the purpose of using SQL statements.

   
   
   
   

3. Click the Object Name lookup field and select the relevant stored procedure from which the business data need to be fetched. In the following example, the GET_FORM_ITEMS_FILTER stored procedure.
   
   
   
   The system parameter of the stored procedure appears. For example: item_type.
   
   
   
   
4. To apply data filters for the system parameters of the stored procedure, click the Procedure Params option.
   
   
   
   The Procedure Parameter Configuration screen appears.
   
   
   
   

5. Click the System Parameter Path lookup field and select the Filter Data option to apply data filters for the selected system parameter.

   The Parameter Name is a non-editable field. The parameter of the selected stored procedure will automatically be listed as the Parameter Name. For the selected stored procedure of GET_FORM_ITEMS_FILTER, the listed parameter is item_type, which appears as the Parameter Name.

   
   
   
   

6. Enter the appropriate Default Value of the selected system parameter in the Default Value field, e.g. 16.
   
   
   
   
7. On the Create Data Source screen, click Save to save the stored procedure data source.
   
   
   
   A confirmation message, indicating a successful creation of the data source, appears.
   
   
   
   
8. Click Ok.