Zoho DataPrep 2.0 Beta Launch

Being data-driven is an important end goal for all organizations, because when businesses can manage, analyze, and make actionable decisions based on data, they have a competitive advantage.

With that said, how confident are you in making business decisions based on your business data? How clean is your CRM data? Or how much time is spent on manual data cleansing and preparation? 

To help you solve these problems, we're pleased to announce the release of the DataPrep 2.0 public beta! With this new version, it's now even easier to build an end-to-end pipeline and have complete control over the quality and movement of your data.

What's new in 2.0?

Visual pipeline builder 

The all-new pipeline canvas lets you design a seamless end-to-end data flow. Earlier, you were limited to working with a single dataset at a time—but now data can be fetched from multiple sources, more than one dataset can be prepared and used simultaneously, and the data can be exported to multiple destinations. This helps businesses visualize data flows better, simplify complex workflows, and work with data with more confidence.

Unified scheduling of end-to-end pipelines

A massive upgrade has been made to our scheduling feature. In DataPrep 1.0, the sources and destinations had separate schedules which had to be manually managed by staggering the schedule timing, which was hard. But with 2.0, the scheduling can now be set up at the pipeline level. A single unified schedule can be used to manage imports, processing, and exports for all sources and destinations within the pipeline.

Monitor jobs with ease

With automated pipelines, data transfer happens around the clock. Sometimes, there can be issues with fetching data, and the data transfer can fail. But with jobs, you can easily monitor failed jobs with granular details and identify the points of failure. This ensures your organization doesn't miss out on any valuable data. 

Comprehensive version history

Maintain a complete audit trail with version history. Working with data can be challenging; but with the help of this feature, you can easily track changes and run experiments to get more out of your data. Not happy with your experimental changes to data? Easily switch back to the previously published version with the click of a button. 

Backfill your data effortlessly

There can be outages in the data pipeline, this can be due to source or destination failure, changes in the data or model requiring changes in the preparation steps, and can take a while to be restored. However there is no easy way to catch up on processing the data during the outage, to solve this we are now introducing the Backfill feature. The backfill feature can be used to fetch data and simulate a scheduled process for a selected period of time. For example, if there was an outage of 2 days on a pipeline that was setup to run every hour. With backfill, you can now create a configuration to process all that data by simulating the schedule process for the missed two days, this will create 48 new jobs that will run in sequence and process the missed data for two days.

Efficient row processing with incremental fetch

In every scheduled run, choosing the incremental fetch option fetches only the new and updated data from the source for processing.  This was available for few sources in 1.0, but we're expanding the support to all data sources in 2.0. Incremental fetch job runs faster, compared to full fetch as only the newly added rows are processed, also making it more cost effective. 

Transforms made simple with OpenAI 

Our new transforms, powered by OpenAI, help generate complex formulas based on logic written in simple English or transform data based on the sample output given. This simplifies the data preparation process and makes Zoho DataPrep more accessible, even for organizations that don't have a dedicated data analyst team. 

Create instant pipelines with templates 

We built DataPrep with a vision of helping businesses, big or small, have better access to all their business data—but we understand that the data game can be tricky when you're starting out.

To keep our vision alive and to help everyone start using their business data better, we've built a template gallery based on various business use cases that can easily be used to create a pipeline architecture. Just click on the template to add the formula instantly and transforms needed for the data workflow.

You can also save your own data pipelines as templates to make recreating pipelines easier or to apply the data pipeline over a different set of data. You can also share the data pipelines with your organisation or export them as files to share across different organisations.

New dashboard showcasing your pipeline status

Our new and improved dashboard shows the status of all your pipelines instantly. Easily monitor your scheduled runs, identify failed jobs, and ensure your data is up-to-date in your system. 

​

Make data movement easier with other business applications

We are expanding the list of data connectors supported in Zoho DataPrep and as a start we have released the Zoho Creator integration. 

Migrating data into Zoho Creator, as well as seamlessly moving data between various modules within your custom Creator app, has been made easy with DataPrep. 

