The Microsoft SQL Server connector

You can use this connector for source endpoints.

Refer to the Airbyte documentation to see the Amazon Redshift data types mapping table .

Source endpoint configuration

  1. Specify the address of the Host containing your database.

  2. Specify the database Port to connect to.

  3. Enter the name of the Database.

  4. Specify the Username of the existing database user with proper permissions.

  5. Enter the Password for the database user.

  6. Select a Replication method:

    • Standard
      This replication method requires no configuration on the Microsoft SQL Server side, so it's easier to utilize. In this case, DoubleCloud doesn't track INSERT, UPDATE and DELETE operations performed in the database. You need to specify cursor columns manually when you create a transfer.

    • CDC
      This replication method requires that you enable and configure Change Data Capture (CDC) on the Microsoft SQL Server side. After that, you can transfer CDC tables effortlessly and perform incremental sync.

  7. Select an SSL method of encryption:

    • Unencrypted doesn't apply any encryption.

    • Encrypted (trust cert) checks if a certificate exists and after that allows access.

    • Encrypted (verify cert) checks if a certificate exists and validates the host name. When selecting this method, go to the Encrypted (verify cert)Host Name In Certificate box and enter the host name in the database. The Transfer will compare it with the name in the certificate and allow the transfer if the comparison is successful. Note that this method requires that you configure the certificate on the source database side.