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 [2019/09/12 05:47] – added data sources in 3.9.5 dmitry | overview [2020/11/26 16:47] – [EasyMorph Server] 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 | * Google Sheets | ||
* SharePoint lists | * SharePoint lists | ||
Line 15: | Line 17: | ||
* EasyMorph datasets (.dset) | * 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 ==== | ==== Actions ==== | ||
- | All manipulations with tables are done with the help of various actions. E.g. renaming a column is an action. Filtering, joining, aggregations -- all are actions. | + | All manipulations with tables are done with the help of various |
- | * Create -- actions that create or generate a table | + | * [[transformations: |
- | * Import -- actions that import data into EasyMorph | + | * [[transformations: |
- | * Transform -- actions that transform previously loaded data | + | * [[transformations: |
- | * Export -- actions that export data into files and databases | + | * [[transformations: |
- | * Workflow -- actions that help organize project workflow | + | * [[transformations: |
+ | |||
+ | {{:: | ||
Actions are executed consequently, | Actions are executed consequently, | ||
Line 36: | Line 39: | ||
Some actions (e.g. [[transformations: | Some actions (e.g. [[transformations: | ||
- | |||
- | Here is full list of all [[transformations: | ||
==== Expressions ==== | ==== Expressions ==== | ||
- | Some actions can use [[syntax: | + | Some actions can use [[syntax: |
+ | |||
+ | As of version 4.5 EasyMorph | ||
+ | |||
+ | * [[syntax:functions# | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
==== 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:// | ||
+ | |||
+ | ==== EasyMorph Community ==== | ||
+ | |||
+ | The [[https:// | ||
+ | |||
**See also:** | **See also:** | ||
- | * [[https:// | + | |
- | * [[https:// | + | |
+ | * [[https:// |
overview.txt · Last modified: 2022/07/22 04:36 by dmitry