Connecting Microsoft SQL Server to Amazon Q Business
Microsoft SQL Server is an relational database management system (RDBMS) developed by Microsoft. You can connect your 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 Microsoft SQL Server connector
- Microsoft SQL Server connector overview
- Prerequisites for connecting Amazon Q Business to Microsoft SQL Server
- Connecting to Microsoft SQL Server using the console
- Connecting to Microsoft SQL Server using APIs
- How connector crawls Microsoft SQL Server ACLs
- Microsoft SQL Server data source connector field mappings
- IAM role for Microsoft SQL Server connector
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.
