Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I want suggestions from you ,
I am trying to give user as functionality that they can edit data from front end and this will write back to database.
what are the ways to do this.
One way is to build an extension.
This is possible but required good programming skills.
Feeling Qlikngry?
Maybe this: SQL Writeback from QlikView extension object. reduced the needed efforts.
- Marcus
Just to be entirely correct there are actually at least 5 approaches to do a write-back to another system from QlikView (depending on how you categorize them). There is not so much information here on Community on how to do it in a reliable way - with full examples.
The level of effort and risk is or could be rather high on any of these approaches. It does require insights into technologies that many QlikView developers might not have. So I have never seen this as recommended practice from Qlik - but it is feasible for some use-cases.
In most cases it would be safer and cheaper to buy third-party solutions to do this. There are several...
You're also aware of the huge can of worms you're about to open by giving user(s) read/write functionality to your back end databases, right?
yes , actually user wants to edit table record.
James advice is very sound. You should be very reluctant in saying yes to something that might have a huge cost. Implementing this might cost as much as 5 to 20 times as much time as building the regular QlikView application. So don't promise them that is will be a quick and easy extra that they get for free...