Creating Parent and Stored Procedure Data Sources

To create parent and stored procedure data sources, perform the following steps in Sigma Studio:

1. On the home page of Sigma Studio, right-click the existing database connection, e.g. MYSQL CONNECTION and select the Create Data Source option.

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

   
   
   
   

2. Create the Parent Data Source, fetched from the table that corresponds to the Stored Procedure in the schema, which will be used as a pre-hook stored procedure, e.g. NEW DS.

   It is essential that you create a data source for the table, which corresponds to the stored procedure data source that will be used a pre-hook data source for a report.

   1. Click Save to save the parent data source.

   
   
   
   

3. Create the Stored Procedure Data Source, which will be used as a pre-hook data source in the report, e.g. SAMPLE DS.

   For detailed information on configuring a pre-hook stored procedure for a report, refer Using Stored Procedure as pre-hook for Creating Reports.

   1. Click Save to save the stored procedure data source.
   
   
   
   
4. Access App Designer and create a grid app with the Parent Data Source (e.g. NEW DS).
   
   1. Click Proceed to configure the grid app.
       
   
   
   

5. Select the required data columns for the grid app and click the Save icon to save the grid app.

   
   
   
   

   A confirmation message, indicating a successful save of the app, appears.
   
   
   
   
6. Click Ok.