How to writeback to the database without using web... - Qlik Community

Report Inappropriate Content · ‎2015-11-30

How to writeback to the database without using webservice? Please guide.

Report Inappropriate Content · ‎2015-11-30

Hi snehal,

Can you please elaborate more on what are you trying to do? That would be really helpful to solve your problem.

Regards,

KC

Anonymous · ‎2015-11-30

You are talking about general Database scenario or Qlik scenario?

Report Inappropriate Content · ‎2015-11-30

Hi,

In Qlik Scenario,

Some selections are made in Qv and the same should be updated in the database on click of a button.

Anonymous · ‎2015-11-30

QV is a analytical tool, it does not allow you to edit/insert/update data in database as per my understanding

vikasmahajan · ‎2015-12-01

Hope this help you https://community.qlik.com/docs/DOC-6386

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2015-12-01

Hi Vikas,

The link you have shared describes has details for the script level writeback.

I would like to know if the writeback can be performed without the use of webservice from the accesspoint/UI.

rwunderlich · ‎2015-12-01

You can write a macro that uses ADO to do the SQL work. I'm not sure (doubtful) that this would work on an Ajax client though.

-Rob

vikasmahajan · ‎2015-12-01

try with this code in VBscript

dim sConn, oConn

Set oConn = CreateObject("ADODB.Connection")

sConn = "Provider=MSDAORA;User ID="yourlogin";Password="yourpassword";Data Source="your data source";OLEDB.NET=true;SPPrmsLOB=true;Persist Security Info=False;"

oConn.Open sConn

sSQL="your request"

oConn.Execute(sSQL)

oConn.Close

Set oConn = Nothing

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.