topic Execute stored procedure in qliksense in App Development

Execute stored procedure in qliksense

govardhana_r — Thu, 09 Feb 2023 04:59:54 GMT

I am trying to execute a procedure to pull the data to qliksense however I am unable to connect. I get the below error

Load
*;
SQL EXEC qlik.sp_getTestData;

However the procedure exists in the DB and I am getting results when running from the SSMS

Vegar — Thu, 09 Feb 2023 05:51:35 GMT

Are you able to load a normal table from that database?

How does the FROM ... look like when you do that?

Could it be that your missing important info in your FROM adress? Like dbo. or something else?

Load
*;
SQL EXEC qlik.dbo.sp_getTestData;

Make also sure that you are connected to the correct Qlik DataConnection, so that you don't try to run on the wrong database server.

govardhana_r — Thu, 09 Feb 2023 07:01:57 GMT

Thanks Vegar. I had to add Database name to the query and then it worked

dbname.qlik.sp_getTestData