topic Re: Can we insert QVW data into a database table ? in QlikView

Can we insert QVW data into a database table ?

chiru_thota — Tue, 04 Feb 2014 21:47:48 GMT

Hi All,

I have a QVW and 5 columns with data.

Can I insert those 5 columns data into a table in database ?

Thanks,

Chiru

Re: Can we insert QVW data into a database table ?

atsushi_saijo — Tue, 04 Feb 2014 23:09:29 GMT

The QlikView's ODBC driver is read only, therefore C, U, D is not capable.

However; we would be able to formulate the SQL statement based on the QlickView grid result using the one of the dimention. If you do INSERT/UPDATE or DELETE, simply 'UPDATE (fieldname)'&(value).....which we could copy & paste into SQL client and run.

Such is typically suitable for POC (proof of concept) purpose, inserting data into local DB as example to the customer etc.

Re: Can we insert QVW data into a database table ?

vikasmahajan — Wed, 05 Feb 2014 03:38:25 GMT

PFA sample Might be helpful for you.

Good Luck

Vikas

Re: Can we insert QVW data into a database table ?

chiru_thota — Fri, 07 Feb 2014 23:04:57 GMT

Thanks Vikas for sharing Code.

Let me test and post the results here.

Thanks,

Chiru.

Re: Can we insert QVW data into a database table ?

stevedark — Wed, 26 Feb 2014 23:48:58 GMT

Whilst there are ways that you can get QlikView to write to databases (with macro code etc.) I would always recommend de-coupling the QlikView process from the database process. By this I mean you could export your data from QVW after it has been loaded and processed into a CSV file and then load and merge that data using tools provided by the database (eg. SSIS for SQL Server).

This reduces the chances of something fouling up.

Hope that helps.

Steve

Re: Can we insert QVW data into a database table ?

maxgro — Thu, 27 Feb 2014 19:45:46 GMT

Write Back to Database via ETL process (using CSV or XML)

Posting Data from QlikView to Other Systems using the Ajax Client