FDW Federated Query from Redshift Serverless to RDS Microsoft SQL Options

Hi

As you noted, federated queries in Amazon Redshift currently support Amazon RDS for PostgreSQL, Amazon Aurora PostgreSQL-Compatible Edition, Amazon RDS for MySQL, and Amazon Aurora MySQL-Compatible Edition only. As you are looking for simple architecture, you can migrate MS SQL data to Aurora PostgreSQL and use Babelfish for Aurora PostgreSQL. You don't need to do any changes on the application side. Babelfish enables Aurora PostgreSQL to work with commonly-used SQL Server query tools, commands, and drivers. https://aws.amazon.com/rds/aurora/babelfish/

Thank You Joseph

It's a bit more complicated as I don't own the application/product and the source Prod RDS MS-SQL. It won't be possible for me to initiate or motivate for the change. Yes the architecture team will look to in future to have 1 RDS (PostgreSQL) but that's on the roadmap for 2025 Its only roughly 5 tables, are there other options perhaps, Could I have replication from MS-SQL to the PostgreSQL, thinking out loud.

Please Help, any ideas