Images in HANA

[AswinKumar]

Hi,

I wanted to store images into HANA DB. So i thought of using BLOB data type.

Next i thought of exposing this data via oData service. Later came to know that oData doesn't support BLOB entries.

So we started using php server to store the images.

So here are my questions

1) Is there any way to store images in HANA other than BLOB data type so that it can be exposed via oData?

2) Since php is causing TCO, I am also planning to migrate this oData service to xsjs so that BLOB can be used.So is it advisable to convert the oData to xsjs and also what would be the performance impact when storing and retrieving happening in HANA?

Thanks & regards,

Aswin

[sreehari_vpillai · Accepted solution]

Hi Aswin,

You can store the image file as string data type in hana. But, for file storage *CLOB data types are expected to be used. So , as you are not able to expose via OData, you can make use of an XSJS service to do the same. Consider that both OData and XSJS are web services are performance is proportional to the payload. In your case it does not make any difference in performance.

Sreehari