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.
Here is what it looks like (looped 2-minute animation):
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.
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:
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.
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.
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.
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.
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: