Differences

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

--- overview [2017/09/14 06:21] – [Data Import] 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.