Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The dedicated SQL pool (formerly SQL DW) capability within Azure Synapse Analytics enables users to integrate with many of the other services in Azure. A dedicated SQL pool can utilize several additional services, some of which include:
- Azure Data Factory
- Azure Stream Analytics
Azure Data Factory
Azure Data Factory gives users a managed platform to create complex extract and load pipelines. Dedicated SQL pool (formerly SQL DW) integration with Azure Data Factory includes:
- Stored Procedures: Orchestrate the execution of stored procedures.
- Copy: Use ADF to move data into dedicated SQL pool (formerly SQL DW). This operation can use ADF's standard data movement mechanism or PolyBase under the covers.
For more information, see Integrate with Azure Data Factory.
Azure Stream Analytics
Azure Stream Analytics is a complex, fully managed infrastructure for processing and consuming event data generated from Azure Event Hub. Integration with dedicated SQL pool (formerly SQL DW) allows for streaming data to be effectively processed and stored alongside relational data enabling deeper, more advanced analysis.
- Job Output: Send output from Stream Analytics jobs directly to a dedicated SQL pool (formerly SQL DW).
For more information, see Integrate with Azure Stream Analytics.