Solved: QliView to DataBase - Qlik Community

Report Inappropriate Content · ‎2013-11-28

Hi everyone,

Please how to insert data directly through a form , from QlikView to database ( Access 2007 )?

Regards.

Anonymous · ‎2013-11-28

Hi

QlikView is a BI Dashboard / Analysis tool that is very good at reading data from databases and is not designed to write to them.

There are various methods, some most obtuse, to warp what is was designed for and write back to databases, but I personally concentrate on QlikView's out of the box strengths.

Best Regards, Bill

View solution in original post

Anonymous · ‎2013-11-28

Hi

QlikView is a BI Dashboard / Analysis tool that is very good at reading data from databases and is not designed to write to them.

There are various methods, some most obtuse, to warp what is was designed for and write back to databases, but I personally concentrate on QlikView's out of the box strengths.

Best Regards, Bill

Clever_Anjos · ‎2013-11-28

Best way (and easiest) is exporting to csv and importing using your database tools

Anonymous · ‎2013-11-28

Hello,

Qlikview not can insert data to DataBase

Report Inappropriate Content · ‎2013-11-28

thanks a lot for your reply...

mark_casselman · ‎2013-11-28

Hi,

In fact QlikView CAN insert data into databases. It is not standard functionality, but it can be done through macros. Check some other articles on the forum and/or try google.

For example check thread http://community.qlik.com/thread/61660

Mark