I have a requirement where we need to fetch the XML data stored in CLOB / BLOB from Oracle XML DB. I wanted to know -
1. Which connectivity we need to have between Qlik and ORACLE XML DB.
Introduction to Oracle XML DB - It says we can have JDBC; I am not sure if we can still do with ODBC OR OLEDB Drivers? If in case we need to follow JDBC can someone elaborate on the process ?
2. How efficient it be if we fetch the XML data from Oracle XML DB OR get directly from *.XMl files on the NAS Drive ( bypassing the Oracle altogether)
We are in process to figure out the best possible solution as data volume is huge and we wanted to execute 3 cycles per day.
