[Yandex Cloud documentation](../../../../index.md) > [Yandex Data Transfer](../../../index.md) > [Step-by-step guides](../../index.md) > [Configuring endpoints](../index.md) > Microsoft SQL Server > Source

# Transferring data from a Microsoft SQL Server source endpoint

Yandex Data Transfer enables you to migrate data from a Microsoft SQL Server database to Yandex Cloud managed databases and implement various data processing and transformation scenarios. To implement a transfer:

1. [Explore possible data transfer scenarios](#scenarios).
1. [Prepare the Microsoft SQL Server database](#prepare) for the transfer.
1. [Set up a source endpoint](#endpoint-settings) in Yandex Data Transfer.
1. [Set up one of the supported data targets](#supported-targets).
1. [Create](../../transfer.md#create) a transfer and [start](../../transfer.md#activate) it.
1. In case of any issues, [use ready-made solutions](../../../troubleshooting/index.md) to resolve them.

## Scenarios for transferring data from Microsoft SQL Server {#scenarios}

You can implement scenarios for data migration and delivery from a Microsoft SQL Server database to managed databases for further storage in the cloud, processing and loading into data marts for further visualization.

For a detailed description of possible Yandex Data Transfer scenarios, see [Tutorials](../../../tutorials/index.md).

## Preparing the Microsoft SQL Server database {#prepare}

Airbyte® has the following requirements for a Microsoft SQL Server data source:

1. Make sure your database is accessible from the computer running Airbyte®.
1. Create a dedicated read-only Airbyte® user with access to all tables that require replication.

For more information, see [this Airbyte® guide](https://docs.airbyte.com/integrations/sources/mssql).

Airbyte® is already built into Data Transfer, so you do not have to create a separate VM to deploy it and add a user. All you have to do is grant Data Transfer [network access](../../../concepts/network.md) to the source database.

## Configuring the Microsoft SQL Server source endpoint {#endpoint-settings}

When [creating](../index.md#create) an endpoint, select `MSSQL` as your database type and configure access to SQL Server. You can [change](../index.md#update) the settings after you create an endpoint.

{% list tabs group=instructions %}

- Management console {#console}

    * **Host**: IP address or FQDN of the host you need to connect to.
  
    * **Port**: Port number Data Transfer will use for connections to the host. 

    * **Database**: Name of the DB to connect to.

    * **Username** and **Password**: Database username and password.
  
    * **Replication method**: Replication method used to retrieve data from the database. `STANDARD` replication requires no setup on the database side, but it does not show data changes. `CDC` replication allows you to capture 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.
    
{% endlist %}

Read more about settings in [this Airbyte® guide](https://docs.airbyte.com/integrations/sources/mssql/).


## Configuring the data target {#supported-targets}

Configure one of the supported data targets:

* [MySQL®](../target/mysql.md)
* [MongoDB](../target/mongodb.md)
* [ClickHouse®](../target/clickhouse.md)
* [Greenplum®](../target/greenplum.md)
* [Yandex Managed Service for YDB](../target/yandex-database.md)
* [Apache Kafka®](../target/kafka.md)
* [YDS](../target/data-streams.md)
* [PostgreSQL](../target/postgresql.md)

For a complete list of supported sources and targets in Yandex Data Transfer, see [Available transfers](../../../transfer-matrix.md).

Make sure that the network hosting the target cluster is configured to allow connections from the internet. To enable internet access, [set up routing](../../../../vpc/tutorials/nat-instance/index.md).

After configuring the data source and target, [create and start the transfer](../../transfer.md#create).

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

_ClickHouse® is a registered trademark of [ClickHouse, Inc](https://clickhouse.com)._

_Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries._