A powerful data transformation and automation tool. Optimized for business users. A free edition available.

Download

With EasyMorph business users and data experts automate complex data transformations and routine or repetitive tasks. No knowledge of SQL or programming is required — designing is 100% visual. EasyMorph is optimized for non-technical users that would like to reduce their dependency on corporate IT departments, and spend less time on tedious data-related tasks.


data transformationData transformation

  • Data preparation for reports and dashboards.
  • 100+ actions for merging, filtering, aggregating, matching and many more.
  • Import/export from/to databases, spreadsheets, files of various formats.
  • Support for cloud databases hosted at Amazon, Azure, or Google.
  • Advanced non-relational transformations (e.g. Pivot/Unpivot, Regexp or Fuzzy Matching).
  • Data quality guards to prevent "dirty" or inconsistent data from propagating.
  • Automatically generated documentation in plain English (see example).

data transformationAutomation

  • Replace VBA macros or various scripts with visual workflows in EasyMorph.
  • Schedule tasks or trigger them manually.
  • Copy/rename/delete/unzip/download files.
  • Receive and send e-mails with attachments.
  • Transfer files over SFTP/SCP.
  • Run external programs, execute batch and PowerShell commands.
  • Create data-aware, rule-based alerts.
  • Arrange conditional IF...THEN...ELSE workflows.
  • Automate common or repetitive actions using parameters, subroutines and loops.
  • Publish to Tableau Server, generate TDEs.
See what others say about EasyMorph

Data transformation with more clarity, less effort

Data transformation isn't easy. One of its main challenges is having a clear understanding of the transformation logic because it's highly prone to human errors and data quality issues. We walked away from the traditional approach to designing transformations in order to bring more clarity into calculations, and make authoring simpler:


  • Data in tables is transformed step-by-step, by applying various transformations one after another. Alternatively, pick commands from a context menu. In this case, EasyMorph automatically creates necessary transformations for you, on the fly.
  • The full result of each transformation step is stored in memory. Just click a transformation to see its result. You can easily trace a calculation back to the point where it went wrong as if you had a "time machine".
  • EasyMorph automatically re-calculates dependent transformation steps in the background, instantly after a transformation was added or edited. You can immediately see how a change affects the final result, without re-running everything from the beginning after every minor edit.

Here is what it looks like (looped 2-minute animation):

animated demo

EasyMorph Server for teams

EasyMorph Server is a data transformation (ETL) and task automation hub optimized for analytical teams with limited or no IT support. It runs projects created using the desktop editions of EasyMorph (including the free edition). The Server is easy to install, configure, and use. Its typical use cases are:


  • Scheduled data preparation and transformation.
  • Automated data collection (email attachments, SFTP transfers, web upload).
  • Data publishing and distribution (by email, SFTP transfers, web download).
  • Data-aware, rule-based alerts and notifications.
  • Automation server for analytical systems (e.g Tableau or Qlik Sense).
  • Offloading computationally heavy tasks from desktops.

More about EasyMorph Server...

For Tableau, Excel and Qlik users

EasyMorph can be used with any Business Intelligence or data visualization tool. It works particularly well with Tableau dashboards, Qlik apps and Excel spreadsheets.

Tableau users design complex transformations without help of IT staff, publish data sources to Tableau Server, generate TDEs.

EasyMorph adds automation capabilities to Qlik Sense, lets users replace scripting with visual transformations.

Excel users design error-proof data transformation processes visually, instead of writing VBA macros.


Video

A 3-minute overview and demo of EasyMorph that shows querying a database, applying transformations, using expressions and, finally, exporting results back into the database.

Screenshots

Unlike traditional ETL tools, EasyMorph combines data and workflow in a single view, providing a clear picture of transformation logic.

Example: US Census 2012
Example: Inc5000
Database Query Editor

Try the free edition. See if EasyMorph works for you.

Free Download   Ask a question
Copyright © 2014-2018 EasyMorph Inc.