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.
