Receiving SMS from users and stores in AWS

Question

I gave the requirement permission involving SMS and AWS platform, the requirement is that users can send SMS to a mobile number and I need to store those SMS and their metadata into AWS RDS or DynamoDB or any AWS compatible storage. These SMS will is getting populated to a realtime dashboard. Anyone here facing this issue? or any tools or technology I could use to resolve this issue?

Answer 1

Yes, you can do this using just AWS services!

Let me give you the services you need and their roles:

1. Amazon SNS - For sending SMS messages
2. Amazon RDS (MySQL, PostgreSQL, Aurora, Oracle DB) - You can create a Database instance in RDS and push the metadata of your SNS messages into the DB
3. DynamoDB (Optional) - You can choose between RDS and DynamoDB. If you prefer a NoSQL DB, choose DynamoDB
4. Amazon Quicksight - You can directly connect your RDS database to QuickSight and start creating real-time dashboards with it. You can also share these dashboards via email or embed it in your website/application.

It is a straightforward process and if you receive any difficulties, comment down and I will try to help.