Create dataset using stored procedures in RDBMS

Modified on Tue, 05 Mar 2024 at 09:00 PM

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article