Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
anuragsapanbhar
New Contributor III

Database management In Qlikview

Hi,

I am bit new to Qlikview. And need help in database connectivity through this. Is it possible to do a database management through Qlikview. I want to connect to a QVD or MDB file. Where I can store, retrive, append, delete and modify records. Can somebody help me in this, or can provide any documentation for the same please.

3 Replies

Database management In Qlikview

Qlikview is designed only to read  from databases. If you want to update databases, choose another tool.

-Rob

anuragsapanbhar
New Contributor III

Database management In Qlikview

Thank you Rob

MVP
MVP

Database management In Qlikview

Hi Anurag,

with our JDBC Connector for QlikView you can write back into databases during load script which moves QlikView in a total new area where you can use it as ETL, workflow or profiling tool:

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

It supports DDL and DML statements. You will get a result set if a DML statement was executed with the update count.

You can run script calls like this:

result:

SQL create table test (col1 INT);

SQL insert into test (col1) values (1);

SQL update test set col1=2;

SQL drop table test;

- Ralf

Community Browser