User Tools

Site Tools


overview

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
overview [2019/10/30 18:40] – [Data Import] dmitryoverview [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 as tables. As of version 4.0 EasyMorph supports 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.0 EasyMorph can import the following data sources/formats:
   * 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. Actions can be one of 5 types:+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. As of version 4.0 EasyMorph has more than 110 various actions that can be one of 5 types:
  
   * 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 filesdatabases, applications and external systems 
-  * Workflow -- actions that help organize project workflow and perform various automation+  * Workflow -- actions that organize project workflowperform various operations with files and external systems
  
 Actions are executed consequently, step-by-step. One action is one step. Every action is applied to the result (output) of previous action. Therefore sequence of actions is important. The same actions in different order would usually produce a different result (although not always). Actions are executed consequently, step-by-step. One action is one step. Every action is applied to the result (output) of previous action. Therefore sequence of actions is important. The same actions in different order would usually produce a different result (although not always).
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/triggering utility that comes with EasyMorph Desktop. Launcher allows creating tasks with EasyMorph projects that triggered manually when needed, or scheduled on various schedules (Once, Continuous, Daily, Weekly). Launcher resides in the system tray, starts on Windows start and is tightly integrated with Desktop.
  
 ==== Command-line execution ==== ==== Command-line execution ====
Line 62: Line 67:
  
 **See also:** **See also:**
-  * [[https://easymorph.com/learn.html|Tutorial]]+  * [[https://www.youtube.com/watch?v=1MtXLkJzKuI|10-minute video overview of EasyMorph 3.6]] 
 +  * [[https://easymorph.com/learn.html|Illustrated tutorial]]
   * [[https://easymorph.com/examples.html|Examples]]   * [[https://easymorph.com/examples.html|Examples]]
overview.txt · Last modified: 2022/07/22 04:36 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki