Create dataset using stored procedures in RDBMS

Solution:

 

Steps:

1. From the Top right menu, select New -> Dataset

2. Provide dataset Name, description and Select Datasource from which you want to create the dataset.

3. Select Paste ready to use query option from the method selection.

4. Paste your stored procedure as per the below example

E.g. exec sales_proc_new(Stored procedure without parameter)

E.g. exec sales_proc_new @v_State = ‘Arizona’ (Stored procedure with parameter)

 

 

Stored procedure in the Query editor

 

5. Click OK.

 

The dataset will be created as below.

Final Dataset

Note: This article is based on Smarten Version 5.0. This may or may not be relevant to the Smarten version you may be using.

Dataset Smarten SSDP SP SSDP Stored Procedure RDBMS Create Dataset