This is a Jitsu.Classic documentation. For the lastest version, please visit docs.jitsu.com. Read about differences here.

📜 Configuration

Configuration UI

Jitsu Internals

Jitsu Server

MSSQL

Overview

Microsoft SQL Server connector pulls data from the remote database.

The source is using Airbyte docker image (@airbyte/source-mssql). Learn more how Airbyte-based sources work

How to connect

Please read setup guide for more information.

Connection Parameters

ParameterDocumentation
host*
string
(required)
Hostname of the database.
port*
integer
(required)
Port of the database.
database*
string
(required)
Name of the database.
username*
string
(required)
Username to use to access the database.
password
string
(not required)
Password associated with the username.
ssl_method
object
(not required)
Encryption method to use when communicating with the database
replication_method
string
(not required)
Replication method to use for extracting data from the database. STANDARD replication requires no setup on the DB side but will not be able to represent deletions incrementally. CDC uses {TBC} to detect inserts, updates, and deletes. This needs to be configured on the source database itself.