Database management In Qlikview

[Anonymous]

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.

[rwunderlich]

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

-Rob

[Anonymous]

Thank you Rob

[rbecher]

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