EasyMorph is a powerful data transformation tool. Optimized for business users. A free edition available.

The task of data transformation is traditionally believed to belong to IT developers while business users are typically left with Excel, or cumbersome Visual Basic and Python scripting. Although there have been attempts to create easy-to-use so-called data preparation utilities, such utilities are suitable only for very simple cases. At the same time enterprise Extract-Transform-Load (ETL) systems while powerful (and very expensive) are prohibitively difficult for a non-IT audience, as they simply are not designed for it.

EasyMorph employs a novel approach that combines simplicity similar to that of data preparation utilities and the power typical for professional ETL systems. It allows business users to design rather complex data transformations without using SQL or scripts, while data experts enjoy simpler and faster ETL development.


data transformationFor business users

  • Transform data visually instead of writing VBA macros, Python scripts or SQL.
  • Merge, filter, aggregate data from databases, spreadsheets, and files.
  • Prepare data for visualization (e.g. in Tableau) or online reporting.
  • Convert text files to spreadsheets and vice versa.
  • Create simple PDF reports.

data transformationFor data experts

  • Medium-volume ETL capable of particularly complex transformation logic.
  • Fast ETL prototyping and data quality assessment.
  • Quick one-off data manipulations.
  • Powerful non-relational transformations (e.g. Pivot/Unpivot, Fill down, Shift column).
  • Extracting data from loosely structured spreadsheets.

More visual, simpler design of calculations

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


  • The full result of every transformation step is stored in memory and is therefore instantly visible when you click a transformation. You can easily trace back to the point where a calculation went wrong.
  • You can manipulate data in a manner typical for data preparation utilities (e.g. pick commands from a context menu). In this case, EasyMoprh creates necessary transformations for you, on the fly.
  • 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.

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

Example: US Census 2012
Example: Inc5000
Database Query Editor

Support for Tableau and Qlik

EasyMorph can work with many data visualization tools by exporting data into files and databases. It works particularly well with Tableau and Qlik.

With the help of EasyMorph Tableau users can perform complex transformations, automatically generate and publish Tableau Data Extracts.

QlikView and Qlik Sense users can import and export QVD files, and replace entire load scripts with visual transformations in EasyMorph with just 2 lines of script.


Our free edition is suitable for regular use.

Learn more   Download