将其他服务与 Synapse SQL 池(数据仓库)集成Integrate other services with a Synapse SQL pool (data warehouse)

借助 Azure Synapse Analytics 中的 SQL 池功能,用户能够与 Azure 中的许多其他服务集成。The SQL pool capability within Azure Synapse Analytics enables users to integrate with many of the other services in Azure. 使用 Synapse SQL,可以通过其 SQL 池资源创建数据仓库,然后可以使用多个附加服务,其中一些服务包括:Using Synapse SQL, you can create a data warehouse via its SQL pool resource, which can then utilize several additional services, some of which include:

  • Azure 数据工厂Azure Data Factory
  • Azure 流分析Azure Stream Analytics

Azure 数据工厂Azure Data Factory

Azure 数据工厂为用户提供一个托管平台,用于创建复杂的提取和加载管道。Azure Data Factory gives users a managed platform to create complex extract and load pipelines. SQL 池与 Azure 数据工厂的集成包括:SQL pool integration with Azure Data Factory includes:

  • 存储过程:协调存储过程的执行。Stored Procedures: Orchestrate the execution of stored procedures.
  • 复制:使用 ADF 将数据移动到 SQL 池。Copy: Use ADF to move data into SQL pool. 实际上,此操作可以使用 ADF 标准数据移动机制或封面下的 PolyBase。This operation can use ADF's standard data movement mechanism or PolyBase under the covers.

有关详细信息,请参阅与 Azure 数据工厂集成For more information, see Integrate with Azure Data Factory.

Azure 流分析Azure Stream Analytics

Azure 流分析是复杂、完全托管的基础结构,用于处理和使用从 Azure 事件中心生成的事件数据。Azure Stream Analytics is a complex, fully managed infrastructure for processing and consuming event data generated from Azure Event Hub. 通过与 SQL 池集成,可以有效地处理流数据,并将其与关系数据一起存储以实现更深入、更高级的分析。Integration with SQL pool allows for streaming data to be effectively processed and stored alongside relational data enabling deeper, more advanced analysis.

  • 作业输出: 将流分析作业的输出直接发送到 SQL 池。Job Output: Send output from Stream Analytics jobs directly to SQL pool.

有关详细信息,请参阅与 Azure 流分析集成For more information, see Integrate with Azure Stream Analytics.