Connecting Amazon RDS (Microsoft SQL Server) to Amazon Q Business
Note
Amazon RDS (Microsoft SQL Server) connector remains fully supported for existing customers through May 31, 2026. While this connector is no longer available for new users, current users can continue to use it without interruption. We are continuously evolving our connector portfolio to offer more scalable and customizable solutions. For future integrations, we recommend exploring the Amazon Q Business Custom Connector Framework[1], designed to support a broader range of enterprise use cases with enhanced flexibility.
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).
Topics
Known limitations for the Amazon RDS (Microsoft SQL Server) connector
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 RDS (Microsoft SQL Server) data source connector field mappings
Learn more
-
For an overview of the Amazon Q web experience creation process using IAM Identity Center, see Configuring an application using IAM Identity Center.
-
For an overview of the Amazon Q web experience creation process using AWS Identity and Access Management, see Configuring an application using IAM.
-
For an overview of connector features, see Data source connector concepts.
-
For information about connector configuration best practices, see Connector configuration best practices.
Known limitations for the Amazon RDS (Microsoft SQL Server) connector
-
Deleted database rows will not be tracked in when Amazon Q checks for updated content.
-
The size of field names and values in a row of your database can't exceed 400KB.
-
If you have a large amount of data in your database data source, and do not want Amazon Q to index all your database content after the first sync, you can choose to sync only new, modified, or deleted documents.
