Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

Anonymous
Not applicable
Author

Thank you Rob

rbecher
MVP
MVP

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

Astrato.io Head of R&D