Page Comparison

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.

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

   
   
   
   

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

   Warning
   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: Image Added Click Cancel, if you do not want to exit the Datasource screen. Click Ok, if you want to exit the Datasource screen.

   
   Image Modified
   
   The following confirmation message appears.
   
   Image Modified
   
   

6. Click Ok.