Page Comparison

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

1. In Sigma Studio, click Connections on the left pane. The existing connections are listed on the Connections tab.
   Image RemovedRight-click a connection and select Create Data Source.
   Image Removed
   The Create New Data Source page appears.
   Image RemovedIn the
   Create Data Source pageImage Added
   
   
2. Click the Data Source Image Added icon on an existing database connection.
   
   Image Added
   
   The Create Datasource screen appears.
   
   Image Added
   
   
3. In the Create Datasource screen, 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 appear.

   Note
   To apply procedure

   appears on the page.
   Image RemovedClick Save.
   

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

   
   Image Added
   
   

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

   Warning
   When you try to exit the Create 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 Create Datasource screen. Click Ok, if you want to exit the Create Datasource screen.

   
   Image Added
   
   The following confirmation message appears

   :

...

1. .
   
   Image Added
   
   

2. Click Ok.