topic Re: Connecting to stored procedure in QlikView

Connecting to stored procedure

zagzebski — Wed, 14 Oct 2015 11:25:55 GMT

I have never pulled data using stored procedure. I was able to make a connection to the database but don't know where to go from here.

The stored procedure that was loaded is : BookOfBusiness

I have attached what I see when I make a connection to the database

Thanks,

Zag

Re: Connecting to stored procedure

andrespa — Wed, 14 Oct 2015 11:41:46 GMT

Hi,

As far as I know you can't load SP into Qlikview. You can load views instead of a SP, I think the reason is that the SP has some programming behind and Qlikview can't translate it into something that it can be read into the script.

Best regards,

Andrés

Re: Connecting to stored procedure

zagzebski — Wed, 14 Oct 2015 11:51:00 GMT

I have reaed where others have done it - just am clueless since I have never tried.

Re: Connecting to stored procedure

Clever_Anjos — Wed, 14 Oct 2015 11:53:56 GMT

This should execute an return your procedure

SQL EXEC BookOfBusiness;

Re: Connecting to stored procedure

zagzebski — Wed, 14 Oct 2015 12:05:00 GMT

Thanks for the response. I got an error message (below). I was able to connect to this server so not sure why I would get this..

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: The EXECUTE permission was denied on the object 'BookOfBusiness', database 'EpicSub', schema 'dbo'.

SQL EXEC BookOfBusiness

Re: Connecting to stored procedure

maxgro — Wed, 14 Oct 2015 12:13:45 GMT

it seems you miss the right to execute the procedure

ask your dba for a (probably) grant exec on .... to .....

Re: Connecting to stored procedure

Clever_Anjos — Wed, 14 Oct 2015 12:16:53 GMT

The error message is self-explanatory, you don´t have access to execute that procedure

Re: Connecting to stored procedure

zagzebski — Wed, 14 Oct 2015 12:22:01 GMT

Thanks I will check. Sorry never use a stored procedure before so pretty lost right now.

Re: Connecting to stored procedure

zagzebski — Wed, 14 Oct 2015 22:26:57 GMT

Thanks - that was it.