- Amazon RDS
- Amazon S3
- Amazon Quicksight (Tableau as a backup)
- Talend (KNIME as a backup)
S3 + Lambda
- Upload file to S3
- Use Talend to access S3
- Clean data in Talend
- Upload updated file to S3
- Serve the S3 Bucket as a REST API end point using AWS Lambda
- Users can use HTTP(S) requests to access the file object in S3
S3 + Redshift + QuickSight
- Upload file to S3
- Use Talend to access S3
- Clean data in Talend
- Connect Redshift to S3
- Connect QuickSight to Redshift
- Users can use SQL queries in QuickSight to visualise data.