URL-link from Qlikview to querry BLOB file stored in Oracle
Hi all Qlikview exports
I have a question how to use URL links from Qlikview to an Oracle database 11G storing backups of documents in different formats (doc, docx, xls, xlsx, pdf ppt, pptx etc). All documents are stored as BLOBS in the database table.
It's no option to import the BLOBs into Qlikview model since the data volume is to large. The best option is to search the document number in Qlikview, then have a URL link in the report that the user clicks to querry the document. This URL link is for read only. No changes or other updates are required.
Is does not matter if this URL link uses qlikview scripting code, java, ODBC or any other code as long it communicates with Oracle DB.