Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
AndrewK
Contributor

Qlik Sense - allow user to change data sources outside of the "data load editor"

I am new to Qlik Sense, but I have taken on some existing Qlik Sense applications with worksheets that pull data from an SQL database.  I would like to allow users to use the applications and worksheets, but only want them to focus on the "Analyze" component (not edit the sheets, not modify the data load editor or data model). Currently, when changing databases, the user needs to modify the connection within the "Data Load Editor" - this editor houses scripting code I would NEVER want my users to be able to modify (or even see). I am looking for strategies to allow for a user to modify databases (or data sources), outside of the Data Load Editor:

Using the application - create a sheet to pick the data source?

Use a script or make my own app to swap out the database that the sheets point to?

Other?

2 Replies
rwunderlich
Partner Ambassador/MVP

Just to understand your workflow.  After the user changes the database, they need to reload the application to get the new data correct?  How do they trigger the reload?

Is there a set number of pre-defined databases you need the users to select from?

-Rob

AndrewK
Contributor
Author

Hi Rob,

There are new databases "all the time". Imagine training results for one student, for a test event, in a database, or daily sales tracked in 1 database. I want to allow an "evaluator" to view the student results without the ability to view the data load scripts, or edit the sheets ideally.

With current state of affairs, I need to "operate the system" to make the new connection and load the data... or swap out the database and reload the data. I am trying to see if there is a way to evolve the system such that it can be given to a trainer, with no Qlik knowledge, and they can "change students" to look at the results.

Also, I am working with a team of various software developers, so creating scripts, batches, web applications, custom applications is not a problem.

Thanks,

Andrew