Other functional use cases

Use API as a data source
Datamin not only easily supports any modern database, data warehouse, or any other kind of data storage as a data source but is also very easy to use any API endpoint that returns JSON data as a data source. 
To do that just configure an API destination first:
API integration example
And then use it as a first task in the workflow. The rest works absolutely the same way as with any other SQL-based data source.
Merge data from several sources
Often you don't have all necessary data stored in one storage but rather in a few ones. For example, the ones you have in your production database that is produced by your applications and the ones stored in your CRM. 
Therefore before taking any action with data you need to use Merge:
Potential workflow
How to configure merge task
Merge data from several sources consequently
Possible workflow
Data to CSV report
Possible workflow
Transforming data to CSV report
Call API for each entity in the dataset

Last modified 7mo ago