overview
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
overview [2018/05/09 19:34] – [Data Import] dmitry | overview [2020/11/26 16:38] – dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== EasyMorph | + | ====== Overview |
+ | {{: | ||
- | ==== Data Import | + | ==== Data import |
- | In order to start transforming data in EasyMorph, all data subject to manipulations has to be imported into EasyMorph | + | In order to start transforming data in EasyMorph, all data subject to manipulations has to be imported into EasyMorph. As of version |
- | * Relational databases | + | * Native and ODBC database drivers |
- | * ODBC data sources | + | * REST APIs (JSON/XML) |
* Text files with delimiters (e.g. CSV) | * Text files with delimiters (e.g. CSV) | ||
- | * Text files with fixed with columns | + | * Text files with fixed width columns |
- | * Excel files (.xlsx, .xlsm, .xls) | + | * Excel spreadsheets |
+ | * XML files | ||
+ | * Google Sheets | ||
+ | * SharePoint lists | ||
* Qlik data files (.qvd) | * Qlik data files (.qvd) | ||
* SAS files (.sas7bdat) | * SAS files (.sas7bdat) | ||
* SPSS/PSPP files (.sav) | * SPSS/PSPP files (.sav) | ||
+ | * EasyMorph datasets (.dset) | ||
- | Once tables are loaded into EasyMorph they can further be modified using transformations that are applied one after another. | + | Once tables are loaded into EasyMorph they can further be modified using actions (transformations) that are applied |
- | Import is performed by import actions which are available in the Main menu, by pressing "Add action" | + | Databases can be queried using the visual Query Editor which is intended for users that don't know SQL. |
- | Databases | + | Files can be loaded by simply dragging them into EasyMorph. It's possible to load and automatically append multiple files at once. |
- | Files can be loaded by simply dragging them into EasyMorph. | + | ==== Actions |
- | ==== Transformations | + | All manipulations with tables are done with the help of various |
- | All manipulations with tables are done with the help of various transformations. E.g. renaming a column is a transformation. Filtering, joining, aggregations -- all are transformations. Every transformation is an action | + | |
- | Transformations are executed consequently, | + | * [[transformations: |
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
- | Final state (or result) of a table is the result of all transformations of this table applied consequently, | + | {{:: |
- | Some transformations (e.g. [[transformations: | + | Actions are executed consequently, |
- | Here is full list of all [[transformations: | + | The final state (or result) of a table is the result |
+ | |||
+ | Some actions (e.g. [[transformations: | ||
==== Expressions ==== | ==== Expressions ==== | ||
- | Some transformations | + | Some actions |
==== Derived tables ==== | ==== Derived tables ==== | ||
- | Derived tables is a powerful feature that allows transforming data in a non-linear way. When one table is derived from another (source) table it replicates the final result of the latter. So if the source table changes, the derived table changes automatically. In everything else derived tables is just a regular table and can further be modified using various | + | Derived tables is a powerful feature that allows transforming data in a non-linear way. When one table is derived from another (source) table it replicates the final result of the latter. So if the source table changes, the derived table changes automatically. In everything else derived tables is just a regular table and can further be modified using various |
- | Since you can derive any number of tables from a table, and then keep transforming every derived table in its own way, you can create non-linear | + | Since you can derive any number of tables from a table, and then keep transforming every derived table in its own way, you can create non-linear |
- | Circular dependencies are not allowed in EasyMorph. I.e. you can't append table A to table B if table A is derived from table B directly or indirectly. | + | Derived tables can be calculated // |
- | ==== Data Export | + | ==== Data export |
- | Exporting data is performed using export | + | Exporting data is performed using export |
- | Exporting | + | As of version 4.5 EasyMorh can export into the following |
+ | |||
+ | * Native and ODBC database drivers (see the [[connectors# | ||
+ | * REST APIs (JSON/ | ||
+ | * Text files with delimiters (e.g. CSV) | ||
+ | * Excel spreadsheets (.xlsx) | ||
+ | * XML files (.xml) | ||
+ | * Google Sheets | ||
+ | * Tableau extracts (.tde, .hyper) | ||
+ | * Power BI datasets | ||
+ | * Qlik data files (.qvd) | ||
+ | * EasyMorph | ||
+ | |||
+ | ==== Automation ==== | ||
+ | EasyMorph workflows can have following automation: | ||
+ | * File and folder operations (copy/ | ||
+ | * Running external applications, | ||
+ | * Execution of Windows shell commands | ||
+ | * Embedded PowerShell scripting | ||
+ | |||
+ | ==== Integration with external systems ==== | ||
+ | EasyMorph workflows can also integrate and interact with external systems and applications. | ||
+ | |||
+ | ^ External system ^ Integration ^ | ||
+ | | IMAP email server | ||
+ | | Microsoft Exchange | Send / receive emails | | ||
+ | | SFTP/ | ||
+ | | REST API | Send HTTP requests and receive responses | | ||
+ | | Microsoft SharePoint | ||
+ | | Google Drive | Download / upload files | | ||
+ | | Amazon S3 | Download / upload files | | ||
+ | | Power BI | Publish push-datasets, | ||
+ | | Tableau Server / Online | ||
+ | | Qlik Sense | Trigger task reloads | | ||
+ | | SSH | Execute commands | ||
==== Auto-documentation ==== | ==== Auto-documentation ==== | ||
- | EasyMorph can automatically generate documentation | + | EasyMorph can automatically generate |
+ | |||
+ | ==== Scheduling ==== | ||
+ | [[https:// | ||
==== Command-line execution ==== | ==== Command-line execution ==== | ||
EasyMorph projects can be executed from command line thus allowing integration with third-party applications. Read more about [[command_line|command line parameters]]. | EasyMorph projects can be executed from command line thus allowing integration with third-party applications. Read more about [[command_line|command line parameters]]. | ||
+ | |||
+ | ==== EasyMorph Server ==== | ||
+ | [[https:// | ||
**See also:** | **See also:** | ||
- | * [[http:// | + | * [[https:// |
- | * [[http:// | + | * [[https:// |
+ | * [[https:// |
overview.txt · Last modified: 2022/07/22 04:36 by dmitry