Microsoft SQL Server connector overview - Amazon Q Business

Microsoft SQL Server connector overview

The following table gives an overview of the Amazon Q Business Microsoft SQL Server connector and its supported features.

Category Feature Support
Security Authentication type Basic
Authentication credentials
  • Username of database user

  • Password of database user

Access Control List (ACL) crawling Yes. For more information, see ACL crawling.
Driver version Microsoft SQL Server – 10.2.0.jre11
Data source version SQL Server 2019
Identity crawling No
VPC Yes
Crawl features Custom metadata Yes
Entities Yes. The following entities are supported:
  • Document

    Note

    Each database row is considered an individual searchable Amazon Q document.

Field mappings Yes. Supports both default and custom field mappings. For more information, see Field mappings.
Sync mode Supports full and incremental sync.
File types Supports all files supported by Amazon Q.