We are planning following to transfer data to Salesforce:
Data bricks to do logic transformation and put result in sql to use existing ADF Salesforce connector to load.
Want to know if ADF supports latest bulk Salesforce API which is Bulk API 2.0?
While creating linked service to Salesforce I don't see it in apiversionz
我们计划将数据传输到Salesforce:数据块进行逻辑转换,并将结果放入SQL中,以使用现有的ADF Salesforce连接器进行加载。想知道ADF是否支持最新的Bulk Salesforce API,即Bulk API 2.0?在创建链接到Salesforce的服务时,我在版本中看不到它
更多回答
Please provide enough code so others can better understand or reproduce the problem.
请提供足够的代码,以便其他人能够更好地理解或重现问题。
优秀答案推荐
Been a while since I used Azure Data Factory. The ADF2 plugin available on marketplace is provided for free by "Simba Technologies". Their page says it's on API v 45 at the moment, 8 releases behind so almost 3 years. You could try asking them but you aren't their customer directly so you don't have much leverage...
我已经有一段时间没有使用Azure Data Factory了。市场上提供的ADF2插件是由“Simba Technologies”免费提供的。他们的主页上说,目前是在API v 45上,比现在晚了近3年的8个版本。你可以试着问他们,但你不是他们的直接客户,所以你没有太多的筹码……
In theory it should be fine, the ingest
endpoint first appeared in API 41.
理论上应该没问题,摄取终点最早出现在API 41中。
Whether they implemented it - ultimately you will have to try it out. Prepare a big job (over 10K records), load it. Examine login history to check the API version used. Go to Setup, start searching "bulk" and check if there's a job or was it loaded old school way, 200 records at a time...
不管他们是否实施了--最终你将不得不试一试。准备一个大作业(超过10K条记录),加载它。检查登录历史记录以检查使用的API版本。进入设置程序,开始搜索“Bulk”,检查是否有工作,或者是以传统的方式加载的,一次200条记录……
ADF now has a built-in Salesforce Connector. It uses Bulk API V1 but thats perfectly respectable - Bulk API V1 and V2 co-exist and V1 is better in some ways*
ADF现在有一个内置的Salesforce连接器。它使用散装API V1,但这是非常好的-散装API V1和V2共存,V1在某些方面更好*
The ADF Salesforce Connector is pretty good but if you want to retrieve the results of a bulk load (which rows failed etc) you have to jump through a few hoops, see blog post about it.
ADF Salesforce连接器非常好,但如果您想要检索大容量加载的结果(哪些行失败等),您必须跳过几个圈,请参阅关于它的博客文章。
* re: Bulk API V1 and V2: I prefer V1 because it lets you retrieve results via the UI, but V2 doesn't. V1 lets you set a batch size but V2 doesn't, etc.
*Re:Bulk API V1和V2:我更喜欢V1,因为它可以让你通过UI检索结果,但V2不能。V1可以设置批量大小,而V2不可以,以此类推。
更多回答
我是一名优秀的程序员,十分优秀!