You can use

Microsoft Azure Synapse SQL

Connector to read data from or write data to

Microsoft Azure Synapse SQL

.

When you use

Microsoft Azure Synapse SQL

Connector, you can create a

Microsoft Azure Synapse SQL

connection and use the connection in Data Integration mappings and tasks. You can use Microsoft SQL Server or Azure Active Directory authentication to connect to

Microsoft Azure Synapse SQL

.

You can use external tables as

Microsoft Azure Synapse SQL

sources in mappings. You can read data from or write data to

Microsoft Azure Synapse SQL

case-sensitive databases as well. You can create mappings and mapping tasks to read data from or write data to a

Microsoft Azure Synapse SQL

endpoint that resides in a virtual network (VNet).

You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.

A mapping in advanced mode can run on an advanced cluster hosted on Microsoft Azure, local cluster, or a self-service cluster.

Microsoft Azure Synapse SQL

Connector is optimized for large data sets and can perform better than traditional data integration methods, such as ODBC or JDBC. When you write data to

Microsoft Azure Synapse SQL

, the connector stages data files to Microsoft Azure Storage and uses T-SQL commands with Microsoft Polybase to extract or load relational and non-relational data in parallel.

You can connect to a serverless SQL pool when you read data from

Microsoft Azure Synapse SQL

.