Amazon-rds – AWS RDS databases & SSIS

amazon-rdsawsssis

I have 2 AWS RDS databases (A & B) and need to create a datawarehouse with star scheme and slowly changing dimensions within AWS.

From a MS background it makes sense to create a SSIS package to run as a SQL job, which can collate the A & B databases and create dimensions and facts.

AWS RDS does not have SSIS support and I would therefore need to run an EC2 instance with SQL Server installed which then ran the SSIS package.

My questions is – is there any better way, assuming a heavy MS stack and AWS?

Best Answer

You can use several ETL tools for this, it could be on premies, or cloud based, final decision always depends from cost, corporate standards and many other moments

good starting point as most close to Your request:

Any tools and recommendations always depends from personal experience and of course on the market You can find more commercial and open source tools