Attachments stored on oracle database to be visible on Qlik Screen

[GaganKumar16]

Dear Team,

Please be informed that we are using QlikSense and creating reports taking source as Oracle Database. We have attachments of different types like pdf, word, png, jpg, etc. stored on oracle database in one of the tables as blob values. 

When we are trying to display these oracles stored attachments on Qlik screen, attachments are displaying as binary values (encrypted manner).

We are looking forward to show these attachments as icon on reports and once the end user will click on these icons, they can see the attachments.

We are not sure if this is possible from Qlik Sense but need guidance to proceed with this requirement.

[Jay_Brown · Accepted solution]

Hello @GaganKumar16 , unfortunately you won't be able to do this with the Qlik Oracle Connector.

Please see the following supported data types:
https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Oracle... 

Note that BLOB data types are omitted.

If you wish to have BLOB considered, you can also add to the topic here for the feature request, or create your own new Ideation:
https://community.qlik.com/t5/Suggest-an-Idea/Ability-to-store-and-render-BLOB/idi-p/1820830 

I hope that fully answers your questions and thanks for posting.

[GaganKumar16]

Dear Jay_Brown , 

Thank you for your reply and as you said it is not possible to show attachment via Qlik Directly.

As an alternative, we are planning to export the attachments from Oracle database stored as BLOB values. These attachments once exported can be saved at generic directory which can be accessible to end users.

Do you have any script handy that can help me in extracting these attachments from oracle database ?

[Jay_Brown]

Hello @GaganKumar16 , unfortunately this takes place on the Oracle side, but the best info I could find for simple ways to do this are here:
https://forums.oracle.com/ords/apexds/map/tech/developers/discussion/4103408/how-to-export-all-blob-... 
https://support.oracle.com/knowledge/Middleware/2753958_1.html 

I hope that helps!