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 [2017/09/14 06:21] – [Data Import] dmitry | overview [2019/10/31 08:59] – [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 database drivers |
- | * ODBC data sources | + | * ODBC drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite, Amazon Redshift, Vertica, SAP HANA, Apache Hive, Generic ODBC) |
+ | * REST APIs (JSON/XML) | ||
* Text files with delimiters (e.g. CSV) | * Text files with delimiters (e.g. CSV) | ||
- | * Excel files (.xlsx, .xls) | + | * Text files with fixed width columns |
- | * QlikView' | + | * Excel spreadsheets |
+ | * XML files | ||
+ | * Google Sheets | ||
+ | * SharePoint lists | ||
+ | * Qlik data files (.qvd) | ||
* SAS files (.sas7bdat) | * SAS files (.sas7bdat) | ||
+ | * 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 |
- | Technically speaking, import is performed by special import transformations | + | Databases can be queried using the visual Query Editor |
- | ==== Transformations ==== | + | 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. |
- | 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 that somehow changes a table. | + | |
- | Transformations | + | ==== Actions ==== |
+ | All manipulations with tables | ||
- | Final state (or result) of a table is the result of all transformations | + | * [[transformations: |
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
- | Some transformations (e.g. [[transformations: | + | {{:: |
- | Here is full list of all [[transformations: | + | Actions are executed consequently, |
+ | |||
+ | 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.0 EasyMorh can export into the following |
+ | * Native database drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite) | ||
+ | * ODBC drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite, Amazon Redshift, Vertica, SAP HANA, Apache Hive, Generic ODBC) | ||
+ | * REST APIs (JSON/XML) | ||
+ | * Text files with delimiters (e.g. CSV) | ||
+ | * Excel spreadsheets (.xlsx) | ||
+ | * XML files (.xml) | ||
+ | * Google Sheets | ||
+ | * Tableau extracts (.tde) | ||
+ | * Qlik data files (.qvd) | ||
+ | * EasyMorph datasets (.dset) | ||
+ | |||
+ | ==== 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 | | ||
+ | | 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