Azure Data Factory (ADF) is pretty nice. Its actually two different things welded together:
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.
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 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.
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:
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