topic Re: Qlik Data Gateway with SQL Stored Procedures in Data Movement & Streaming

Qlik Data Gateway with SQL Stored Procedures

jackm75 — Wed, 19 Mar 2025 23:06:21 GMT

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];

Re: Qlik Data Gateway with SQL Stored Procedures

rubenmarin — Tue, 08 Nov 2022 07:43:18 GMT

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.

Re: Qlik Data Gateway with SQL Stored Procedures

jackm75 — Tue, 08 Nov 2022 13:37:44 GMT

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