Microsoft SQL Server
Use the Microsoft SQL Server connector to extract data from a Microsoft SQL Server database.
Setup
- Ensure your SQL Server instance is reachable from the environment running the connector (network routing, firewall rules, and allow-listing as needed).
- Create (or choose) a SQL Server login with permission to read the schemas/tables you want to sync.
- Collect the connection details:
- Host
- Port
- Database
- Username
- Password
Authentication
This connector authenticates using SQL Server authentication (username/password).
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
host | string | ✅ | SQL Server hostname or IP address. |
port | integer | ✅ | SQL Server port (commonly 1433). |
database | string | ✅ | Database name to connect to. |
username | string | ✅ | SQL Server username. |
password | string | ✅ | SQL Server password. |
Streams
This connector syncs tables from the configured database. Available streams depend on the schemas and tables your user can access.