When you replace the source or target connection type in existing mappings or mapping tasks that use the Microsoft Azure Synapse SQL ODBC connection, Microsoft Azure SQL Data Warehouse V1 connection, or Microsoft Azure SQL Data Warehouse V2 connection with the Microsoft Azure Synapse SQL connection, you have the option to retain the configured advanced properties and the field mappings.
The following table lists the configured advanced source, lookup, and target properties from the Microsoft Azure Synapse SQL ODBC connection that are retained in Microsoft Azure Synapse SQL mappings:
Properties
Microsoft Azure Synapse SQL ODBC properties retained in Microsoft Azure Synapse SQL
Source
- Pre SQL
- Post SQL
lookup
- Pre SQL
- Post SQL
Target
- Pre SQL
- Post SQL
The following table lists the configured advanced source, lookup, and target properties from Microsoft Azure SQL Data Warehouse V1 retained in Microsoft Azure Synapse SQL mappings:
Properties
Microsoft Azure SQL Data Warehouse V1 properties retained in Microsoft Azure Synapse SQL
Source
- Azure Blob Container Name
- Field Delimiter
- Number of concurrent connection to Blob Store
- Quote Character
Lookup
- Azure Blob Container Name
- Field Delimiter
- Number of concurrent connection to Blob Store
- Quote Character
Target
- Azure Blob Container Name
- Field Delimiter
- Number of concurrent connection to Blob Store
- Quote Character
The following table lists the configured advanced source, lookup, and target properties from Microsoft Azure SQL Data Warehouse V2 retained in Microsoft Azure Synapse SQL mappings:
Properties
Microsoft Azure SQL Data Warehouse V2 properties retained in Microsoft Azure Synapse SQL