Connecting to stored procedure

[zagzebski]

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

[andrespa]

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

[zagzebski]

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

[Clever_Anjos · Accepted solution]

This should execute an return your procedure

SQL EXEC BookOfBusiness;

[zagzebski]

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

[maxgro]

it seems you miss the right to execute the procedure

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

[Clever_Anjos]

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

[zagzebski]

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

[zagzebski]

Thanks - that was it.