Mriya_DMT data transformation tool for Salesforce - YaroslavLitvinov/mriya GitHub Wiki

Mriya_DMT is a command line tool for managing Salesforce data. It serves for the same purposes as Dataloader and Workbench tools, though it's not a famous at all.

The hybrid query engine gives an ability to create a sql scripts with either Salesforce bulk queries and Sqlite3 queries inside. By using a simple home-baked language you can fetch fetch data from Salesforce and save as csv files locally, do data transformations by sqlite3 locally and then submit resulted data to remote Salesforce object. Following salesforce bulk operations are supported: query,insert,update,delete. One thing to note, that Salesforce bulk query syntax is little bit different from SOAP query syntax.