Hi Experts,We have a requirement to get files from SFTP server and put in Appian Doc repository.The input we have received from client is that these files size can vary from 1MB to 1GB as there are multimedia files as well.What will be the recommended approach for meeting this requirement. Is it going to cause any impact on the performance of the server or not.What if total size of the files being moved to Appian doc repository exceeds 100 GB.In my assumption we will have to consider our existing cloud storage and request for extra if required. Is there any other server level configuration needs to be done and how can we manage memory in this case?
Thanks.
Discussion posts and replies are publicly visible
Spammy spam, oh so sly,Filling inboxes, oh my, my.Clickbait words and tricks they play,Trying to lead us all astray.
Spammy spam, we’ll delete you,No more tricks, we see right through.Unwanted emails, be gone far,Spammers, you won’t get too far.
Spammy spam, just a bother,Trying to sell what we don’t want, brother.We’ll report you, make you flee,No more spamming, let us be free.
Spammy spam, it’s no game,We won’t fall for your false claim.Respect our inbox, hear our plea,Spammers, now it's time to flee.
I think this mostly depends on the actual use case. Storage in the Appian cloud is not cheap. An external storage where you store the actual files, plus some meta data in the database might be an option.
Storing documents in Appian it's not the best approach.. I would use, if possible, an external document Management system (CM, Filenet, Documentum, Sharepoint...) in order to avoid problems
My production system had, approaching 1TB used (estimated) - there isn't really a hit on performance as long as someone's paying for it. (For reference, we developed a system to do the opposite of what you're saying, to take some bulky files and offload them to a bespoke sFTP server, for space and cost savings, which also worked pretty well. But prior to running it, there weren't any performance concerns per se.)
As long as the folks who are giving you this "requirement" are paying for the extra storage space from Appian, Appian will gladly sell it to you. Just make sure the client understands the cost trade-off is heavy.