Welcome to Kudosync, my homebrew ETL tool. It provides a friendly interface that runs multiple data tasks with a single click, automating Data Loader in the background. Kudosync also generates files for running Data Loader from a Command Line. It requires
- Microsoft Access 2007 (or above); and
- Data Loader 24 (or above).
A feature I added sometime ago: the ability to combine Salesforce SOQL with Access SQL. In the example below, you can see the Contact query
SELECT Id, AccountId
FROM Contact
WHERE AccountId IN ([SELECT Id FROM tbl01_Account])
. . . in that query, the SELECT Id FROM tbl01_Account in square brackets refers to data from a previously-extracted table in the Access ACCDB.
