Posted On: Mar 21, 2022
Amazon RDS for PostgreSQL adds support for tds_fdw which allows your PostgreSQL database to connect and retrieve data stored in separate SQL Server databases.
Foreign Data Wrappers are libraries for PostgreSQL databases that can communicate with an external data source, abstracting the details of connecting to the data source and obtaining data from it. tds_fdw is a PostgreSQL extension that provides a Foreign Data Wrapper for more easy and efficient access to SQL Server databases. Please see the list of supported extensions in the Amazon RDS User Guide for specific versions.