Configuring a Microsoft SQL Server source endpoint

When creating or updating an endpoint, configure access to SQL Server.

Settings

Management console

Host: IP address or FQDN of the host you want to connect to.
Port: Port number Data Transfer will use for connections to the host.
Database: Name of the DB to connect to.
Username, Password: DB username and password.
Replication method: Replication method used to retrieve data from the database. STANDARD replication requires setup on the DB side, while it does not show data changes. CDC replication allows identifying data inserts, updates, and deletes.
SSL Method: Encryption method used when exchanging data with the database:
- UNENCRYPTED: Saving the password as plain text.
- ENCRYPTER (trust cert): Using a certificate from a trusted source.
- ENCRYPTER (verify cert): Using a self-signed certificate.

For more information about settings, see the Airbyte® documentation.

Airbyte® is a registered trademark of Airbyte, Inc in the United States and/or other countries.