Oracle DB xml records: how can I load in QlikView!

[#1]

Anyone had any experience on how to load this kind of data. It is an Oracla data type. Basically they store data in a field as an xml tagged text.

For example take Customer table. The columns are:

IDREC; XMLRECORD
1; <CustName>Cusomter1<\CustName><CustAddress>Addres1<\CustAddress> ... etc

So actually all fields for the Customer are included in the xml record.

Any idea?

Regards

John

[mike_garcia]

Hi,

Have you tried to load the xml as Table File (the same way you would load an Excel file, or a QVD)?

I have loaded XML tables that way successfully.

Mike.

[#3]

hi,

I know that I can load xml files as tables. The problem is that I do not have xml files but a database (oracle) and the records in that field are stored as xml data.

Regards,

John

[#4]

Hello John,

Did you have any luck with this? I'm also trying to load xml froma database record.

Scott

[#5]

No unfortunatelly no. Seems like it can't be done by default. Just with work araounds: like loading the records as text and then pasing the text...

Regards,

John

[#6]

I have the same problem, any luck with it?

[#7]

Does any one have the solution for the problem ? if you have please share the same. Thanks

[deepakk · Accepted solution]

HI,

I have used macro to solve this kind of issue. I know that this isn't the stright forward solution. But this works fine for my scenario.

I have attach the application .You can modify the macro as per your requirement.

Deepak

[#9]

Hi Deepak

Thanks for your reply, does your solution read from Oracle XML database ? I think it seems different what I am looking. Actually I have to connect Oracle XML database dynamically .

Best Regards

Zubair Khan

[deepakk]

Hi,

No I am getting from SQL Server. I don't think the database matter. what matter is how the data is lying in rows or columns or some other weird formats.

Correct me if I am wrong

Deepak