topic QlikSense Table from Stored Procedure in App Development

QlikSense Table from Stored Procedure

Wed, 06 May 2015 15:28:26 GMT

Hi,

I'm new to QlikSense but was wondering, is it possible to pull the results from a stored procedure inside a SQL database into a Qlik Table? That is, can you do something like:

LIB CONNECT TO 'SQL DB';

QlikTable:

LOAD

SQL EXECUTE dbo.sqldb_storedprocedure_SelectAll;

If this is not possible, is there a work around to get similar results?

Thanks...

Nick

Re: QlikSense Table from Stored Procedure

Gysbert_Wassenaar — Wed, 06 May 2015 15:42:26 GMT

It should work afaik. The sql statement is passed as is to the source database. If it returns a result set then that should be loaded into the table. The stored procedure can't return a cursor. If it doesn't work you can try creating a view in the source database and select the view as source table.