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.
   Image Removed
   Image Added
   
   
2. Right-click a connection and select Create Data Source.
   Image Removed
   Image Added
   
   The Create Data Source page appears.
   Image Removed
   Image Added
   
   
3. In the Create Data Source page, enter a unique data source name in the Data Source Name field.
   Image Removed
   Image Added
   
   

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.
   Image Removed
   Image Added
   
   The parameter details of the selected stored procedure appear.

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

   
   Image RemovedImage Added
   
   

5. Click Save to save the stored procedure data source.
   Image Removed
   Image Added
   
   The following confirmation message appears.
   
   
   
   
6. Click Ok.