1 Answer
- Newest
- Most votes
- Most comments
0
Hi,
Not sure if you expecting the complete solution here, hope you are not :) Let me add some more details to your workflow:
- You can trigger Lambda when a new file is uploaded to the S3. Some examples you can find here: https://docs.aws.amazon.com/lambda/latest/dg/with-s3-example.html
- You need to write your custom Lambda function, which will unarchive, validate and parse Excel file and insert data to your RDS MySQL database. There are plenty of libraries available for any programming language you prefer.
Hope it helps.
Relevant content
- asked 4 months ago
- asked 2 years ago
- asked a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago