AWS – Amazon RDS for SQL Server supports linked servers to Teradata databases

Amazon Relational Database Service (Amazon RDS) for SQL Server now supports linked servers to Teradata databases. Linked server is a SQL Server feature that enables customers to read data and execute commands on remote database servers outside of the SQL Server instance. With this launch, customers can link their RDS for SQL Server instance to a Teradata database running on AWS or on premises.

To start setting up a linked server for Teradata, add the ODBC_TERADATA option to your RDS for SQL Server instance’s Option Group. Amazon RDS automatically installs and configures the Teradata ODBC driver, enabling you to run distributed queries, and execute SQL commands on your Teradata database from your RDS for SQL Server instance. Linked servers on RDS support distributed transactions through Microsoft Distributed Transaction Coordinator (MSDTC) and use TLS (Transport Layer Security) encryption for secure connections.

To learn more about setting up and using Teradata linked servers, refer to the Amazon RDS for SQL Server User Guide. This feature is available in all AWS Regions where Amazon RDS for SQL Server is available. See Amazon RDS for SQL Server Pricing for pricing details and regional availability.

Read More for the details.