EasyMorph Overview
EasyMorph is a cutting-edge, visual data automation and ETL (Extract, Transform, Load) platform designed to simplify and streamline data transformation processes for both non-technical users and data engineers. Here’s a detailed look at what EasyMorph does and its key features:
What EasyMorph Does
EasyMorph is tailored to automate tedious data processes, enabling users to take control of their data preparation without the need for coding. It replaces traditional, cumbersome data transformation tools with a modern, in-memory ETL application that leverages current computer technology. This tool is particularly useful for business professionals who often find themselves bogged down by manual data wrangling tasks, such as those typically performed in Excel.Key Features
Visual Interface and Ease of Use
EasyMorph boasts a 100% visual interface, making it accessible to non-technical users. It allows for the automation of data processes in a self-service manner, eliminating the need for extensive IT involvement.Advanced Workflow Automation
EasyMorph supports complex workflows with features like:- Loops and Conditional Branching: FOR..EACH, DO..WHILE/UNTIL loops, and IF..THEN..ELSE conditional branching.
- Subroutines and Error Recovery: Workflows can include subroutines and robust error handling mechanisms.
- External Actions: Integration with external applications, scripts, batch files, and Windows shell commands, as well as embedded PowerShell scripting.
Data Transformation and Analysis
- In-Memory Engine: EasyMorph uses a proprietary in-memory columnar data transformation engine, allowing for instant profiling and analysis of data transformations without the need for recalculation.
- Data Visualization: Built-in data visualization tools enable users to insert charts at any point in a calculation, providing real-time insights into the data. Charts update automatically with changes to transformations.
Integration and Connectivity
- Database Support: EasyMorph supports a wide range of databases including Oracle, SQL Server, MySQL, PostgreSQL, SQLite, Amazon Redshift, DB2, Vertica, SAP HANA, and more, using both ODBC and native drivers.
- File Formats: It can import and export data from various file formats such as CSV, Excel, Tableau, Qlik, XML, and SAS files.
- Web APIs: Users can send highly configurable web (HTTP) requests to retrieve and update data, submit new data, and trigger processes via web APIs.
Collaboration and Automation
- EasyMorph Server: An optional server application that enhances collaboration, real-time API integration, data retrieval, data ingestion, and workflow automation.
- EasyMorph Gateway: An optional cloud service for data ingestion and real-time cloud automation, allowing tasks to be triggered via public webhooks or services like Power Automate or Zapier.
Additional Features
- Smart Auto-Calculation: EasyMorph smartly recalculates only the transformations affected by changes, eliminating the need to re-run entire workflows.
- Data Profiling and Analysis: Users can view, navigate, and retrieve business data from various sources without building expensive data warehouses.
- Authentication and Security: Seamless authentication via Active Directory and the ability to run workflows under different Windows accounts.