> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datazone.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft SQL Server

> Microsoft SQL Server is a relational database management system developed by Microsoft.

# Overview

Microsoft SQL Server is a robust relational database management system that enables secure and efficient data management. Datazone provides native integration with SQL Server to read data directly from your databases.

## Connection Parameters

Set on the source when you create it. Names match the API and CLI payload.

<ParamField path="name" type="string" required>
  **Name** — a unique identifier for your SQL Server source.
</ParamField>

<ParamField path="host" type="string" required>
  **Host** — hostname or IP address of your SQL Server instance.
</ParamField>

<ParamField path="port" type="string" required>
  **Port** — port the instance listens on. Typically `1433`.
</ParamField>

<ParamField path="database_name" type="string" required>
  **Database Name** — the database to connect to.
</ParamField>

<ParamField path="schema_name" type="string" default="dbo">
  **Schema Name** — schema that extracts resolve table names within.
</ParamField>

<ParamField path="user" type="string" required>
  **User** — username with read permission on the tables you intend to extract.
</ParamField>

<ParamField path="password" type="string" required>
  **Password** — password for the specified user. Stored encrypted.
</ParamField>

## Extract Parameters

Set per extract, in `source_parameters`. See [Shared Extract Parameters](/reference/sources/overview#shared-extract-parameters) for `mode`, `replication_key`, and `schema_mapping`.

<ParamField path="table_name" type="string" required>
  **Table Name** — the table or view to extract, resolved within the source's `schema_name`.
</ParamField>

<ParamField path="select_clause" type="string" default="*">
  Columns to read, as a comma-separated list.
</ParamField>

<ParamField path="filter_clause" type="string">
  Row filter pushed down to SQL Server, written without the `WHERE` keyword — for example `modified_at >= '2024-01-01'`.
</ParamField>

<Note>
  `batch_size` is fixed at 100,000 rows for SQL Server extracts and cannot be overridden in `source_parameters`.
</Note>

## Required Permissions

The SQL Server user account needs the following permissions:

* `SELECT` - For reading data from tables and views
* `VIEW DEFINITION` - For accessing object metadata
* `VIEW DATABASE STATE` - For viewing database state information
* `CONNECT` - For connecting to the database

## Limitations

Be aware of the following limitations when working with SQL Server sources:

* Some SQL Server-specific data types may be converted to standard formats
* CLR data types are not supported
* Individual query size and timeout limits apply
* Connection pooling settings may affect performance

## Next Steps

After configuring your SQL Server source:

1. Create extracts to specify which tables to ingest
2. Configure scheduling for recurring extracts
3. Integrate the source into your data pipelines

For more information about working with extracts and pipelines, refer to their respective documentation sections.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.