# Using MS-SQL connector in ETL pipeline

The following examples show how the MSSQL connector can be used: 

1. In example 1, the MSSQL connector is the source, and an entity is a destination**.**
2. In example 2, the MSSQL connector is the destination, and an entity is the source.

### **Prerequisites for the examples**

For both the examples below, the following are created:

1. An Entity with the name TEST\_MSSQL\_Entity with the following fields:

* `customer_id` as `integer` and is the `Primary Key`
* `customer_name` as `string`
* `customer_email` as `string`
* `Active_status` as `boolean`

Data has already been added to the entity.

2\. MSSQL table with columns to be mapped to the entity:

* `customer_id` as `integer` 
* `customer_name` as `varchar`
* `customer_email` as `varchar`
* `Active_status` as `bit`

3\. Connection is established through the MSSQL connector. [(click here to see steps for setting up the MSSQL connector)](#setting-up-mssql-connector)