As more organizations are adopting SaaS products in their tech stack, in order to make data more available, we're opening up integrations with HubSpot, Salesforce, and SurveyMonkey, as well as many more Zoho products, in the next couple of months. Stay tuned for more data connectors in Zoho DataPrep!

Can't wait to try DataPrep 2.0?

All our existing customers can access the Beta version right from within their DataPrep home page. The Beta is not available for Zoho One users yet, but if you want to try out the Beta on a standalone account, contact us at customersuccess@zohodataprep.com 

Zoho DataPrep is designed to make data preparation and movement easy. With DataPrep 2.0, we have completely revamped our product with the new pipeline builder, unified schedules, pipeline templates and universal incremental fetch that lets you easily manage complex data preparation jobs and data movement.  We've also included 50+ other updates to help you clean, prepare, and monitor your business data effortlessly. 

Check out all updates in 2.0

• Topic Participants

• Viswanath Subramani SS

  

• Ben Norman

• SaaSguru

• Sticky Posts

• Announcement: Migrate your workspaces to Zoho DataPrep 2.0

  Zoho DataPrep 2.0 was recently launched with exciting new updates to the platform. You can read more about the new updates in the previous announcement. To take full advantage of the new data pipeline features, migrate your existing workspaces from the

• Announcing Zoho DataPrep 2.0: An AI-Powered Data Management Platform

  Originally launched in 2021, Zoho DataPrep started as an efficient self-service data preparation solution. We are excited to launch our new version 2.0, with significant enhancements to our platform to help you manage your end-to-end data needs with the

• Announcing DataPrep 2.0 Beta!

  Being data-driven is an important end goal for all organizations, because when businesses can manage, analyze, and make actionable decisions based on data, they have a competitive advantage. With that said, how confident are you in making business decisions

• Zoho CRM connector's export functionality enables end-to-end CRM data pipeline

  We're thrilled to announce an update to our Zoho CRM connector that will enable you to create data pipelines to Zoho CRM. The public beta of "export to Zoho CRM" is now available, and can be enabled for users requesting it via email. Using the feature,

• Zoho DataPrep is now launched!

  We are excited to announce the launch of Zoho DataPrep – An advanced self-service data preparation and data pipeline service.  Introducing Zoho DataPrep Zoho DataPrep helps organizations prepare data by automatically identifying errors, discovering data

• Recent Topics

• Power of Automation :: Trigger Automatic reminders to the task owners five days before the due date.

  Hello Everyone, A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:-

• Zoho Flow reads record Tag as number instead of text string. How do I change it?

  I have experience with flow and have a number of them working. This flow is supposed to add a record in a custom module when a Contact record is edited or created with a specific tag. Trigger criteria is "Tag contains 'Athlete' ". However, the flow does

• Can't retrieve url after link in note is converted

  When in a text note if you paste a url after a few seconds Notebook will turn the link into a box with the title of the page that is a button to the website. You can click there dots to delete the new button but there seems to be no way to simply undo

• Font used in quote blocks are not consistent between devices

  Hello. I noticed that as of recent, the font used in quote blocks is not the same on every device. The screenshot posted shows how it looks like on both the mobile and browser versions respectively. Personally I like the browser one more.

• Change my Region of registration to Kenya and not USA

  help change registration region to Kenya

• My running bank balance and my overview bank balance differs

  Hi please assist me. Why would my running balance and my overview bank balance differs. The correct balance is my running bank balance

• CRM - Copy data from Single Line to Lookup Field

  Hello, I need help to create a workflow with a custom function in order to copy value from a single value field to a Lookup Field. Module : Shipment Single value field API name : Customer_ID Lookup field API name : Account_ID WOuld be great to have some

• KENYA REVENUE AUTHORITY ETIMS/TIMS INTEGRATION AND E INVOICING

  Dear Zoho, In reference to the above. I have been having challenges with e-invoicing with KRA e-tims to push my invoices and the integration. Below are some of the screenshots; Kindly help. Thank you. Will appreciate your quick response.

• Requiring Proxy

  We are trying to get support from a company that uses Zoho assist. When we download the helper it is questing that we put in a proxy. What info do we need for the proxy / or to not need a proxy? I have tried a hot spot and allowing the program through

