File Attachment Storage Options

By Chris Malek | Thu, Jan 12, 2012

When you are using the FileAttachment functionality in PeopleTools you have two options for storing the files. You can store them in the database or store them in an FTP site. Here are some of the items to consider.

File System: Pros

  • Easy to backup
  • Easy to manipulate outside of PeopleSoft by other systems
  • Easy to virus scan

File System: Cons

  • Security is administered outside of PeopleTools
  • Additional Step for development refreshes
    • You must change the URL so your DEV/TEST database does not delete production data
  • One more step for disater recovery

Database: Pros

  • Easier Refreshes
  • One security model: PeopleSoft security

Database: Cons

  • Increased database size
  • No way to easily view files outside of PeopleSoft Application
  • Harder to virus scan

My Verdict: Store the files in the database.

Article Categories
Author Info
Chris Malek

Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.

About Chris Work with Chris
Looking for pain-free PeopleSoft web services? 😀
PeopleSoft Simple Web Services (SWS)

Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.

Book
Integration Broker - The Missing Manual

I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.