bulkapi

Salesforce Bulk API 1 is more useful than Bulk API 2

Salesforce Bulk API 1 was released way back in 2009 and the Bulk API 2.0 was released in 2018, and they are both still officially supported. At a high level they are similar, in that both of them provide a way to send large CSV files to Salesforce and rapidly load them. The Bulk API 2.0 was intended to make the API easier to use - it brings authentication into line with other APIs, and gets rid of the need to break data into batches before uploading it.

Read more...

ADF Salesforce Connector really doesnt want you to see the Bulk Load results

Azure Data Factory (ADF) is pretty nice. Its actually two different things welded together:

Read more...

Automating Salesforce Data Imports with Powershell and the Salesforce CLI

Some years ago I wrote about using Powershell to automate the Salesforce Data Loader, the idea being that sometimes you dont want to use an ETL tool (think graphical interface with boxes and arrows and properties dialogs - like Talend or Azure Data Factory) to load data into Salesforce. Sometimes you want to do it with some code or scripts, where you can have low level control of all the details, and maybe track the changes in git.

Read more...