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 New 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,

   procedure

   demo_summary_procedure is selected.
   

   Image Removed

   
   Image Added
   
   The parameter details of the selected stored

   procedure appears on the page.
   Image RemovedClick Save.

   procedure appear.

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

   
   Image Added
   
   

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

...

1. .
   
   Image Added
   
   
2. Click Ok.