• How to link Custom Fields in Ticket view

  Hi team, I have created 2 custom fields in our Accounts Module would like them to show in our ticket information. We don't have Enterprise so I cannot do it via a workflow, but I know you can do lookup fields to link modules. How would I go about making

• 各種書類のデータダウンロードについて（Excel形式）

  ZOHO CRM で見積書/受注書/請求書など、作成した書類データを1レコード分だけExcel（or csv）形式でダウンロードする方法はあるでしょうか？ 設定→データ管理→エクスポートで抽出できるのは基本的にタブ単位で、任意のレコードのみを抽出できません。

• Rich Text Editor in Zoho Mail Android app

  Hello everyone! In the latest Android version(v2.8) of the Zoho Mail app, we have brought in support for the Rich Text Editor on the compose screen. Rich Text Editor empowers you to create well-structured and visually appealing emails directly from within

• Merging Writer Titles

  When merging from CRM into Writer, is there a way to add fields to the document header? This would be very helpful for saving. Is there a way to link the document automatically to the module?

• Download fails

  We are unable to download data. When we try, we get the message "Download failed." We have two Bases. Downloads are working in one but not the other. The Base with the problem is 'Projects'. We're trying to download Time Records from the Month view. Note:

• Is Zoho tables still being developed?

  Has this product been abandoned? I haven't seen any useful new features or stability improvements over the past six months or more. I think Tables is a great concept, filling a niche between spreadsheets and full database tools, but the current implementation

• Unlocking New Horizons: A Year in Review

  As we bid farewell to 2024, let's celebrate and revisit the key highlights of the year. From adding a new edition to cross-platform enhancements, here’s a roundup of all the feature updates designed to simplify accounting, optimize financial management,

• PDF Import

  Hi Guys, Zoho Sheet now supports file formats such as XLSX, XLS, XLSM, ODS, CSV, TSV, SXC, XLTX, and TXT. However, support for PDF files is not available yet. Adding this option would be very helpful. Thank you!

