overview
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
overview [2019/10/31 05:18] – dmitry | overview [2022/07/22 04:36] (current) – dmitry | ||
---|---|---|---|
Line 2: | Line 2: | ||
{{: | {{: | ||
+ | \\ | ||
==== Data import ==== | ==== Data import ==== | ||
- | In order to start transforming data in EasyMorph, all data subject to manipulations has to be imported into EasyMorph. As of version 4.0 EasyMorph can import the following data sources/ | + | In order to start transforming data in EasyMorph, all data subject to manipulations has to be imported into EasyMorph. As of version 4.7 EasyMorph can import the following data sources/ |
- | * Native database drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite) | + | * Native |
- | * ODBC drivers | + | |
* REST APIs (JSON/XML) | * REST APIs (JSON/XML) | ||
- | * Text files with delimiters (e.g. CSV) | + | |
- | * Text files with fixed width columns | + | |
- | * Excel spreadsheets (.xlsx, .xlsm, .xls) | + | * Text files with fixed width columns |
- | * XML files | + | * Excel spreadsheets (.xlsx, .xlsm, .xls) |
- | * Google Sheets | + | * XML and JSON files |
- | * SharePoint lists | + | * Qlik data files (.qvd) |
- | | + | * SAS files (.sas7bdat) |
- | * SAS files (.sas7bdat) | + | * SPSS/PSPP files (.sav) |
- | * SPSS/PSPP files (.sav) | + | * EasyMorph datasets (.dset) |
- | * EasyMorph datasets (.dset) | + | * Cloud applications |
+ | * Google Sheets | ||
+ | * Google Analytics | ||
+ | * SharePoint (lists) | ||
+ | * Airtable | ||
+ | * Pipedrive | ||
+ | * SalesForce | ||
+ | * Qlik Cloud | ||
+ | * and more... | ||
- | Once tables are loaded into EasyMorph they can further be modified using actions (transformations) that are applied sequentially one after another. | + | The full list of integrations is available here: [[https:// |
- | Databases | + | Once tables are loaded into EasyMorph, they can be modified |
- | Files can be loaded by simply dragging them into EasyMorph. In many cases, it's possible to load and automatically append multiple files at once. | + | Databases |
+ | Files can be loaded by simply dragging them into EasyMorph. It's possible to load and automatically append multiple files at once. | ||
+ | |||
+ | [[https:// | ||
+ | [[https:// | ||
+ | |||
+ | \\ | ||
==== Actions ==== | ==== Actions ==== | ||
- | All manipulations with tables are done with the help of various [[[[transformations: | + | All manipulations with tables are done with the help of various [[[[transformations: |
* [[transformations: | * [[transformations: | ||
Line 35: | Line 49: | ||
{{:: | {{:: | ||
- | Actions are executed consequently, | + | Actions are executed consequently, |
- | The final state (or result) of a table is the result of all actions of this table applied consequently, | + | The final state (result) of a table is the result of all actions of this table applied consequently, |
- | Some actions (e.g. [[transformations: | + | Some actions (e.g. [[transformations: |
+ | \\ | ||
==== Expressions ==== | ==== Expressions ==== | ||
- | Some actions can use [[syntax: | + | Some actions can use [[syntax: |
+ | EasyMorph has more than 150 functions can be used in expressions: | ||
+ | |||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | \\ | ||
==== Derived tables ==== | ==== Derived tables ==== | ||
- | Derived tables | + | Derived tables |
- | 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 action chains. For instance, you can produce two derived tables from a table, transform each of them in its own way and then append or merge them back into one table. | + | 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 action chains. For instance, you can produce two derived tables from a table, transform each of them in its own way and then append or merge them back into one table. |
- | Derived tables can be calculated // | + | Derived tables can be calculated // |
+ | [[https:// | ||
+ | |||
+ | \\ | ||
==== Data export ==== | ==== Data export ==== | ||
- | Exporting data is performed using export actions. They can be inserted at any point of workflow. Export actions do not modify tables, they just export them into specified file format or external system. Therefore the output of an export action is always | + | Exporting data is performed using export actions. They can be inserted at any point of workflow. Export actions do not modify tables. They export them into a specified file format or external system. Therefore the output of an export action is always the same as the input. |
- | As of version 4.0 EasyMorh can export into the following data formats and systems: | + | EasyMorh can export into the following data formats and systems: |
- | * Native database drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite) | + | * Native |
- | * ODBC drivers | + | * Web APIs (as JSON/ |
- | * REST APIs (JSON/ | + | |
- | * Text files with delimiters (e.g. CSV) | + | |
- | * Excel spreadsheets (.xlsx) | + | * Excel spreadsheets (.xlsx) |
- | * XML files (.xml) | + | * XML files (.xml) |
- | * Google Sheets | + | * Tableau extracts (.tde, .hyper) |
- | | + | * Qlik data files (.qvd) |
- | * Qlik data files (.qvd) | + | * EasyMorph datasets (.dset) |
- | * EasyMorph datasets (.dset) | + | * Cloud/ |
+ | * Google Sheets | ||
+ | * Power BI | ||
+ | * Tableau Server / Online | ||
+ | * Airtable | ||
+ | * EasyMorph Server | ||
+ | * and more... | ||
- | ==== Automation | + | The full list of integrations is available here: [[https:// |
- | EasyMorph | + | |
+ | [[https:// | ||
+ | [[https:// | ||
+ | |||
+ | \\ | ||
+ | ==== Workflow automation | ||
+ | EasyMorph | ||
* File and folder operations (copy/ | * File and folder operations (copy/ | ||
* Running external applications, | * Running external applications, | ||
* Execution of Windows shell commands | * Execution of Windows shell commands | ||
- | * Embedded PowerShell | + | * Embedded PowerShell |
+ | |||
+ | A workflow can be composed using advanced patterns: | ||
+ | * FOR..EACH type of loops (iterations) | ||
+ | * DO..WHILE/ | ||
+ | * IF..THEN..ELSE type of conditional branching | ||
+ | * Subroutines | ||
+ | * Error recovery | ||
+ | |||
+ | Workflows can have a complex hierarchical structure when a project can consist of multiple modules, and each module can consist of multiple table groups. Such a structure allows designing and navigating workflows with hundreds of transformation steps (actions). | ||
- | ==== Integration with external systems | + | \\ |
+ | ==== Integration with enterprise / cloud applications | ||
EasyMorph workflows can also integrate and interact with external systems and applications. | EasyMorph workflows can also integrate and interact with external systems and applications. | ||
^ External system ^ Integration ^ | ^ External system ^ Integration ^ | ||
| IMAP email server | | IMAP email server | ||
+ | | SSH server | Execute commands | ||
| Microsoft Exchange | Send / receive emails | | | Microsoft Exchange | Send / receive emails | | ||
| SFTP/ | | SFTP/ | ||
Line 85: | Line 139: | ||
| Google Drive | Download / upload files | | | Google Drive | Download / upload files | | ||
| Amazon S3 | Download / upload files | | | Amazon S3 | Download / upload files | | ||
- | | SSH | + | | Power BI | Publish push-datasets, |
+ | | Tableau Server / Online | ||
+ | | Qlik Sense | Trigger task reloads | | ||
+ | | Airtable | ||
+ | \\ | ||
==== Auto-documentation ==== | ==== Auto-documentation ==== | ||
- | EasyMorph can automatically generate human-readable documentation in plain English for current project. Read more about [[documentation|Auto-documentation]]. | + | EasyMorph can automatically generate human-readable documentation in plain English for the current project. Read more about [[documentation|Auto-documentation]]. |
+ | \\ | ||
==== Scheduling ==== | ==== Scheduling ==== | ||
- | [[https:// | + | [[https:// |
+ | [[https:// | ||
+ | |||
+ | [[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 the command line, thus allowing integration with third-party applications. Read more about [[command_line|command line parameters]]. |
+ | A more robust integration option is the " | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | \\ | ||
==== EasyMorph Server ==== | ==== EasyMorph Server ==== | ||
- | [[https:// | + | [[https:// |
+ | |||
+ | \\ | ||
+ | ==== EasyMorph Community ==== | ||
+ | |||
+ | The [[https:// | ||
- | **See also:** | + | ==== See also ==== |
* [[https:// | * [[https:// | ||
* [[https:// | * [[https:// | ||
- | * [[https:// | + | * [[https:// |
+ | * [[https:// |
overview.txt · Last modified: 2022/07/22 04:36 by dmitry