Using MSSQL Connector in ETL pipeline

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

1. The MSSQL connector as source and an entity is the destination.

2. The MSSQL connector as a destination and an entity is the source.

Requirements

For both the examples below, the following is need to be created:

1. Create 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

Ensure data is 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. Establish connection through MSSQL connector. (click here to see steps for setting up MSSQL connector)