Integrations / Databases & Warehouses / Microsoft SQL Server (MSSQL)

Microsoft SQL Server (MSSQL)

A data source for your Jourier workspace. Enter the database address and a read-only login.

Set-up
Self-service
Credentials
Username and password
Modules
Custom builds
Vendor docs
docs.airbyte.com
Notes
Alternative auth: Entra ID service principal (client_id, client_secret, optional tenant_id fields in the spec) instead of username/password — worth exposing for Azure SQL customers. Replication method (standard cursor vs CDC), SSL mode (defaults to encrypted), schema selection, and SSH tunnel options are sync/connection settings handled outside the credential form.

What you need at hand

FieldWhere it comes from
HostThe hostname of the database.
PortThe port of the database.
DatabaseFor example master
Username (optional)The username used to access the database. Not required if Microsoft Entra ID authentication is used instead.
Password (optional)The password associated with the username. Not required if Microsoft Entra ID authentication is used instead.

Connect Microsoft SQL Server (MSSQL).

Pick it at sign-up, or add it later from the workspace. Free for a month.