FDW Federated Query from Redshift Serverless to RDS Microsoft SQL Options

0

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
asked 2 months ago112 views
2 Answers
0

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/

Joseph
answered 2 months ago
0

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

IC
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions