Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Has anyone built an extension that can construct a SQL statement by putting current selections into where clause and send the SQL to a relational DB and retrieves and visualizes results? For instance, in an app there's a field called "sales person", if a user select a sales person George, I would like to send a SQL "select * from dbo.sales where sales_person='George'" and display the results in something similar to a straight table.
I believe the BigQuery extension is similar to what I am looking for but I have not seen it yet.
Thanks!
Lingxiang
Your best bet would be to build and publishe a webservice, which will take your call and current selections as parameters and returns you the data. Doing database connections and operations in javascript, behind extension, may not be a good practice, and it may make more sense to move that data base heavy load work to webservice. Youcan surely consume this webservice in QlikView, pass parameters, and get results in return.
Hope this helps.
Hi,
I think that it will be very usefull !! Direct Discovery is an option for real time query, but it could be a little bit too limited.
The Big Query example is what we would like but with a SQL connexion.
Thanks