Thanks. Personally I appreciate:
-
the sandbox in EasyMorph which allows testing a lot of small things very quickly that seems more cumbersome in other tools.
-
Sending emails using the mail action
-
The “find in actions” option to trace where column is used in the flow.
-
The speed by which a data flow can be designed.
-
Iterations
-
The simple GUI
-
Search options on fields, values
Things that could be improved:
- Sampling records in all types of import files (e.g. get first 1000 rows of a DSET file)
- More statistical functions
- Running SQL-queries with a given batch size to append to a CSV so that it can be run on a pc with less RAM available.
- Generating parameters from column values.
- Be able to capture the expressions in for example create new column as column values
- More connectors: e.g. to Azure Blob storage.
- Higher performance to read big CSV-files ( > 1 mln records)
- Capture the DDL statement when using create table action without having to create the table in the database.
- Allowing keep matching and mismatching database rows when one only has read only rights on the database.
Facilitiating incremental loads from database to other data stores. - Native integration with R and Python.
- More view options (zoom in/out, auto arrange data flow to make it more clear