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 Removed
   Right-click a connection and select Create Data Source.
   Image Removed
   The Create Data Source page appears.
   Image Removed
   In 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, 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.

   Warning
   When you try to exit the Create Datasource screen before saving the configured stored procedure data source

   .
   Image Removed

   , 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.
   
   Image Modified
   
   

6. Click Ok.