Differences

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

--- overview [2019/10/31 06:12] – [Integration with external systems] dmitry
+++ overview [2020/11/26 16:38] – dmitry
@@ Line 3: / Line 3: @@
 ==== Data import ====
-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:
+In order to start transforming data in EasyMorph, all data subject to manipulations has to be imported into EasyMorph. As of version 4.5 EasyMorph can import the following data sources/formats:
-  * Native database drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite)
+  * Native and ODBC database drivers (see the [[connectors#database_connectors|full list of database drivers]])
-  * ODBC drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite, Amazon Redshift, Vertica, SAP HANA, Apache Hive, Generic ODBC)
   * REST APIs (JSON/XML)
   * Text files with delimiters (e.g. CSV)
@@ Line 22: / Line 21: @@
 Databases can be queried using the visual Query Editor which is intended for users that don't know SQL.
-Files can be loaded by simply dragging them into EasyMorph. In many cases, it's possible to load and automatically append multiple files at once.
+Files can be loaded by simply dragging them into EasyMorph. It's possible to load and automatically append multiple files at once.
 ==== Actions ====
-All manipulations with tables are done with the help of various [[[[transformations:start|actions]]. E.g. renaming a column is an action. Filtering, joining, aggregations -- all are actions. As of version 4.0 EasyMorph offers more than 110 various actions that can be divided into 5 categories:
+All manipulations with tables are done with the help of various [[[[transformations:start|actions]]. E.g. renaming a column is an action. Filtering, joining, aggregations -- all are actions. As of version 4.5 EasyMorph offers more than 120 various actions that can be divided into 5 categories:
   * [[transformations:start#create|Create]] -- actions that create or generate a table
@@ Line 54: / Line 53: @@
 Exporting data is performed using export actions. They can be inserted at any point of workflow. Export actions do not modify tables, they just export them into specified file format or external system. Therefore the output of an export action is always exactly the same as the input.
-As of version 4.0 EasyMorh can export into the following data formats and systems:
+As of version 4.5 EasyMorh can export into the following data formats and systems:
-  * Native database drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite)
+  * Native and ODBC database drivers (see the [[connectors#database_connectors|full list of database drivers]])
-  * ODBC drivers (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite, Amazon Redshift, Vertica, SAP HANA, Apache Hive, Generic ODBC)
   * REST APIs (JSON/XML)
   * Text files with delimiters (e.g. CSV)
@@ Line 63: / Line 61: @@
   * XML files (.xml)
   * Google Sheets
-  * Tableau extracts (.tde)
+  * Tableau extracts (.tde, .hyper)
+  * Power BI datasets
   * Qlik data files (.qvd)
   * EasyMorph datasets (.dset)
 ==== Automation ====
-EasyMorph has built-in means for automation:
+EasyMorph workflows can have following automation:
   * File and folder operations (copy/rename/delete/unzip/zip/download)
   * Running external applications, scripts and batch files
   * Execution of Windows shell commands
-  * Embedded PowerShell
+  * Embedded PowerShell scripting
 ==== Integration with external systems ====
@@ Line 85: / Line 84: @@
 | Google Drive  | Download / upload files  |
 | Amazon S3  | Download / upload files  |
-| Tableau Server / Online  | Publish extracts, trigger extract refreshes |
+| Power BI   | Publish push-datasets, trigger flows  |
+| Tableau Server / Online  | Publish extracts, trigger extract refreshes, trigger flows |
 | Qlik Sense  | Trigger task reloads |
 | SSH  | Execute commands  |
 ==== Auto-documentation ====
 EasyMorph can automatically generate human-readable documentation in plain English for current project. Read more about [[documentation|Auto-documentation]].
 ==== Scheduling ====
-[[https://easymorph.com/scheduler.html|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.
+[[https://easymorph.com/scheduler.html|EasyMorph Launcher]] is a free 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 ====
@@ Line 98: / Line 99: @@
 ==== EasyMorph Server ====
-[[https://easymorph.com/server.html|EasyMorph Server]] is a Windows service with a web interface that employs the same in-memory engine as EasyMorph Desktop. Server allows scheduling projects, sharing files and datasets between users, and hosting connector repositories. It also provides a REST API for programmatic integration with external systems.
+[[https://easymorph.com/server.html|EasyMorph Server]] is a Windows service with a web interface that employs the same in-memory engine as EasyMorph Desktop under the hood. Server allows scheduled execution of projects, sharing files and datasets between users, and hosting connector repositories. It also provides a REST API for programmatic integration with external systems.
 **See also:**