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 [2015/01/31 15:08] – dmitry | overview [2016/05/24 00: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 as tables. | + | In order to start transforming data in EasyMorph, all data subject to manipulations has to be imported into EasyMorph as tables. |
+ | * Relational databases (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite) | ||
+ | * ODBC data sources | ||
* Text files with delimiters (e.g. CSV) | * Text files with delimiters (e.g. CSV) | ||
- | * Excel files (.xlsx | + | * Excel files (.xlsx, .xls) |
* QlikView' | * QlikView' | ||
+ | * SAS files (.sas7bdat) | ||
- | One imported file creates one table. | + | Once tables are loaded into EasyMorph they can further be modified using transformations |
Technically speaking, import is performed by special import transformations which are available from " | Technically speaking, import is performed by special import transformations which are available from " | ||
==== Transformations ==== | ==== Transformations ==== | ||
- | 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 table. | + | 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 |
Transformations are executed consequently, | Transformations are executed consequently, | ||
Line 33: | Line 36: | ||
==== Data Export ==== | ==== Data Export ==== | ||
- | Exporting data is performed using export transformations. They can be inserted at any point of transformation sequence. Export transformations | + | Exporting data is performed using export transformations. They can be inserted at any point of transformation sequence. Export transformations |
- | Export | + | Exporting data to databases is done using [[transformations: |
==== Auto-documentation ==== | ==== Auto-documentation ==== | ||
Line 42: | Line 45: | ||
==== 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]]. | ||
+ | |||
+ | **See also:** | ||
+ | * [[http:// | ||
+ | * [[http:// |
overview.txt · Last modified: 2022/07/22 04:36 by dmitry