What's New in Zoho DataPrep?

Event series

2023

2022

2021

2020

2023

Mar

Set up data pipeline using Zoho CRM Connector

New Feature

Introducing export feature in Zoho CRM connector. You can now export clean, aggregated, and prepared data straight to your Zoho CRM account and build a robust sales data pipeline. Zoho DataPrep helps you continuously clean, prepare, migrate, and warehouse your CRM sales data.

Feb

Deduplicate transform

Enhancement

Deduplicate transform now supports date time, duration, list, and map data types with even more manual conditions to perform deduplication.

SSO for Microsoft OneDrive

Improvements

DataPrep now supports SSO for Microsoft OneDrive. You can now seamlessly access to import data from Microsoft OneDrive, and export back your data.

Jan

Custom duration format

Enhancement

You can now create your own duration format using custom duration format support in DataPrep or pick from one of the predefined formats.

2022

Dec

Amazon S3

Enhancement

Introducing Amazon S3 advanced selection to import data from your S3 bucket's folders using file pattern matching capability. You can also export to a specific location in your S3 bucket with this update.

Oct

Google BigQuery Connector

New Feature

Introducing Google BigQuery connector in Zoho DataPrep. You can now import and export data using Google BigQuery connector and create data pipelines.

Sep

Filter support for more transforms

Enhancement

You can now apply transforms such as Create buckets, Cluster and merge, Fill empty cells, Keyword extraction, and Language detection along with conditional filters.

Jul

Target matching feature updates

Enhancement

Target matching is revamped with a whole host of new features to catch possible errors before exporting data to your destination.

Add constraints to columns

New Feature

You can add constraints to your column data as part of the Change data type transform.

Advanced filters

New Feature

The Advanced filters option allows you to filter data based on custom conditions applied over one or more columns.

Jun

Extract from time

New Feature

You can now extract time components by applying the Extract time transform on a time column.

New filter options added

Enhancement

Filter options "All column" and "Any column" have been added. Delimiters and case-sensitive options in the filter transform are now supported under the wildcard tab.

May

Change time and duration formats

New Feature

Change time and duration transforms introduced.

30+ Time and Duration related functions introduced

You can now add new formula columns using 30+ time and duration related functions.

Apr

Time and duration as data types

New Feature

Time and Duration are newly supported data types. This also includes formatting transforms and formula functions based on these data types.

Transform with filters

You can now apply transforms such as Replace text, Split text, Extract data, etc. along with conditional filters.

Better XML file handling during import

Enhancement

XML files are readily flattened during the import process making it easier to handle the data.

Mar

Connect to data in shared folders from Dropbox

New Feature

Connect and import data from the shared folders of your Dropbox into Zoho DataPrep.

Feb

Cloud Storage - File versioning

Enhancement

File export option lets you choose to update the file with a new version, or add a new file at your data destination during every export.

Pagination in URLs

Enhancement

You can now import larger data in batches using the pagination functionality when you import data from URL and feeds.

Jan

Zia help widget integration

New Feature

Get contextual help - Zia help widget lets you refer help articles from within the DataPrep application. You can also move around the widget pane and work with your data contextually.

Shared files support for Google Drive

Enhancement

You can now import files shared with you in Google Drive in your shared folder.

2021

Dec

Google sheets Import

New Feature

The Google sheets connector now allows you to import your data from Google sheets into Zoho DataPrep directly.

Connect to data in shared folders from cloud storage services

New Feature

Connect and import data from the shared folders of your Box and OneDrive with Zoho DataPrep.

Nov

Zoho DataPrep now in Zoho One

Zoho DataPrep is now included in Zoho One. With this update Zoho One users can now enable Zoho DataPrep and start using it with their existing plan.

Change data type for multiple columns at once

New Feature

With this feature, you can now select multiple columns at a single time and change their data types with a single click.

Oct

Zoho CRM connector

New Feature

Zoho DataPrep helps you clean, prepare, migrate and warehouse your CRM sales data in more than one way. Enhance your Zoho CRM experience with Zoho DataPrep.

Aug

Integration with Zoho Workdrive

New Feature

Connect your data in Zoho WorkDrive with Zoho DataPrep and schedule data imports and exports seamlessly.

Jul

Zoho DataPrep is publicly launched!

Support for more data sources

Enhancement

You can now import data from Amazon S3 and Local databases such as Pervasive SQL, DB2, Exasol, SQLite, Greenplum, Progress OpenEdge, Yugabyte DB, Microsoft Access, Actian Vector, SAP Hana and Denodo. You can also connect to any local database that supports JDBC using the JDBC URL.

Pivot transform

New Feature

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

New Feature

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

Filter transform

Enhancement

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

Window functions

New Feature

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.

Mar

Public beta of Zoho DataPrep

Smart selection

New Feature

Smart selection offers you an array of suggestions using the pattern matching notations when you select portions of the column data that you wish to transform.

Data cataloging

New Feature

Data cataloging helps with data management and discoverability depending on the usage of data assets, their status, and associated information.

2020

Sep

Closed beta of Zoho DataPrep

Closed beta program for Zoho DataPrep launched for select Zoho customers.