I have an OLTP AWS RDS(in postgresql and very normalized) that powers an application. I am trying to create a separate data warehouse(OLAP use case) also in AWS RDS(postgresql) using a star shchema. I am not considering redshift as it is more expensive and the amount of data does not warrant it. As an AWS newbie, my question is are there certain tool within the AWS stack that will allow me to build a data warehouse type RDS based of off an OLTP RDS? Any suggestions regarding data copying/data syncing between two RDSs etc. is of great help.
Asked
Active
Viewed 279 times
1 Answers
1
Have a look at Data Migration Service. I'm not saying it is what you need, but it might help. You're probably going to have to roll your own.
![](../../users/profiles/510610.webp)
bgdnlp
- 135
- 3
-
Thank you. I will research this tool. – gibbz00 May 15 '19 at 22:51