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?
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.
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.
