Microsoft Azure Synapse SQL Connector > Introduction to Microsoft Azure Synapse SQL Connector > Microsoft Azure Synapse SQL Connector overview
  

Microsoft Azure Synapse SQL Connector overview

Microsoft Azure Synapse SQL Connector enables you to read data from or write data to Microsoft Azure Synapse SQL. You can use Microsoft Azure Synapse SQL connection in mappings, elastic mappings, mapping tasks, dynamic mapping tasks, and data transfer tasks.
You can also use Microsoft Azure Synapse SQL connector to collate and organize the details from multiple input sources and write the data to Microsoft Azure Synapse SQL. You can use external tables as Microsoft Azure Synapse SQL sources in mappings and elastic mappings.
You can read data from or write data to a 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 reside in a virtual network (VNet). Configure the Hosted Agent or the Secure Agent to connect to Microsoft Azure Synapse SQL.
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 a 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 use Microsoft SQL Server or Azure Active Directory authentication to connect to Microsoft Azure Synapse SQL.