Connecting Amazon RDS (Microsoft SQL Server) to Amazon Q Business

Amazon RDS (Microsoft SQL Server) is a relational database management system (RDBMS) built for the cloud. You can connect your Amazon RDS (Microsoft SQL Server) instance to Amazon Q Business – using either the AWS Management Console, CLI, or the CreateDataSource API – and create an Amazon Q web experience.

The Amazon Q Microsoft SQL Server data source connector supports MS SQL Server 2019.

Important

As a best practice, provide Amazon Q with read-only database credentials. Also, avoid adding tables with sensitive data or personal identifiable information (PII).

Learn more

• For an overview of the Amazon Q web experience creation process, see Configuring an application.

• For an overview of connector features, see Data source connector concepts.

• For information about connector configuration best practices, see Connector configuration best practices.

Topics

• Amazon RDS (Microsoft SQL Server) connector overview
• Prerequisites for connecting Amazon Q Business to Amazon RDS (Microsoft SQL Server)
• Connecting Amazon Q Business to Amazon RDS (Microsoft SQL Server) using the console
• Connecting Amazon Q Business to Amazon RDS (Microsoft SQL Server) using APIs
• How Amazon Q Business connector crawls Amazon RDS (Microsoft SQL Server) ACLs
• Amazon Q BusinessAmazon RDS (Microsoft SQL Server) data source connector field mappings
• IAM role for Amazon Q BusinessAmazon RDS (Microsoft SQL Server) connector
• Known limitations for the Amazon Q BusinessAmazon RDS (Microsoft SQL Server) connector