> For the complete documentation index, see [llms.txt](https://docs.langstack.com/welcome/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.langstack.com/welcome/in-depth-learning/connectors/ms-sql-connector/using-ms-sql-connector-in-etl-pipeline.md).

# 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)