What is the best practice for storing attachment files that were uploaded from RAP-Fiori application

[beampakorn]

Hi, I start learning SAP RAP from RAP100, RAP110
and find that in the tutorial, the attachment will be kept in the created database table as RAWSTRING

Is the way it's kept the attachment as RAWSTRING in a database table best practice?

Or can we pass the attachment binary to another content server and store only the ID that can linked with the attachment in the content server?

If we can use a content server, is there any document or tutorial to show me how to do it?

Thanks,
Pakorn

[beampakorn]

Are there anyway to link attachment file to BTP DMS?

[DominikTylczyn]

Hello @beampakorn 

Storage of attachment in database tables is in my opinion best practices. It can pass if attachments are really slow. Otherwise you are stuffing the database with large objects that don't need to be accessed very quickly. That is waste of DB space. Instead a dedicated content server should be used e.g. SAP Content Server

Attachments can then be stored and access with ArchiveLink interface.

Best regards

Dominik Tylczynski

[beampakorn]

Hi Dominik, if I want to use SAP Content Server I need to do something with abap code in Behavior Implementation when instance of entity is being created right?