topic Database management In Qlikview in QlikView

Database management In Qlikview

Anonymous — Fri, 02 Dec 2011 03:19:48 GMT

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.

Database management In Qlikview

rwunderlich — Fri, 02 Dec 2011 04:52:52 GMT

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

-Rob

Database management In Qlikview

Anonymous — Fri, 02 Dec 2011 04:57:14 GMT

Thank you Rob

Database management In Qlikview

rbecher — Fri, 02 Dec 2011 06:32:43 GMT

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