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

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.
  • Built-in transformations 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 transformationTask automation

  • Replace VBA macros or various scripts with visual workflows in EasyMorph.
  • Run external programs, execute batch and PowerShell commands.
  • Copy/rename/delete/unzip/download files.
  • Publish to Tableau Server, generate TDEs.
  • Arrange conditional IF...THEN...ELSE workflows.
  • Automate common or repetitive actions using parameters, subroutines and loops.
  • Run tasks on schedule or trigger them manually, when needed.
  • Offload tasks to EasyMorph Server.

Better authoring: 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, EasyMoprh 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

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

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.

Qlik users replace entire load scripts with visual transformations in EasyMorph, generate QVD files.

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


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

Free Download   Ask a question