Traditional ETL tools were designed for the previous century. They are unnecessarily cumbersome and limit your productivity. We've re-thought ETL from scratch, and the result is amazing.
Meet next-generation ETL
Data transformation isn't easy. Unfortunately, most ETL tools re-use an outdated concept from the 1990s without giving it an extra thought. It makes data engineering experience unnecessarily complicated and doesn't fit well the modern IT landscape, as computer technology and the IT landscape have significantly evolved over the last 30 years.
Meet a next-generation ETL application, based on innovative in-memory engine that entirely changes how data can be transformed and automated.
Ultimate data visibility
It's hard to transform data if you don't see it. Unfortunately, traditional ETL tools don't show you the full data, only a few top rows. But that doesn't make any sense! How are you supposed to discover data quality problems and catch calculation errors if you don't even see all the data you transform? What if errors hide in the rows your ETL tool doesn't show you?
- Shows the full output of every transformation step
- Instantly see all unique values in every column at any step
- Instantly available, just click a step and see its full result
- Shows only the top 1000 or so
- Shows only some of the unique values - makes no sense!
- To capture a full output, you need to run the whole workflow, from the beginning, every time!
Reactive recalculation
You used to re-running the whole workflow (or script) from the beginning after any change, but that wastes your time, especially if you work with large datasets. In EasyMorph, you see the result of every change instantly, thanks to the reactive workflow recalculation happening in the background after a change. In a way, it feels like Excel, but for tabular data.
- Recalculates everything instantly
- Recalculates only from the point of change - fast!
- Must re-run after every change
- Must recalculate everything from start - slow!
A bit of history
Why most ETL tools still use the outdated DAG-based concept
By now, it's obvious how disadvantageous the DAG concept is. But why do almost all ETL tools still use it?
ETL tools were invented in 1990s, when computers had little memory. In 1992, a decent server had 16 or 32MB (megabytes!) of RAM, a thousand times less than an average laptop nowadays. Batch processing and DAG were the only reasonable options due to the technical limitations of that time. Sticking to them now, 30 years later, make no sense as computers have significantly evolved and business needs have greatly changed.
Built-in data analysis
See and analyze data at any step. Filter rows, spot inconsistencies, and explore relationships in data. Aggregate and visualize data on the fly to see trends, patterns, and outliers at any step, instantly.
- Instant filtering at any step to explore relationships in data and investigate data problems
- Build charts, pivot tables as if it was a BI tool
- Visual merge profiler to catch join errors
- Sandboxes for one-off calculations
- Can't do data analysis because no full data, or must run workflow from the beginning to capture output
Modern data type system
ETL tools are increasingly used to process semi-structured data typical for the internet such as JSON or CSV, and, of course, spreadsheets. However, traditional ETL apps don't work well with such data formats as their concept was invented before the internet. Besides that, traditional ETL tools are poorly suited for financial calculations as they introduce rounding errors because they use floating-point numbers, a wrong choice for business calculations.
- One column can mix various data types
- Preserves the original data type
- Uses double-precision 128-bit fixed-point decimals, ideal for finance and business calculations
- 0.1+0.2=0.3 evaluates to TRUE, unsurprisingly
- One column must be of one and only data type
- Forces data conversion, loses original data type
- Uses 64-bit float-point numbers intended for scientific and engineering calculations
- 0.1+0.2=0.3 evaluates to FALSE, a surprise for many
Hint: Evaluate the following expression: 0.1+0.2=0.3 in your favorite ETL application. Most ETL tools such as Alteryx, Talend, or PowerQuery use floating-point numbers and return FALSE, while the correct answer is, apparently, TRUE. EasyMorph correctly returns TRUE because it uses fixed-point decimals under the hood. While it may appear minor, incorrect rounding leads to incorrect calculations results that remain undetected in vast majority of cases..
Under the hood
The in-memory engine
The excellent developer experience in EasyMorph has become possible thanks to EasyMorph's state-of-the-art in-memory engine.
- Aggressively compresses data on the fly so you transform instantly millions of rows even on an average laptop.
- Eliminates slow disk I/O operations (slow even for SSD)
- Is highly parallelized automatically
- Smartly transforms data without decompression to speed up calculations
Data automation
Data preparation requires good data automation. In fact, EasyMorph doesn't make a distinction between ETL and automation. It's a multi-purpose data automation tool that helps you automate more than just ETL pipelines:
- File operations: copy/rename/delete/zip/unzip/etc.
- File transfers, uploads, and downloads
- Web requests and API automation
- Send/receive emails, mark read, save attachments, etc
- Send alerts and notifications to Teams, Slack or mobile devices
- Create tickets in JIRA or ZenDesk
- Send prompts to GenAI models
- And many more
Advanced workflow constructs
EasyMorph allows designing complex calculations using programming constructs typical for programming languages:
- Loops
- Subroutines
- Conditional IF/THEN branching
- Exceptions
- Mutexes
- Key-value store (dictionary)
More than ETL. A data engineering platform.
EasyMorph offers next-level data engineering productivity and experience by being more than an ETL tool. It is a visual multi-purpose data engineering platform. It's your new data engineering superpower.
Features
A highly capable automation tool overall:
Triggers
Trigger data automations on events such as "file appears" of "email received".
Scheduler
Run data preparation and automation workflows on schedule. Get notified on errors.
File manager
Browse, upload, and download files located in file services such as SFTP, OneDrive, or AWS S3.
API integration
Extract data from any web (REST) API. Deploy your own real-time web APIs to serve data from databases and apps.
Issue tracker
Track and collaborate on data quality problems. Automate business processes.
Data privacy
Your data always remains on your machine and is never sent to the cloud.
Merge profiler
Visual profiler for table joins helps detect merge errors.
Auto-documentation
Automatically generated human-readable ETL documentation in plain English.
Data visualization
Visualize, filter, and analyze full datasets at any workflow step.
Flat price. Unlimited usage.
Features | EasyMorph Desktop | EasyMorph Server |
---|---|---|
All actions and integrations | ||
Unlimited data volume | ||
Users that run workflows | 1 | Unlimited |
Scheduling | Limited | |
Price, USD | $900 / yr | from $3,600 / yr (depends on edition) |
Our guarantee
Simple terms. Peace of mind.
Unlike big enterprise software companies, EasyMorph offers simple, fair terms of use.
No Data Limits
Even the free edition of EasyMorph has no limits on workflow runs or data volumes, and all the integrations are included.
No Contract Lock-In
After the initial year subscription, your annual Professional license can be replaced with a perpetual license without updates or email support.
Price Lock Guarantee
Your annual pricing is fixed based on the date of purchase and is guaranteed to remain the same (inflation-adjusted), as long as renewals don't lapse.
Still have questions about EasyMorph?
- Why pay for EasyMorph when there are free open-sourсe ETL tools?
-
Unfortunately, all open-source ETL tools use the same outdated concept of ETL as traditional ETL software. Because of that, open-source ETL tools suffer from the same problem with data visibility and hold your productivity back.
Besides that, the cost of licensing is never the biggest driver of the total cost of ownership for ETL tools. It's the ETL developer's salary.
What you might be saving on license price, you will pay in extra labor caused by the inefficiencies of the free tools. EasyMorph triples your data productivity and is reasonably priced. As a result, it is more cost-effective and beneficial to your bottom line than "free" software.
- How does EasyMorph compare to cloud ETL tools?
-
Cloud ETL tools are arguably the worst option for ETL software in terms of developer experience and not only that. They offer poor data visibility, their pricing is unpredictable, and you are forced to share your sensitive data in exchange for the banal promise that "your privacy is our top priority".
With EasyMorph, your data is local, so you get a snappy UI, instant recalculation, and excellent developer experience overall. Your data is safe because it never leaves your computer and you can enjoy unlimited usage for one fixed flat price.
- How do I know EasyMorph can handle my data workload?
-
EasyMorph's in-memory engine uses advanced data compression and is specifically designed to work with large tabular datasets. To try it, just download the free edition and start transforming data.
- How is my data protected within EasyMorph?
-
Unlike cloud-based ETL tools, EasyMorph does not live in the cloud. It’s an on-premises Windows application can work even in air-gapped networks.
That means your data never leaves your machine instead of being sent to someone else's computer in the cloud.
- What devices can I use EasyMorph on?
-
EasyMorph is designed for 64-bit Windows machines (virtual and not).
Make a choice
How would you like to get started?
- Download the free Desktop edition.
- Check out the tutorials. Or ask the Community for help.
- Try getting something done with EasyMorph.
Get started today
- Download the free Desktop edition.
- Check out the tutorials. Or ask the Community for help.
- Try getting something done with EasyMorph.