Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sinanozdemir
Specialist III
Specialist III

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
Author

Somewhat similar to QlikView... thanks!

sinanozdemir
Specialist III
Specialist III

No problem.

Yeah, somewhat. Although, I still prefer QlikView

priyasawant
Creator II
Creator II

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

shraddha_g
Partner
Partner

semicolon is missing at the end of the SQL Statement.

priyasawant
Creator II
Creator II

SP execution is done successfully. Thank you Shraddha