topic Re: Loading Qlik Sense from a stored procedure in Visualization and Usability

Loading Qlik Sense from a stored procedure

Tue, 23 Jun 2015 18:22:58 GMT

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!

Re: Loading Qlik Sense from a stored procedure

sinanozdemir — Tue, 23 Jun 2015 18:42:45 GMT

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

Re: Loading Qlik Sense from a stored procedure

Tue, 23 Jun 2015 19:18:11 GMT

Somewhat similar to QlikView... thanks!

Re: Loading Qlik Sense from a stored procedure

sinanozdemir — Tue, 23 Jun 2015 19:20:15 GMT

No problem.

Yeah, somewhat. Although, I still prefer QlikView

Re: Loading Qlik Sense from a stored procedure

priyasawant — Fri, 23 Sep 2016 06:49:00 GMT

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

Re: Loading Qlik Sense from a stored procedure

shraddha_g — Tue, 27 Sep 2016 06:35:08 GMT

semicolon is missing at the end of the SQL Statement.

Re: Loading Qlik Sense from a stored procedure

priyasawant — Tue, 27 Sep 2016 07:14:52 GMT

SP execution is done successfully. Thank you Shraddha