问题描述
Azure数据工厂中的Salesforce连接器是否使用Bulk API?或者有这样做吗?
Does the Salesforce connector in Azure Data Factory use the Bulk API or is there anyway to do so?
从Salesforce到Azure SQL DB(美国东部)，我得到的速度仅为3-4 Mbps.我尝试使用查询方法(这是我们首选的方法，因为我们要进行增量加载)和对象方法，但是两者仍然很慢.
I am only getting about 3-4 Mbps going from Salesforce to Azure SQL DB (East US). I have tried using the query method (which is our preferred method because we do delta loads) and the Object method, but both a still very slow.
只需寻找加快速度的方法.
Just looking for ways to speed this up.
推荐答案
根据此: ADF尝试尽可能多地使用BULK API，但在某些限制下可能会退回到REST API.
According to this post: ADF tries to use BULK API as much as possible, but may fall back to REST API in certain constraint.
要提高性能，可以使用并行复制和分段复制.希望这个链接为您提供正确的方向.
To improve the performance, you could use parallel copy and staged copy. Hope thislink gives you right direction.
谢谢.
这篇关于Salesforce数据连接器和BULK API的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！