Oracle Analytics Cloud and Server
Image file display using OAC
Summary:
We have a requirement to display image files in OAC. The files will be downloaded from Fusion using an API calls. We have the option to store it as a BLOB in DB Tables.
Or, the files could be written to object storage.
What would be the best approach to use, to display images through OAC (without requiring users to re-authenticate).
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Hi Amrita,
What would be the size of the image? are these dynamic with data or standard images? BLOB/CLOB datatype may not work in OAC/BI. Distinct function can not be applied on these but BI Server always forms query with distinct. If your images are standard then you can save those in OAC Custom image folder in Web Catalog from there you can provide path on reports.
-
Hi Subhakara,
Thanks for your response. The images are of invoices. Therefore, since the number of invoices are very large, the number of images are also very high in number. Based on the invoice number, the image should be displayed, by clicking on a link available in a detail report.
Yes, CLOB/BLOB is not supported in OAC. In OBIEE there seems to be a work around by using Java script, which is not supported by Oracle. Not sure if it is supported in OAC. Wanted to find out what the best approach would be?
-
Hi Amrita,
I recently saw a webinar (https://www.youtube.com/watch?v=wtbUzh2Wq1M) in which the image files are stored in object storage bucket for OAC visualization. you can check it out the video from 32.02 for reference. Not sure if it is the best apprach but yes its one way to use.
-
Hi Amrita,
If BI Publisher is available in the project then you can create parameterized BI publisher report , BIP reports support BLOB data type then you can pass parameter from OAC to view the respective image.
-
Thanks Alok, will test this approach.