Posted On: Apr 8, 2025
Amazon Relational Database Service (Amazon RDS) for SQL Server now supports linked servers to Teradata database in Amazon Web Services China (Beijing) Region, operated by Sinnet, and Amazon Web Services China (Ningxia) Region, operated by NWCD. 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 Amazon Web Services 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. See Amazon RDS for SQL Server Pricing for up-to-date pricing of instances, storage, data transfer and regional availability.
