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/10/31 06:12] – [Integration with external systems] dmitry | overview [2020/11/26 16:52] – [Actions] dmitry | ||
---|---|---|---|
Line 3: | Line 3: | ||
==== 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.5 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 delimiters (e.g. CSV) | ||
Line 22: | Line 21: | ||
Databases can be queried using the visual Query Editor which is intended for users that don't know SQL. | Databases can be queried using the visual Query Editor which is intended for users that don't know SQL. | ||
- | Files can be loaded by simply dragging them into EasyMorph. | + | Files can be loaded by simply dragging them into EasyMorph. |
==== 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 34: | ||
{{:: | {{:: | ||
- | 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: |
+ | |||
+ | As of version 4.5 EasyMorph more than 130 functions can be used in expressions: | ||
+ | |||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
==== Derived tables ==== | ==== Derived tables ==== | ||
Line 54: | Line 63: | ||
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 exactly the same as the input. | 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 exactly the same as the input. | ||
- | As of version 4.0 EasyMorh can export into the following data formats and systems: | + | As of version 4.5 EasyMorh can export into the following data formats and systems: |
- | * 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 delimiters (e.g. CSV) | ||
Line 63: | Line 71: | ||
* XML files (.xml) | * XML files (.xml) | ||
* Google Sheets | * Google Sheets | ||
- | * Tableau extracts (.tde) | + | * Tableau extracts (.tde, .hyper) |
+ | * Power BI datasets | ||
* Qlik data files (.qvd) | * Qlik data files (.qvd) | ||
* EasyMorph datasets (.dset) | * EasyMorph datasets (.dset) | ||
==== Automation ==== | ==== Automation ==== | ||
- | EasyMorph | + | 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 |
==== Integration with external systems ==== | ==== Integration with external systems ==== | ||
Line 85: | Line 94: | ||
| Google Drive | Download / upload files | | | Google Drive | Download / upload files | | ||
| Amazon S3 | Download / upload files | | | Amazon S3 | Download / upload files | | ||
- | | Tableau Server / Online | + | | Power BI | Publish push-datasets, |
+ | | Tableau Server / Online | ||
| Qlik Sense | Trigger task reloads | | | Qlik Sense | Trigger task reloads | | ||
| SSH | Execute commands | | SSH | Execute commands | ||
+ | |||
==== 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 current project. Read more about [[documentation|Auto-documentation]]. | ||
==== Scheduling ==== | ==== Scheduling ==== | ||
- | [[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 " | ||
==== EasyMorph Server ==== | ==== EasyMorph Server ==== | ||
- | [[https:// | + | [[https:// |
+ | |||
+ | ==== EasyMorph Community ==== | ||
+ | |||
+ | The [[https:// | ||
**See also:** | **See also:** | ||
* [[https:// | * [[https:// | ||
* [[https:// | * [[https:// | ||
- | * [[https:// | + | * [[https:// |
overview.txt · Last modified: 2022/07/22 04:36 by dmitry