topic Re: Loading Data QVD to Oracle? in QlikView

Loading Data QVD to Oracle?

skumarqv11 — Wed, 11 Jul 2018 06:08:33 GMT

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

Re: Loading Data QVD to Oracle?

marcus_sommer — Wed, 11 Jul 2018 07:26:23 GMT

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

Re: Loading Data QVD to Oracle?

skumarqv11 — Wed, 11 Jul 2018 09:49:08 GMT

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.

Re: Loading Data QVD to Oracle?

marcus_sommer — Wed, 11 Jul 2018 10:22:28 GMT

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