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).

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

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