Easy Data Transform



Easy Data Transform is written in C and uses hashing and reference counting for optimal performance, so it is fast. Considering its straightforward handling and the vast tool array, Easy Data Transform could win the title for a tabular-data editing app by a country mile. Featuring diagrammatic-styled. I have been furiously coding a new product. Easy Data Transform. It is a Windows and Mac tool for transforming table and list data from one form to another. Joining, splitting, reformatting, filtering, sorting etc. A place for discussion related to Easy Data Transform. If you are posting a question about how to transform a dataset, please include a short example of the input dataset you have and the corresponding output dataset you want.

Data transformation and task automation server

EasyMorph Server is a data transformation (ETL) and task automation application designed for teams and organizations with limited or no IT support. It's is installed on-premises (or on a cloud VM instance) and is accessed via a web-browser. The Server is easy to install, configure, and use because it was created with a non-technical user in mind. It runs workflows designed in EasyMorph Desktop. Its typical use cases are:

  • Scheduled data preparation and ETL (Extract, Transform, and Load) jobs
  • Integration and data exchange between enterprise and cloud applications
  • Automation of repetitive, routine data-related tasks
  • Data collection and publishing
  • Offloading computationally heavy tasks from desktops
Transform

Extract and transform data, automate data flows

Extract data from databases, spreadsheets, files, corporate applications, and web APIs. Run complex automated workflows that consolidate, transform, and aggregate data using more than 120 various actions. Integrate with external systems in a few clicks.

Easy

Thanks to its fast, high-performance in-memory engine EasyMorph Server quickly processes datasets with millions and tens of millions of records, even on inexpensive machines.

Keep full control of sensitive data

EasyMorph Server is installed on your Windows machine (virtual or not) therefore you have full control of your sensitive data. At any moment, you know exactly where your sensitive data is and who can access it. EasyMorph Server securely processes all data in-memory, on-premises. No information is sent to the cloud or shared with a 3rd party. Optional dataset encryption helps secure data at rest, if necessary.

Task scheduling

Use the Server to transform data, move files, receive/send emails, and perform other tasks on schedule — hourly, daily, or on particular days of week or month. Parameterize tasks, if needed. Trigger tasks manually right from a web browser or programmatically via a REST API.

File collection and sharing

EasyMorph Server comes with a built-in Web File Manager that makes collecting files and publishing data easy. Browse files on EasyMorph Server, upload, and download files right from a web browser.


API and SDK for integration with 3rd party systems

EasyMorph Server can integrate with external systems for cross-system data flows. External systems can automatically trigger Server tasks and upload/download files using the EasyMorph Server REST API. To facilitate using the API, an open-source EasyMorph Server .NET SDK is available and the Server command-line client.


Server pricing

Team Server
Task scheduler
File hosting with web UI
Separated user spaces
REST API and .NET SDK
Users that can create workflowsSee Desktop pricingSee Desktop pricing
Users that run tasks from web UIUnlimitedUnlimited
Running tasks under different Windows accounts
User authentication using Active Directory
Updates
Technical supportEmail support
Community forum
Email support
Community forum
Price per server$3,000/yr$6,000/yr

Upgrading from Team Server to Enterprise Server

It is possible to upgrade from Team to Enterprise Server at any time by paying the price difference.

No Price Increase Guarantee

The annual price is guaranteed to never increase and remain the same as long as renewals do not lapse.

Easy Data Transformation

180-day Money Back Guarantee

If for any reason, you are not satisfied with EasyMorph Server during the first 180 days starting from the payment date, we will refund you the full cost paid for EasyMorph Server and related Desktop licenses. No strings attached.

Discounted Starter Bundles

1 EasyMorph Team Server + 5 EasyMorph Professional + training + updates + support = $5,400/year.

1 EasyMorph Enterprise Server + 5 EasyMorph Professional + training + updates + support = $7,800/year.


Demo

A 7-minute video overview of EasyMorph Server shows creating and running parameterized ETL tasks, uploading and downloading files, and configuring spaces. Book a full demo with us.


Easy Data Transform Alternative

Screenshots

This release adds bug fixes and minor improvements to v1.4.1. The download links are at the bottom of the page.

We recommend that you back-up important transform files before installing any new release. Please let us know of any problems or issues you encounter with the release.

Windows and Mac

1. You can now use command line arguments to process files according to a transform file. This means you can run Easy Data Transform from batch/script files. For details see the Windows or Mac documentation.

2. The Rename Col transform has been replaced by a new Rename Cols transform. The new transform allows you to rename multiple columns in a single operation. The old transform is still available, for backward compatibility, but you can’t add it in v1.5.0.

3. You can now add a new transform between 2 existing transforms. Just select the connection and then select the new transform to insert, either from the Left pane or from the right-click menu.

4. Removing a connection previously tended to nuke all the transform options downstream of it. This is now fixed. You will still have to reset options specific to upstream items (e.g. column selections).

5. If you use the Stack transform to align column by Header name it will now match names case insensitive if no case sensitive match is possible.

6. Previously if a .transform file was moved to a different location or computer then all the paths of the input and output files would potentially have to be reset. Easy Data Transform will now look for files with the same relative location to the .transform file if it can’t find them with the same absolute location. This even works if you move Windows to Mac or vice versa.

For example: c:UserandymyTransform.transform has input file c:Userandydatainput.csv. If the .transform file is moved to c:edtmyTransform.transform (on the same or different computer) and it can’t find c:Userandydatainput.csv then it will look for c:edtdatainput.csv.

7. The numbers of columns and rows in each item is now shown in the Right pane as well as the Center pane.

Easy Data Transform

8. There is a new give option to disable outputs when opening a file check box in the Preferences window. Check this box if you want the option to disable any outputs with write mode overwrite or append when you open a file.

9. You can now change the font used in the data tables via the Preferences window. You might find that a monospaced (fixed width) font works better than the standard operating system font.

Easy Data Transform

10. You can now check make a sound when processing complete in the Preferences window to make a system sound each time processing has completed. It is unchecked by default.

Easy Data Transformer

11. When you hover over an item, the time and date it was last processed are now shown in the tooltip.

12. Items in the Center pane now are shown lighter while awaiting processing. This makes it clearer what needs processing.

When To Log Transform Data

13. Connections now have a bigger selection area, so they are easier to select.

14. Connections were sometimes incorrectly routed after dragging multiple items to a new position. This is now fixed.

15. “NaN” results returned by the Javascript transform are now better handled.