FDW Federated Query from Redshift Serverless to RDS Microsoft SQL Options

Question

Hi,

FDW is available for RDS PostgreSQL & RDS MySQL

Options on how to Federated Query from Serverless to RDS Microsoft-SQL, I'm looking for a simple architecture and not multiple ETL for RDS MS-SQL only. Are there upgrades that perhaps occurred on this issue or other ways to query across accounts from Serverless to RDS MS-SQL?

Please Help
Regards

IC · Answer

**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**

Joseph · Answer

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/

FDW Federated Query from Redshift Serverless to RDS Microsoft SQL Options

Relevant content