Creating Parent and Stored Procedure Data Sources

Owned by DevaDarshini.S
Last updated: Jan 08, 2025

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

It is necessary that you create separate data sources for both the corresponding table of the stored procedure and the specified stored procedure in eMACH-Sigma Studio. The data source, fetching data from the table that corresponds to the stored procedure is termed as the Parent Data Source, while the data, fetched from the specified stored procedure is termed as the Stored Procedure Data Source.

  1. On the home page of eMACH-Sigma Studio, click the Data Source  icon on an existing database connection.

    To create a database connection in eMACH-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 PROCEDURE 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.