Skip to main content

Hello, is there anyone here who enabled there External File Storage in Acumatica SaaS?

My response was crafted with AI assistance, tailored to provide detailed and actionable guidance for your query.

Enabling External File Storage in Acumatica SaaS involves configuring the system to store files outside of Acumatica's database, typically using a cloud-based service like Amazon S3, Microsoft Azure Blob Storage, or Google Cloud Storage. This setup can help optimize database performance and manage large file storage requirements.

Steps to Enable External File Storage in Acumatica SaaS:

  1. Check Licensing and Feature Availability:

    • Ensure the External File Storage feature is enabled on the Enable/Disable Features (CS100000) form.
    • Verify that your Acumatica SaaS environment supports the chosen external storage service (e.g., S3, Azure Blob).
  2. Set Up External File Storage:

    • Navigate to File Storage Settings (SM202505) in Acumatica.
    • Select your desired File Storage Type (e.g., Amazon S3, Azure Blob Storage, etc.).
    • Provide the required configuration details, such as:
      • Access Key/Secret Key: For authentication.
      • Bucket/Container Name: The location for storing files.
      • Region/Endpoint: For cloud storage services like S3.
  3. Test the Configuration:

    • Use the Test Connection button to ensure Acumatica can connect to the external storage service.
    • Resolve any errors, such as incorrect credentials or permissions.
  4. Set File Storage as Active:

    • Once the connection is successful, set the external storage option as Active. This makes it the default file storage method.
  5. Migrate Existing Files (Optional):

    • If you already have files stored in the Acumatica database, you can migrate them to the external storage using the Migrate Files button in the same File Storage Settings form.
  6. Adjust Permissions and Security:

    • Ensure that the storage service has appropriate access policies for read/write operations.
    • Use encryption or security settings provided by the storage service to safeguard your data.
  7. Update System Workflows:

    • Verify that integrations and workflows dependent on file storage adapt to the external system.
    • Test file uploads, downloads, and attachments in common workflows.
  8. Monitor Usage:

    • Use monitoring tools in your external storage service to keep track of file uploads, downloads, and storage utilization.

Common Challenges:

  • Authentication Errors: Double-check keys and permissions.
  • Latency: Ensure the external storage is in the same region as your Acumatica instance to minimize latency.
  • Cost Management: Monitor storage costs, especially with large files or frequent accesses.

@michaelpanelo2021 - Enabling it is something support needs to do. Are you looking for someone who experienced using it in Saas?


We enabled it, and moved all of our files to an AWS S3 Bucket.

Here is anther article on the topic.
 

 


Good Morning,

In case for example you enable External File Storage and move all the attachments from Acumatica Storage to AWS S3, do you have an estimate how many GB will be transferred to AWS S3? Lets say I have an estimate of 280GB in my table “UploadFileRevision”.

 

Thank you.


Hi

I don't have the exact number. But it is less the 500 mb. I keep screen shot during the processes of the usage detail table and UploadFileRevisionis is not present from the top 10 from end of project. I just calculated UploadFileRevisionis the table its its just about 500 mb now. 

 

The processes of setup was very straight forward. I run lots of testing locally before i moved the files over. It might take a very long time to move the files over. I'm not sure if its depended on what resources the  instance is running on. I ran the “Move files to Storage” at first at 15 min then 1 hour to gauge how long the process will be. I ended up running the application over weekends only until all the files were moved over. I was concerned about how much recourses it would take up and had the time.

 


Reply