Data Ingestion
Microsoft SQL Server
Data Ingestion
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
| 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
For more information about working with extracts and pipelines, refer to their respective documentation sections.