Microsoft Azure SQL Data Warehouse Connector Overview
Microsoft Azure SQL Data Warehouse Connector enables you to read data from or write data to Microsoft Azure SQL Data Warehouse. You can insert or upsert data to or delete data from a Microsoft Azure SQL Data Warehouse target.
Microsoft Azure SQL Data Warehouse is an enterprise-class, data-warehouse-as-a-service. It is a distributed database in the Azure Cloud that can process relational and non-relational data.
When you read data from or write data to Microsoft Azure SQL Data Warehouse, you can specify the Hosted Agent or the Secure Agent.
Microsoft Azure SQL Data Warehouse Connector is optimized for large data sets and can perform better than traditional data integration methods, such as ODBC or JDBC. When you read data from or write data to a Microsoft Azure SQL Data Warehouse, 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.
For example, you work in sales operations and you frequently need to analyze a high volume of data to improve operational intelligence. You design a mapping to read data from Salesforce and other transactional systems and aggregate the data. You create a summary table in Microsoft Azure SQL Data Warehouse that you can query against to assess your sales organization's performance.