The product launch includes some new features you've been asking for

 

50+ data sources

You can now import data from Amazon S3 file storage and from local databases such as, Pervasive SQL, DB2, Exasol, and more. You can also connect to any local database that supports JDBC using the JDBC URL.

 

Pivot transform

The pivot transform distributes the data for easy consumption. It spreads out the data in long, winding tables by converting categories in rows to columns.

 

System-wide search powered by Zia

Zia, Zoho's AI assistant for business is now integrated with Zoho DataPrep to perform a global faceted system-wide search of your data.

 

Advanced Filters

Prepare data using complex data filters based on wildcards, patterns, data quality, regex and more.

 

Window functions

Window functions enable you to perform summations and calculations based on a rolling window of data, relative to the current row. Unlike normal aggregate functions, the window functions keep the original rows intact and add the result as a new column.

Zoho DataPrep has taken the time it takes to clean and import our data from multiple hours down to minutes. I am able to provide my clients better tracking of their key statistics because I now have an automated way to take in their third-party data.

We spend a lot of time writing and maintaining custom scripts to import data, fix errors and transform the data. Using Zoho DataPrep, we easily found the errors in the data and fixed them all from within the tool. We are now looking to eliminate manual scripts and use Zoho DataPrep to automate data preparation.

Zoho DataPrep is an essential tool for our business. As a record label we deal with millions of micro-transactions across thousands of titles and hundreds of stores in dozens of territories. It gives us a deep dive into the data, enabling the creation of valuable analytics in seconds at a fraction of the cost of other platforms.

Zoho DataPrep has allowed us to reduce manual data cleansing and cut down on clunky, additional scripts for transforming the data. With Zoho DataPrep we have been able to streamline our ETL processes and move towards a leaner ETL framework, with much of the transformation work now being done within Zoho itself.

Bob Sullivan JD, Vector Solutions
Claudio Cabeza, Grupo Premo
Andrew Archer,Global Underground Limited
Connor Nobert,Pulse LLC
1 2 3 4
/ 4