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.
put on hold as off-topic by womble♦ May 16 at 2:21
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Requests for product, service, or learning material recommendations are off-topic because they attract low quality, opinionated and spam answers, and the answers become obsolete quickly. Instead, describe the business problem you are working on, the research you have done, and the steps taken so far to solve it." – womble
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.