Loading Qlik Sense from a stored procedure

[#1]

Looking at the way you walk me through a database connection by selecting tables, I dont yet see a way to connect and run a stored prodecure as a data source.  Is that even possible in this product?  Is the script syntax similar to Qlik View?

Thanks!

[sinanozdemir]

Yes, you can run stored procedures in QlikSense.

The load script will look like the below:

I use stored procedures all the time and you just connect to database as how you would connect through an ODBC connection, then insert a connection string. After that if you know the stored procedure name, you can type exact the same way in the screenshot.

So I am connecting to Test_Server and running a stored procedure called test.

Hope this helps

[#3]

Somewhat similar to QlikView... thanks!

[sinanozdemir]

No problem.

Yeah, somewhat. Although, I still prefer QlikView

[priyasawant]

Hi i am trying the same method but not able to load the store procedure

[shraddha_g]

semicolon is missing at the end of the SQL Statement.

[priyasawant]

SP execution is done successfully. Thank you Shraddha