azure - Azure 数据工厂复制事件使用什么协议(protocol)？

Question

我正在尝试使用 Azure 数据工厂通过自托管集成运行时复制数据。因为我们有本地数据库(sql、postgress、oracle)，中间有几个防火墙。我想知道链接服务使用什么协议(protocol)进行复制事件？是TCP吗？

提前致谢!

Answer 1

主要是https。来自 the docs :

自承载集成运行时运行需要哪些端口要求？

The self-hosted integration runtime makes HTTP-based connections to access the internet. The outbound ports 443 must be opened for the self-hosted integration runtime to make this connection. Open inbound port 8060 only at the machine level (not the corporate firewall level) for credential manager application. If Azure SQL Database or Azure Synapse Analytics is used as the source or the destination, you need to open port 1433 as well.

此外，除了 default ports ，以下场景需要开放1433端口。

Required only when you copy from or to Azure SQL Database or Azure Synapse Analytics and optional otherwise. Use the staged-copy feature to copy data to SQL Database or Azure Synapse Analytics without opening port 1433.