• Zoho Analytics vs Power BI vs Google Data Studio

  I have been using Zoho Analytics for some time but appears that it is significantly behind Power BI and Google Data Studio in terms of functionality. Our use-case for Zoho Analytics is using data that is coming from third-party sources (and not from Zoho

• Log a Call Function

  First, thank you for implementing the Log a Call function. It's been a frequent request on our team before we can adopt Zoho CRM, and this helps remove that. However, one small detail: the reason people wanted Log a Call was to quickly log a call's activity with the minimum effort possible. With the structure of the new Log a Call function, you have required several fields that are unnecessary for most people and that significantly slow down salespeople or CSRs in logging calls. Could you please

• Report Builder: Create Detailed Email Report for Sent Sales Emails

  I am trying to create what I perceive to be a simple report, showing which contacts have been emailed by my sales team over a certain time period. My requirements: Create a report which shows all emails sent in the past month by a particular account owner

• Round-Robin with Load Based Assignment, can you limit which Status are considered?

  Hello, We are currently using Round-Robin with Load Base Assignment. Is there a way to exclude tickets of a certain Status from being considered by the Round-Robin Assignment rules? For example... I have the following statuses. Escalation Review (meaning

• Introducing Zia LLM: Zoho’s in-house Generative AI solution for CRM's AI capabilities

  Hello everyone, We're excited to announce the launch of our in-house Large Language Model (LLM) by Zia to power our AI offerings. What is LLM? LLM stands for Large Language Model, a powerful AI technology that processes and generates human-like text based

• Document Approval Workflow for Non-Users

  Our organisation has not added client users yet to Zoho but we are currently exploring how we can use the document Review and Approval Workflow to send out project updates to clients. While testing, we found that we can only pick users as approvers. Is

• Syncing Timesheets between Projects and Desk

  All users able to see their own timelog entries from all apps in one place, synced immediately. All managers able to view total/all time entries from one place. This is something that has come up for us and multiple clients. Example: we have a client

• How to listen to ticket change

  Hello community, I created a widget, which checks all departments, if the user has written there as well, as some customer do this. Overall it works fine, except that I have to refresh the widget tab every time I go to another ticket. How can I listen

• How to customize the task reminder notification email

  HI guys,  I hope someone can help with this enquiry: We have included an additional/new field of information when an activity is assigned/created, however this new field is not part of body of the task reminder notification e-mail that is generated by

• Create custom rollup summary fields in Zoho CRM

  Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were

• Invalid Value Type Error Conditional Formatting

  Hello, I'd like to use conditional formatting on a table using Classic conditional formatting for Cell Value, but when I attempt to apply the formatting, I get the error "Invalid Value Type: Value must be of type number". The error is being produced because

• Directly Edit, Filter, and Sort Subforms on the Details Page

  Hello everyone, As you know, subforms allow you to associate multiple line items with a single record, greatly enhancing your data organization. For example, a sales order subform neatly lists all products, their quantities, amounts, and other relevant

• Unattended Installer failure Error 1001

  I found by renaming the PC I was installing and trying again it work. This has happened several times when cloning and installing many pcs and forgetting to change the computer name before installing Zoho assist. Somehow I think the computer name is getting

• ZCAP (Zoho Community Ambassador Programme)のご紹介

  ZCAPとは？ ZCAPは、Zoho サービスを深く愛し、サービスを活用した経験を持ちながら、コミュニティ活動に積極的に貢献している方々を対象としたプログラムです。 さらに、ZCAPメンバーとしてコミュニティに継続的に貢献することで、Zoho Champion に選出されるチャンスがさらに広がります。 ZCAPに参加するメリット 特別なネットワークへのアクセス: 招待制のZCAP限定オンラインスペースに参加し、他のZCAPメンバーと情報交換や議論を行えます。 Zoho の使いこなしに役立つ情報提供:

• Mapping for date field from one module to another.

  Hi there, I want to be able to map a date field(due date) in a module (sales order) to another module's(Purchase Requisition) date field(Promised customer date). Is this possible when the due date field is a zoho system date field while the promised customer

• Telephony External ID field added in CRM

  Dear All, We have an enhancement for users with telephony integrations—introducing the Telephony External ID field. Let's get into the details! What is an external ID field for telephony? External ID fields in Zoho CRM essentially hold a record's reference

• Bluerprints: How to connect the created record back?

  I've a blueprint which creates another record as part of an 'After' transition. But the two records don't seem to be linked together. If it's not automatic - how do I get the created record ID to link it to the original record? Thanks!

• URGENT: Zoho Forms reCAPTCHA v2 Spam Issue

  Hello Everyone, We are encountering a critical issue with Zoho Forms despite having reCAPTCHA v2 enabled. Our business is accessibility-focused, and we are receiving a high volume of spam submissions, which is significantly affecting our workflow and

• Feature Request: Search in the PC client. Some thoughts about the search.

  Hi all. I'm really excited to start using Zoho Notebook, but I'm missing some of the search capabilities on my desktop. There are also some thoughts on improving search in general. Search is very important to me, without it it is difficult for me to use

• How can I create individual records from a subform

  Hi, I am collecting subform data into a Lead record and I need to create individual records for each row associated to the account when it is converted. How can I do this?

• Insufficient "previlleges" to perform this operation? All of a sudden

  Trying to create a ticket report in the free version of Zoho Desk (Analytics > tickets by contact), same as I have always done for the past 4 years every 2 weeks, and I am receiving the following message: I am labeled as Support Administrator, and we

• Introducing Zia GenAI: Zoho's Native Generative AI for Zoho Desk

  Hello everyone, Zia GenAI is available on Early Access for Zoho Desk Enterprise subscribers. Kindly fill out this Registration Form to request early access. We are excited to announce the Beta release of Zia GenAI in Zoho Desk, now available through our

• Update field in “Validations on form submission”

  Hello, I have a hidden field in my form. I created a workflow that is executed when a record is created and triggered an event in the “Validations on form submission”. At this point I retrieve an external ID and need to add this value to the hidden field

• Next Page