Creating a Data Source using Stored Procedure

Perform the following steps to create a datasource using stored procedure:

1. In Sigma Studio, click Connections on the left pane. The existing connections are listed on the Connections tab.
   
   
   
   
2. Right-click a connection and select Create Data Source.
   
   
   
   The Create Data Source page appears.
   
   
   
   
3. In the Create Data Source page, enter a unique data source name in the Data Source Name field.
   
   
   
   

4. Click Object Name field and select the stored procedure name from which you need to fetch the data. In this example, demo_summary_procedure is selected.
   
   
   
   The parameter details of the selected stored procedure appear.

   To apply procedure parameters for stored procedures, refer Applying System Parameters for Stored Procedures.

   
   
   
   

5. Click Save to save the stored procedure data source.

   When you try to exit the Datasource screen, before saving the configured stored procedure data source, a warning pop-up message appears, as shown in the following screen shot:
   

   • Click Cancel, if you do not want to exit the Datasource screen.
   • Click Ok, if you want to exit the Datasource screen.

   
   
   
   The following confirmation message appears.
   
   
   
   

6. Click Ok.