topic Re: How to Call Store Procedure in Qlikview in QlikView

How to Call Store Procedure in Qlikview

Tue, 05 Aug 2014 10:43:49 GMT

Dear All,

I'm new in Qlikview. how can i call my Store Procedure in qlikview which contain 4 parameters.Please help me

Regards,

Masba !

Re: How to Call Store Procedure in Qlikview

avinashelite — Tue, 05 Aug 2014 10:53:02 GMT

Hi masba,

Try like this:

Load

Field1

Field2

...

;

Sql Exec StoredProcedureName 'Variable1', 'Variable2'

;

Re: How to Call Store Procedure in Qlikview

deepakqlikview_123 — Tue, 05 Aug 2014 10:53:12 GMT

Hi Masba,

For calling SQL stored proc in QV u need to set up ODBC connection and after u r able to use syntax.

Thanks

Re: How to Call Store Procedure in Qlikview

tresB — Tue, 05 Aug 2014 10:54:34 GMT

Like:

SQL EXEC DatabaseName.dbo.ProcedureName @Para1 = $(vPara1), @Para2 = $(vPara2), @Para3 = $(vPara3), @Para4 = $(vPara4) ;

Re: How to Call Store Procedure in Qlikview

Tue, 05 Aug 2014 11:00:47 GMT

Dear Deepak,

I have already setup ODBC connection. By ODBC connection i can read data from table. Now I'm facing problem in Store Procedure. I have uses below command to load the data.

Sql Execute COO_Stock('G044','13','03','07/01/2012','MM/DD/YYYY hh:mi:ss AM','07/20/2014 12:00:00 AM','MM/DD/YYYY hh:mi:ss AM');

Regards,

Masba

Re: How to Call Store Procedure in Qlikview

rajeshvaswani77 — Tue, 05 Aug 2014 11:06:12 GMT

Hi,

Not a good practice to call the Stored Procedure from QlikView.

After studying the logic you can build the logic in QlikView or have this in the Reporting Layer.

thanks,

Rajesh Vaswani

Re: How to Call Store Procedure in Qlikview

Tue, 05 Aug 2014 11:13:48 GMT

That really depends on the context, and the nature and complexity of the stored procedure contents.

Duplicating and translating complex SQL stored procs isn't always desirable. This may be a lot of work, and you'll have two code bases to maintain with identical functionality.

I think performance wise the stored proc may also be considerably faster as it employs SQL server logic and table indexes. Not to mention the high preformance hardware which companies often have allocated to critical SQL servers.

Re: How to Call Store Procedure in Qlikview

Tue, 05 Aug 2014 11:14:18 GMT

Dear Tresesco,

Based on your reply i have change my qlikview query.

SQL EXEC TEST.dbo.COO_Stock @Gallerie_ = 'G044', @Brancode_ = '13', @Category_ = '03', @Fromdate_ = '07/01/2012',@Todate_='07/01/2012';

Note: My Database Name: TEST

Procedure Name: Coo_Stock

Parameters Name: @Gallerie_, @Brancode_,@C,ategory_ @Fromdate_, @Todate_

If i mistake anything plz correct me..

Regards,

Masba

Re: How to Call Store Procedure in Qlikview

rajeshvaswani77 — Tue, 05 Aug 2014 11:16:40 GMT

Well if you are moving from something Legacy to QlikView, you can do away with the SP's.

Ideally SPs are not meant to be called from QlikView.

thanks,

Rajesh Vaswani