TerranceK4053 Member since 2018 44 posts
Posted: 11 months ago
Last activity: 9 months 3 weeks ago

Storing Attachments

We will have on average 5 attachments per case and each attachment to a case would be on average 10 meg in size. Currently we are storing attachments in the Pega database but I'm concerned whether this is a good idea or not. Perhaps we should be using a repository that Pega supports? What is the downside of using database to store the attachments? Gets expensive because the DB will grow large? Performance? What is Pega's recommendation for this?

I see there is an option in application rules to switch to a repository which I am not too familiar with but I assume it means storing attachments on a file server on the cloud since our app is running in the pega cloud. Can we easily switch to use repository and still get to our current attachments that were attached in the database? IS the switch from database to repository transparent? In other words do we have to change our application code besides the application rule(s)? We do have a feature in the application where we perform a word merge and attach cases and display the case via some common built in Pega activities. Should that still work?

***Edited by Moderator Marissa to update platform capability tags****

Low-Code App Development Cloud Services System Administration Data Integration
Share this page LinkedIn