4.8
700+ organizations 45+ countries 350+ capabilities
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 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 for any step
Instantly available, just click and see
Doesn't show the full dataset, only top rows
Doesn't show all the unique values in columns, no data profiling
To capture the full output of a step, you need to run the whole workflow, from the beginning, every time!
Reactive recalculation
You used to re-running the whole workflow 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 reactive workflow recalculation happening in the background after a change. It feels like Excel, but for tabular data.
Recalculates everything instantly
Recalculates only from the point of change - fast!
Workflow must be re-run after every change
Workflow always runs from the beginning
A bit of history
Why most ETL tools 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 of RAM. Batch processing and DAG were the only reasonable option due to technical limitations of that time. Sticking to them now, 30 years later, make no sense as computer have greatly evolved and business needs changed.
Built-in data analysis
See and analyze data at any step. Filter rows 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
Not possible to analyze data instantly because steps don't show all data
To collect the full output of just one step, the workflow must be re-calculated from the beginning - very inconvenient for data analysis
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 forbusiness 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, introduces hard-to-catch rounding errors in financial calculations
0.1+0.2=0.3 evaluates to FALSE, a surprise for many
Under the hood
The in-memory engine
The excellent developer experience has become possible to EasyMorph's state-of-the-art in-memory engine.
- Aggressively compresses data on the fly - transform instantly millions of rows even on an average laptop.
- Eliminates slow disk I/O operations (slow even for SSD)
- Highly parallelized
- Transform data without decompression
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)
EasyMorph in a nutshell
EasyMorph is an easy-to-use data automation platform that saves time, helps get things done, and brings collaboration between business professionals and data engineers to the next level.
Data exploration & analysis
Retrieve, explore, and analyze data no matter where it’s stored
Collaboration
Bring everyone in your team on the same page
Data transformation
Trigger-based and scheduled data transformation
Work automation
Data-oriented task automation for your team
EasyMorph
Features
A highly capable automation tool overall:
(Cloud) triggers
Save time by replacing tedious, manual data manipulations in spreadsheets with visual automation workflows.
Scheduler
Consolidate data from multiple spreadsheets, files, databases, and web APIs without coding or manual work.
File manager
Automate robust, auditable, and verifiable financial and analytical calculations with complex business rules.
API integration
Receive and process hundreds and thousands of files in various formats automatically, without manual data wrangling.
Issue tracker
Generate, publish, and distribute spreadsheets with personalized tabular reports.
Data privacy
Fix errors and inconsistencies in data automatically, without manual work.
Merge profiler
Advanced data preparation for popular Business Intelligence applications such as Power BI, Tableau, or Qlik.
Auto-documentation
Query databases without knowing SQL. Find, explore, and retrieve data from business applications without programming.
Data virtualization
Analyze trends, discover major contributors and outliers, take pre-programmed actions with a single button click.
Data privacy
Your sensitive data doesn't go anywhere.
It remains where it is.
Unlike cloud-based tools that require you to send your data to some computer somewhere in exchange for the banal promise that "your privacy is our top priority", with EasyMorph your data simply never leaves your computer(s). It stays where it is, where you can control it.
- EasyMorph doesn't collect customer data or metadata.
- EasyMorph doesn't spy on your actions (telemetry).
- EasyMorph can work even in air-gapped networks where computers are entirely disconnected from the internet.
| Product | EasyMorph Desktop | EasyMorph HUB |
|---|---|---|
| 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.
Make a choice
How would you like to get started?
- Download the forever free Desktop edition.
- Check out the tutorials. Or ask the Community for help.
- Try getting something done with EasyMorph.