Home icon

How to configure a Linked Server between Amazon RDS for SQL Server and Teradata database

Database Blog

This article explains how to configure a linked server between Amazon RDS for SQL Server and a Teradata database, enabling cross-database querying and data integration.

  • Supported for SQL Server versions 2017-2022 and Teradata 17.20
  • Requires creating an ODBC-enabled option group in AWS RDS
  • Uses MSDASQL provider and Teradata ODBC driver to establish connection
  • Allows querying Teradata databases using T-SQL statements
  • Supports secure connections with TLS encryption

The configuration involves creating a linked server using stored procedures, specifying connection details like server name, credentials, and optional encryption settings. Users can then perform distributed queries across SQL Server and Teradata databases.

Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Mar 25
2025
Amazon RDS for SQL Server supports linked servers to Teradata databases
Jul 17
2025
Amazon RDS for SQL Server now supports linked servers with Oracle OLEDB Driver version 21.16
Jun 16
2025
Native SQL Server replication options on Amazon RDS Custom for SQL Server
Dec 12
2025
Configure additional storage volumes with Amazon RDS for SQL Server

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.