Skip to main content

​
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

ParameterRequiredDescription
NameYesA unique identifier for your SQL Server source
HostYesThe hostname or IP address of your SQL Server instance
PortYesThe port number on which SQL Server is running (default: 1433)
Database NameYesThe name of the database you want to connect to
Schema NameNoOptional schema name (default schema is ‘dbo’)
UserYesUsername with appropriate permissions to access the database
PasswordYesPassword 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:
  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.