Differences

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

--- overview [2016/05/24 00:45] – dmitry
+++ overview [2018/05/09 19:34] – [Data Import] dmitry
@@ Line 2: / Line 2: @@
 ==== 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 2.8 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 tables. As of version 3.8 EasyMorph supports the following data sources:
   * Relational databases (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite)
-  * ODBC data sources
+  * ODBC data sources (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite, Amazon Redshift, Vertica, SAP HANA, Apache Hive)
   * Text files with delimiters (e.g. CSV)
-  * Excel files (.xlsx, .xls)
+  * Text files with fixed with columns
-  * QlikView's QVD files
+  * Excel files (.xlsx, .xlsm, .xls)
+  * Qlik data files (.qvd)
   * SAS files (.sas7bdat)
+  * SPSS/PSPP files (.sav)
 Once tables are loaded into EasyMorph they can further be modified using transformations that are applied one after another.
-Technically speaking, import is performed by special import transformations which are available from "Create table" menu rather than "Add transformation" menu where all other transformations reside.
+Import is performed by import actions which are available in the Main menu, by pressing "Add action".
+Databases can be queries using the Query Editor.
+Files can be loaded by simply dragging them into EasyMorph.
 ==== 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 a table.
@@ Line 36: / Line 41: @@
 ==== Data Export ====
-Exporting data is performed using export transformations. They can be inserted at any point of transformation sequence. Export transformations support the same formats as import transformations. For every import transformation there is corresponding export transformation.
+Exporting data is performed using export transformations. They can be inserted at any point of transformation sequence. Export transformations do not modify tables, they just export them into specified file format. Therefore output of export transformation is the same as input. I.e. it contains exactly the same number of rows and columns in exactly the same order.
-Export transformations do not modify tables, they just export them into specified file format. Therefore output of export transformation is the same as input. I.e. it contains exactly the same number of rows and columns in exactly the same order.
+Exporting data to databases is done using [[transformations:sqlcommand|SQL Command]] transformation that instructs the target database to upload a file previously created in EasyMorph.
 ==== Auto-documentation ====