Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Loading Qlik Sense from a stored procedure

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!

6 Replies
Highlighted
sinanozdemir
Valued Contributor III

Re: Loading Qlik Sense from a stored procedure

Yes, you can run stored procedures in QlikSense.

The load script will look like the below:

Capture.PNG

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

Not applicable

Re: Loading Qlik Sense from a stored procedure

Somewhat similar to QlikView... thanks!

sinanozdemir
Valued Contributor III

Re: Loading Qlik Sense from a stored procedure

No problem.

Yeah, somewhat. Although, I still prefer QlikView

priyasawant
Contributor

Re: Loading Qlik Sense from a stored procedure

Hi i am trying the same method but not able to load the store procedureStore.png

shraddha_g
Honored Contributor III

Re: Loading Qlik Sense from a stored procedure

semicolon is missing at the end of the SQL Statement.

priyasawant
Contributor

Re: Loading Qlik Sense from a stored procedure

SP execution is done successfully. Thank you Shraddha

Community Browser