Qlik Data Gateway with SQL Stored Procedures

[jackm75]

Has anyone had success with setting up a data gateway to on-premise SQL server then executing a stored procedure? 

When I run it, it never returns data; just spins. However, if I run the raw query from the SP directly in the Qlik load script, it returns as expected. Does the Data Gateway set up just not like stored procedures? 

Example:

LOAD *;

SQL

EXEC [Server].[Schema].[StoredProcedure];

[rubenmarin · Accepted solution]

Hi, yes, and worked. There is an option 'Allow non-SELECT queries' in the SQL connector, try checking that option.

If still doesn't works check that you have the most updated version of Data Gateway. You will need to install, setup and configure again.

[jackm75]

Thanks @rubenmarin . Can't believe I missed that option on set up. Checking that box did the trick!