Page Comparison

...

1. Right-click the existing database connection, e.g. NEW CONNECTION and select the Create Data Source option.

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

   
   
   
   

   The Create Datasource page appears.
   Image Removed
   Image Added
   
   

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

   Note
   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.

   
   Image RemovedImage Added
   
   

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.
   Image Removed
   Image Added
   
   The system parameter of the stored procedure appears. For example: item_type.
   Image Removed
   Image Added
   
   
4. To apply data filters for the system parameters of the stored procedure, click the Procedure Params option.
   Image Removed
   Image Added
   
   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.

   Note
   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 page, click Save to save the stored procedure data source.
   Image Removed
   Image Added
   
   A confirmation message, indicating a successful creation of the data source, appears.
   
   
   
   
8. Click Ok.