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 viewsVIEW DEFINITION
- For accessing object metadataVIEW DATABASE STATE
- For viewing database state informationCONNECT
- 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