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:
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.
Moving the blog to Statiq Web
This blog has been running on Blogger since I started it in 2007, but they keep changing their design/templating system and I could be bothered to figure it out again. And the comments are nearly always spam. So I thought I would move to a static blog.
RENXT - automatic download of database for reporting, sql etc
RENXT is the new-ish cloud version of Raiser's Edge (which as I wrote before, still looks suspiciously like Raisers Edge 7). There is a SKY API where you can poke about with the data but if you want to download the whole lot regularly and have a local copy, there is a way to do that too.
Raiser's Edge 7 seems like its going to hang around forever
Quite a lot of the charities I've worked with have used Blackbaud's The Raiser's Edge for fundraising. Version 7 was launched in July 2000 and was a client-server Windows database app. At the time it was very compelling, with lots of features tailored to charity fundraising. I remember being impressed by the Query Editor that was built in:
Automating Salesforce Data Imports with Powershell
ℹ️ Update
This post is quite old and a lot has changed: instead of automating Data Loader, have a look at automating data imports using Salesforce CLI with Powershell
