DocsConnectors

Sql Server

Sql Server logo

Sql Server

Connect your Sql Server data to Airweave

Overview

The Sql Server connector allows you to sync data from Sql Server into Airweave, making it available for search and retrieval by your agents.

Configuration

SQLServerSource

SQL Server source implementation.

This source connects to a SQL Server database and generates entities for each table in the specified schemas. It uses database introspection to:

  1. Discover tables and their structures
  2. Create appropriate entity classes dynamically
  3. Generate entities for each table’s data
View Source Code

Explore the Sql Server connector implementation

Authentication

This connector uses a custom authentication configuration class: SQLServerAuthConfig.

Authentication Configuration

SQL Server authentication configuration.

host
strRequired

The host of the SQLServer database

port
intRequired

The port of the SQLServer database

database
strRequired

The name of the SQLServer database

user
strRequired

The username for the SQLServer database

password
strRequired

The password for the SQLServer database

schema
strDefaults to public

The schema of the SQLServer database

tables
strDefaults to *

Comma separated list of tables to sync. For example, ‘users,orders’. For all tables, use ’*’