Can we insert QVW data into a database table ?

[chiru_thota]

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

[atsushi_saijo]

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.

[vikasmahajan]

PFA sample Might be helpful for you.

Good Luck

Vikas

[chiru_thota]

Thanks Vikas for sharing Code.

Let me test and post the results here.

Thanks,

Chiru.

[stevedark]

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

[maxgro]

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

Posting Data from QlikView to Other Systems using the Ajax Client