Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Qlikview is designed only to read from databases. If you want to update databases, choose another tool.
-Rob
Thank you Rob
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