Microsoft Azure Synapse SQL Connector

Back Next

Connection switching example

You want to upgrade your existing mapping that uses the Microsoft Azure SQL Data Warehouse V2 connection to use the Microsoft Azure Synapse SQL connection.

Before you switch the connection, perform the following steps:

Open the existing Microsoft Azure SQL Data Warehouse V2 mapping that you want to upgrade to Microsoft Azure Synapse SQL.

The following image shows an existing mapping that uses the Microsoft Azure SQL Data Warehouse V2 connection and contains the configured advanced properties in the Target transformation:

The image shows an existing mapping that uses the Microsoft Azure SQL Data Warehouse V2 connection

The configured target object in this example is:

emp_conn_tgt

To retain the mapped fields from the field mapping when you switch the connection, on the

Field Mapping

tab, choose from the following

Field map options

menu in the Microsoft Azure SQL Data Warehouse V2 mapping:

To retain the fields automatically mapped after the switch, select

Automatic

To manually map the retained fields after the switch, select

Manual

When you select manual, after switching the connection, you have the option to automap using the previous mapping.

To switch the connection, in the

Connection

field, change the connection from Microsoft Azure SQL Data Warehouse V2 to Microsoft Azure Synapse SQL.

In the

Change Connection

dialog box, select the following properties, and click

Yes

Connection switch
. Switches to the connection that you select.

Retain field mapping
. Retains the configured field mappings from Microsoft Azure SQL Data Warehouse V2.

The following image shows the options that you must select:

The image shows the options that you must select to retain the advanced properties and field mapping

The object from Microsoft Azure SQL Data Warehouse V2 is retained.

The following image shows the switched connection with the same object:

The image shows the switched connection with the same object

The configured target advanced properties from the Microsoft Azure SQL Data Warehouse V2 mapping reflect in the Target transformation.

If you had selected Manual
on the

Field Mapping

tab in the Microsoft Azure SQL Data Warehouse V2 mapping and you want to reflect the field mappings in Microsoft Azure Synapse SQL, on the

Field Mapping

tab, select

Automap

, and then select

Previous Mapping

If you had selected Automatic
in Microsoft Azure SQL Data Warehouse V2, you do not have to perform this task.

Click

Save

In the following image, the configured mapped fields from the Microsoft Azure SQL Data Warehouse V2 mapping now reflects in the Microsoft Azure Synapse SQL mapping: The image shows the field mapping