Introduction to Microsoft Azure Synapse SQL Connector

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.