Creating a Data Source using Stored Procedure

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

1. In Sigma Studio, click Connections on the left pane. The existing connections are listed on the Connections tab.
   
   
   
   
2. Click the Data Source  icon on an existing database connection.
   
   
   
   The Create Datasource screen appears.
   
   
   
   
3. In the Create Datasource screen, 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.

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

   
   
   
   

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

   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:
   

   • Click Cancel, if you do not want to exit the Create Datasource screen.
   • Click Ok, if you want to exit the Create Datasource screen.

   
   
   
   The following confirmation message appears.
   
   
   
   

6. Click Ok.