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/30 18:40] – [Data Import] dmitry | overview [2019/10/30 18:51] – 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 | + | 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 |
* Native database drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite) | * 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) | * ODBC drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite, Amazon Redshift, Vertica, SAP HANA, Apache Hive, Generic ODBC) | ||
Line 9: | Line 9: | ||
* Text files with fixed width columns | * Text files with fixed width columns | ||
* Excel files (.xlsx, .xlsm, .xls) | * Excel files (.xlsx, .xlsm, .xls) | ||
+ | * XML files | ||
* Google Sheets | * Google Sheets | ||
* SharePoint lists | * SharePoint lists | ||
Line 23: | Line 24: | ||
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 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 actions. E.g. renaming a column is an action. Filtering, joining, aggregations -- all are actions. |
* Create -- actions that create or generate a table | * Create -- actions that create or generate a table | ||
* Import -- actions that import data into EasyMorph | * Import -- actions that import data into EasyMorph | ||
* Transform -- actions that transform previously loaded data | * Transform -- actions that transform previously loaded data | ||
- | * Export -- actions that export data into files and databases | + | * Export -- actions that export data into files, databases, applications and external systems |
- | * Workflow -- actions that help organize project workflow | + | * Workflow -- actions that organize project workflow, perform various |
Actions are executed consequently, | Actions are executed consequently, | ||
Line 57: | Line 59: | ||
==== Auto-documentation ==== | ==== Auto-documentation ==== | ||
EasyMorph can automatically generate documentation from current transformation project. Read more about [[documentation|Auto-documentation]]. | EasyMorph can automatically generate documentation from current transformation project. Read more about [[documentation|Auto-documentation]]. | ||
+ | |||
+ | ==== Launcher ==== | ||
+ | EasyMorph Launcher is a complementary scheduling/ | ||
==== Command-line execution ==== | ==== Command-line execution ==== | ||
Line 62: | Line 67: | ||
**See also:** | **See also:** | ||
- | * [[https:// | + | |
+ | | ||
* [[https:// | * [[https:// |
overview.txt · Last modified: 2022/07/22 04:36 by dmitry