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

Parameter	Required	Description
Name	Yes	A unique identifier for your SQL Server source
Host	Yes	The hostname or IP address of your SQL Server instance
Port	Yes	The port number on which SQL Server is running (default: 1433)
Database Name	Yes	The name of the database you want to connect to
Schema Name	No	Optional schema name (default schema is ‘dbo’)
User	Yes	Username with appropriate permissions to access the database
Password	Yes	Password for the specified user

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:

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

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

Get Started

Reference

Deployment

Tutorial

Microsoft SQL Server

Overview

Connection Parameters

Required Permissions

Limitations

Next Steps

​Overview

​Connection Parameters

​Required Permissions

​Limitations

​Next Steps

Overview

Connection Parameters

Required Permissions

Limitations

Next Steps