Mssql

Setting up the Mssql connector

No	Item	Required	Example	Notes
1	Host	Yes		The hostname of the database.
2	Port	Yes	1433	The port of the database.
3	Database	Yes	master	The name of the database.
4	Schemas	No		The list of schemas to sync from. Defaults to user. Case sensitive.
5	Username	Yes		The username which is used to access the database.
6	Password	No		The password associated with the username.
7	JDBC URL Params	No		Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
8	SSL Method	Yes		The encryption method which is used when communicating with the database. Refer to the documentation in the form while using the connector Unencrypted Encrypted (trust server certificate) Encrypted (verify certificate)
9	Replication Method	Yes		The replication method used 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. Refer to the documentation in the form while using the connector Standard Logical Replication (CDC)

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.