Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

Entered data can write back into DB?


Hi All,

my requirement is :data entry from users can be captured and can write back into DB.

is there any way to achieve it(Without Extension).

Anyone can help me out.

Thanks in advance!!

Regards,

Rathnam.

10 Replies
sundarakumar
Specialist II
Specialist II

Hi,

It is possible with Macros. PFB

http://community.qlik.com/docs/DOC-3054

http://community.qlik.com/docs/DOC-2784

Hope this helps.

-Sundar

rathnam_qv
Creator
Creator
Author

Hi Sundar,

Thanks for your reply..

i am using Oracle 11g. will this work for oracle.

Regards,

Rathnam.

rathnam_qv
Creator
Creator
Author

Hi,

i want to achieve it by using Inputbox.

once the user entered some comment by using the Inputbox..that data sholud write back to Database.

Regards,

Rathnam.

Anonymous
Not applicable

you need to write Macro as Kalaimani suggested for the Oracle DB connection and putting values to the DB/Tables

sundarakumar
Specialist II
Specialist II

S u can achive it with an action set on a text object or button as shown below

action.PNG.png

with macro it should be possible to write back to oracle i guess... Pls try it out and post on any issues u r facing on implementation.

-Sundar

rathnam_qv
Creator
Creator
Author

Hi Kalaimani,

Thanks for your reply.

i copied the zip folder from the first link and i am trying to run the .vbs file but,it's throwing an error(Provider can not be found. It may not be properly installed)

i am using Oracle11g.

Regards,

Rathnam.


jerrysvensson
Partner - Specialist II
Partner - Specialist II

For this to work the client need Oracle Oledb or ODBC installed locally.

rathnam_qv
Creator
Creator
Author

yes..they are installed

rathnam_qv
Creator
Creator
Author

Can any one give me step-by-step process how to achieve it.

i am using :Qlikview 11.2

                : Oracle 11g

Regards,

Rathnam.