Data transformation with more clarity, less effort

Data transformation isn't easy. One of its main challenges is it's highly prone to human errors and data quality issues. To address this challenge, we've rethought data transformation from the ground up. As a result, EasyMorph makes authoring fast, easy, and suitable for non-technical people.


  • Data in tables is transformed step-by-step by applying various actions one after another.
  • You can easily trace a calculation back to the point where it went wrong as if you had a "time machine". Just click any previous transformation step to see its result.
  • EasyMorph instantly re-calculates all dependent transformation steps; therefore, you can immediately see how a change affects the final result, without re-running anything.

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

animated demo

150+ built-in actions and transformations

EasyMorph has been created by people with many years of practical experience in data transformation. This, plus continuous improvement based on the analysis of hundreds of cases, has made EasyMorph a very capable and versatile tool suitable for the vast majority of real-life scenarios.

No matter if you need to perform an advanced calculation, merge datasets, or apply a complex business rule, you will be able to do this in a fast and visual way by using one or several transforms from more than 150 available actions in EasyMorph.

See all actions

See all integrations

Workflows of any complexity

With EasyMorph, you can design simple as well as complex workflows with hundreds and even thousands of steps. Organize complex workflows into logical stages and use parameterized modules for reusable repeating calculations. EasyMorph provides powerful means for building workflows of any complexity:


  • Parameters
  • Conditional branching (IF .. THEN .. ELSE)
  • Loops and subroutines
  • Error handling
  • Exceptions that halt workflow execution on condition
  • Mutexes for managing concurrent access
  • Embedded key-value store (global variables)
  • Automatic parallelization and concurrency
Complex workflow multiple tables and actions

Ultimate insight into workflow logic

Unlike traditional ETL tools, EasyMorph makes data analysis and profiling effortless. The EasyMorph's ultra-fast calculation engine keeps all data in memory and makes the full result (not just the top few hundred rows) of every transformation step instantly available for analysis, even if it's millions of rows. This provides an excellent insight into calculation logic, minimizes human errors, and reduces time spent on designing and debugging workflows.


  • One-click full-table profiling at any step: num/text/null counts, min/max values, longest/shortest text lengths, uniqueness, etc. for every column.
  • Instant, associative filtering of the full result of any action at any moment to reveal relationships and quality issues in data.
  • One-click column profiling: all unique values, type counts, histogram, and automated data quality suggestions for every column anywhere in a workflow.
  • Full-table search.
Table metadata

Accuracy and precision

Double precision

The vast majority of data transformation applications treat numeric values as 64-bit floating-point numbers that were originally intended for scientific calculations. However, floating-point numbers are prone to rounding errors in business calculations. Most of the errors remain unnoticed and end up in reports and databases. For instance, the condition 0.1 + 0.2 = 0.3 incorrectly returns FALSE in many popular data tools because they use 64-bit floats.

EasyMorph processes numbers as 128-bit fixed-point decimals instead of 64-bit floats. Fixed-point decimals have been specifically designed for business calculations. They completely avoid the type of errors caused by the floating-point arithmetics. The condition mentioned above correctly returns TRUE in EasyMorph. In addition, the double precision significantly reduces or entirely eliminates rounding and roll-up errors.

Whitepaper

Most ETL tools available on the market are based on outdated concepts from the 90s of the last century. However, over the last 20-30 years, the technology landscape and business requirements have drastically changed. Our whitepaper "Modern data transformation re-thought from scratch" describes in detail what makes EasyMorph a data automation tool of the 21st century and how it differs from traditional ETL tools.


Get the whitepaper

Auto-documentation

Documentation

Documentation of ETL processes tends to be always outdated as it requires constant manual updating, which is a time-consuming and tedious duty. However, EasyMorph users are spared of this inconvenience because EasyMorph automatically generates a human-readable description of workflow in plain English (see example). The documentation has a permanent URL and can be linked from Business Intelligence reports and dashboards.

Use cases

Business users from finance, manufacturing, consumer products, technology, and other industries use EasyMorph for self-service data preparation without relying on IT specialists. Here are just a few examples of what our customers do with EasyMorph:

  • Prepare and transform data for reports and analytical dashboards.
  • Collect poortly formatted spreadsheets from external parties and consolidate them in a standard format.
  • Receive data from a web (REST) API and push it into a database table.
  • Cleanse, transform, and upload text files into a Data Warehouse (DWH).
  • Extract data from a database without knowing SQL, merge the data with local spreadsheets.
  • Process and aggregate data submitted through web-forms or survey submissions.
  • Replace obscure VBA macros and Python scipts with visual, easy to understand, self-documenting workflows.

State-of-the-art data preparation. Try it today.

Free download   Book a demo