Loading Data QVD to Oracle?

[skumarqv11]

Hi folks,

I have a QVD file, I want to load that data to Oracle. How can we do that?

Case 1:  Is there any way to do that without QVW?

Case2: Can we do that with QVW?

Thanks,

Shravan

[marcus_sommer]

Take a look here: Using QlikView for (bulk) INSERT into SQL and here: Write Back to Database via ETL process (using CSV or XML).

- Marcus

[skumarqv11]

Thanks for your reply.

Can we load data from QVD to Oracle without using Qvw file.

We can load data from Files to Oracle, But I hope it will not load data from Qvd file.

[marcus_sommer]

I assume that you could load the QVD's as a Binary large object - Wikipedia within your oracle but if you want to load the data into a regular data-table than you will need QVW's or storing the data extra as textfiles respectively instead of the QVD's.

- Marcus