Securing Seamless File Transfers: How Atreos Streamlined Data Exchange with AWS SFTP, Oracle NetSuite and Local
Customer Overview
Atreos Limited is a leading provider of innovative procurement solutions, focusing on optimizing supply chain operations through advanced technologies. As a rapidly growing enterprise, Atreos sought a secure, automated, and scalable solution for streamlined file transfers among local environments, Oracle NetSuite and AWS, addressing the challenge of ensuring secure data transfer and querying within their systems.
Challenges
Atreos faced several key challenges in implementing a seamless and secure SFTP file transfer solution:
Secure Integration with Oracle NetSuite: They needed a reliable method to pull data from NetSuite and securely transfer it to AWS without compromising security.
Access Control & Authentication: Atreos required strict access controls to ensure that only authorized users and services could access the SFTP server and sensitive data.
High Availability & Scalability: Ensuring that the file transfer solution could handle high-volume file transfers without disruption or downtime was critical for business continuity.
Monitoring & Audit Logs: It was essential to track file transfers and user access logs to ensure compliance with security and regulatory standards.
Solution: AWS SFTP Server on EC2 Windows Server
To address these challenges, Atreos implemented AWS Transfer Family (SFTP) with a local environment setup, using a public SFTP endpoint to transfer files from Oracle NetSuite to an S3 bucket securely. Additionally, a Microsoft server was configured with a private SFTP endpoint to securely handle file transfers from the cloud to the S3 bucket, ensuring a scalable and secure solution.
Key Features Implemented
- Integrated AWS Identity and Access Management (IAM) to control user access to the SFTP server.
- Automated file exports from Oracle NetSuite to the AWS SFTP endpoint.
- Configured the EC2 Windows Server as a secure point for ingesting the transferred files.
- Data was encrypted using TLS during transit and stored securely in Amazon S3.
- Set up Security Groups and Network ACLs to restrict unauthorized access to the SFTP server.
- Created a public endpoint for Oracle NetSuite to upload files and a private endpoint for secure access to stored data by the EC2 Windows Server.
- Enabled Amazon CloudWatch Logs to track all file transfers, access attempts, and security-related events.
- Configured CloudWatch Alarms to notify administrators in case of unauthorized access or failed transfers.
Results & Business Impact
- TLS encryption ensured the protection of data in transit and at rest.
- IAM-based authentication secured access, limiting it to authorized users and services only.
- Automated the export and transfer of files from Oracle NetSuite to AWS, eliminating the need for manual intervention.
- Ensured that files were securely stored in Amazon S3 and accessible by the Windows Server for processing.
- The EC2 Windows Server acted as a dedicated instance for handling high-volume file transfers, providing improved scalability.
- The private endpoint allowed secure and low-latency access to the stored data, ensuring operational efficiency.
- CloudWatch monitoring provided real-time insights into file transfer activities and system performance.
- Comprehensive audit logs supported compliance with security and data protection regulations, offering transparency for auditing and monitoring.
Conclusion
By implementing AWS Transfer Family (SFTP) on an EC2 Windows Server, Atreos successfully established a secure, automated, and scalable solution for file transfers from Oracle NetSuite to AWS. The solution not only enhanced data security but also streamlined operational efficiency, improved system reliability, and ensured compliance with industry regulations, driving smoother business operations and growth.
Next Steps
To learn more about how AWS and CIL can help your business,
Meet a few of our clients
Cecure Intelligence Limited is trusted by the most innovative and tech-forward companies who focus on customer experience without compromising on business goals.
Vodafone Group
Outscope IT
GBG PLC
Bank of Ireland
Vantage Towers
Jously
