External data sources in Zoho Creator, powered by Zoho DataPrep

We’re thrilled to announce that you can now expand your data connectivity capabilities by integrating external data sources with Zoho Creator with help of the new Zoho Creator connector within Zoho DataPrep. This exciting feature allows you to connect with 50+ data sources, including local and cloud databases, and streamline your data workflows like never before.

The ability to use external data sources with Zoho Creator has been a long-requested feature by our customers, and we believe this powerful integration opens up numerous new possibilities for managing your data across platforms.

What is Zoho DataPrep?

Zoho DataPrep is a data pipeline and cleansing tool to bring in your data from various data sources and then clean and prepare the data before pushing it to your preferred destination. DataPrep offers a comprehensive solution to model, cleanse, prepare, enrich, and organize large volumes of data from multiple data sources, to serve data analytics and data warehousing, ML, and more with exceptional data quality.

What can be achieved with this new connector?

With this new Zoho Creator connector, you can effortlessly connect data from 50+ data sources, such as databases, cloud storage solutions, applications, and local servers, with Zoho Creator. This means seamless connectivity with many popular data storage services, whether it's an on-prem DB or a cloud DB, like Oracle Cloud, Azure SQL Database, or AWS RDS.

 

Here's how this integration can help you:

Bidirectional data flow
With this integration, not only can you pull data from diverse sources into Creator apps for the analysis and application process, but you can also push data back to those sources, ensuring data integrity and synchronization across your ecosystem.

For more information, visit the Data sync for Zoho Creator using DataPrep doc.

Data replication
Replicate your data across multiple locations and destinations to improve data availability, enhance security, and prevent data loss. For example, an organization, which has been using Creator for 10 years and has accumulated a large amount of records, can now replicate its Creator data to other sources for audit and compliance purposes.

For more information, visit the Data backup for Zoho Creator using DataPrep doc.

One-time migration from other sources to Creator applications

Simplify the process of migrating your data to and from Zoho Creator with this new connector. For example, an organization can migrate its legacy data into a Creator application, enabling them to embrace the cloud and modernize their operations.

For more information, visit the Data migration for Zoho Creator using DataPrep doc.

Data preparation

Prepare, clean, and transform your data before importing it into Zoho Creator, ensuring high-quality data for your applications. This ensures accuracy and consistency, for smoother operations in your apps.

For more information, visit the Data preparation for Zoho Creator using DataPrep doc.

 

To sum it all up, Zoho DataPrep is yet another powerful and versatile addition to our platform, designed to be a Swiss Army Knife for managing all your data needs.

We encourage you to explore the new Zoho Creator connector in Zoho DataPrep and take advantage of its capabilities to enhance your data management processes.

Should you be interested in Zoho DataPrep, please contact support@zohodataprep.com and we can help you with implementing a solution that fulfill your requirements.

We hope you found this post on Zoho DataPrep integration helpful. If you have any questions, please leave them in the comments below, and we’ll be happy to assist!

Regards,
The Zoho Creator Team

• Topic Participants

• Ashwin Vishal R

  

• Damien Cregan

  

• Ben Norman

• Ari Adar

  

• Sticky Posts

• Introducing Zoho Creator's 2025 Release Projection 2

  Hello Creators! I'm Prakash, from the Creator product management team, and today I'm delighted to unveil our next set of features as part of Release Projection 2 for 2025. With thoughtful analysis and planning, we've curated powerful new capabilities

• Zoho Creator - 2023 Release Projection 1

  Hello everyone! A very Happy New Year to you and your family. Hope you're all good and having a great time using Zoho Creator to make your lives easier and your businesses prosper. 2022 was an action-packed year for us at Creator, and we hope to continue

• Zoho Creator User Group meetups in a city near you! - Oct - Nov, 2023

  Greetings from the Zoho Creator team! We're hosting a series of Zoho Creator meetups in various cities across the globe, and we'd love to meet you there! Our meetups are a great opportunity to network with industry peers, exchange ideas and best practices,

• Zoho Creator - 2023 Release Projection 2

  Hello everyone! Time truly flies when you're having an incredible journey, and today we mark the completion of an eventful and action-packed six months. It feels like just yesterday when we embarked on this adventure together with the launch of our new

• Upcoming Updates - August 2022

  Hi all, Greetings from the Zoho Creator team! Today we've got news for you on some exciting updates. And rest assured— there’s more to come! In this post, we'll be going over the upcoming features and improvements for this month as mentioned below. A

• Recent Topics

• Email Administrators! Join our tips & troubleshooting series

  Greetings to all the admins out there! This announcement is exclusively for you. As we step into the New Year, we’re excited to start a dedicated series of admin-specific tips curated to support you. These posts will help you overcome everyday challenges

• Notes badge as a quick action in the list view

  Hello all, We are introducing the Notes badge in the list view of all modules as a quick action you can perform for each record, in addition to the existing Activity badge. With this enhancement, users will have quick visibility into the notes associated

• Deprecation of the Zoho OAuth connector

  Hello everyone, At Zoho, we continuously evaluate our integrations to ensure they meet the highest standards of security, reliability, and compliance. As part of these ongoing efforts, we've made the decision to deprecate the Zoho OAuth default connector

• Personalize your booking pages with Custom CSS

  Greetings from the Zoho Bookings team! We’re introducing Custom CSS for Zoho Bookings, designed to give you complete control over the look and feel of your booking pages. With this new feature, you can upload your own CSS file to customize colors, fonts,

• Free Webinar : Unlock AI driven business insights with Zoho Inventory + Zoho Analytics

  Are you tired of switching between apps and exporting data to build customized reports? Say hello to smarter & streamlined insights! Join us for this exclusive webinar where we explore the power of the Zoho Inventory–Zoho Analytics integration. Learn

• No OR Filter for Views with a Related Modules Criteria

  We would like to create a Deal View where the User can see all their deals. For that, we would need an OR to connect the criteria. One of the Fields is a "multiselect User", these (Related Modules Criteria) can only be Filter with an AND. Even between

• Creating a Chart from a Report

  In Zoho Analytics, is it possible to create a chart from a Pivot View report? We are looking to use Zoho Analytics to replace Excel for Sales reports and would like to be able to show both the table and the chart together.

• Import Function: ONLY update empty fields

  When setting up an import from a spreadsheet to CRM, there is a checkbox "Don't update empty values for existing contacts" (see screenshot below). While I see some limited benefit from this functionality, I think there should also be an "ONLY update empty

• Sales IQ Chat Widget is Only Displaying Last Name

  Can anyone suggest why the widget is only displaying "last name"?! We have the latest version of the wordpress plugin installed. Thanks Thanks!

• Free Webinar: Zoho Sign for Zoho Projects: Automate tasks and approvals with e-signatures

  Hi there! Handling multiple projects at once? Zoho Projects is your solution for automated and streamlined project management, and with the Zoho Sign extension, you can sign, send, and manage digital paperwork directly from your project workspace. Join

• Begin the year with best practices in the Zoho Desk mobile app : Part 2

  In focus: Optimizing collaboration and supervision Let's begin 2026 with Part 2 of our tips series on driving your ticketing operations at your fingertips. In Part 1, we explored streamlining operations within tickets. This helped individuals at Omniserve

• Process checklist in CRM

  Hi We've created a new sales process that I'm mapping into the CRM - issue I have is that some of the tasks / milestones I would like to capture require very simple tick box responses but there are quite a few under a variety of sub categories so I don't

• Passing the CRM

  Hi, I am hoping someone can help. I have a zoho form that has a CRM lookup field. I was hoping to send this to my publicly to clients via a text message and the form then attaches the signed form back to the custom module. This work absolutely fine when

• Can we disable add to cart in Zoho Commerce?

  Hello, Our sales happen on the phone. During the call the customer is directed to our website to inspect the products together with the sales rep. So we need a way to present our inventory. I figured Zoho Commerce is a good fit for this use case. However we would have to disable the possibility to purchase products in the shop. Is that possible? Sunny regards, Artjom

• Holidays - Cannot Enter Two Holidays on Same Day

  I have a fairly common setup, where part-time employees receive 1/2 day's pay on a holiday and full-time employees receive a full day's pay. Historically, I've been able to accommodate this by entering two separate holidays, one that covers full-time

• Zoho DataPrep and File Pattern configuration

  I'm using Zoho data prep to ingest data from One Drive into Zoho Analytics... The pipeline is super simple but I can't any way to get all the files that I need. Basically I need to bring all the files with a certain pattern and for that I'm using a regex

• Adding a new section to the related details sidebar when creating a new ticket.

  Hello, I was wondering if you can add a new section to the related details sidebar when creating a new ticket. I was wanting to have it to where it also shows the account information related to the contact chosen as well. This is the section I am referring

• JWT Token authentication problem that sometimes generates infinite redirect loops

  Description : Nous proposons un bouton sur notre plateforme permettant de rediriger l'utilisateur vers le portail ZohoDesk via un jeton JWT pour une authentification transparente. Cependant, il arrive que certains utilisateurs soient pris dans une boucle

• Zoho desk desktop application

  does zoho desk has a destop applicaion?

• No funcionan correctamente el calculo de las horas laborales para informe de tickets

  Hola, estoy intentando sacar estadísticas de tiempo de primera respuesta y resolución en horario laboral de mis tickets, pero el calculo de horas en horario laboral no funciona correctamente cree los horarios con los feriados : Ajusté los acuerdos de

• How do I bulk archive my projects in ZOHO projects

  Hi, I want to archive 50 Projects in one go. Can you please help me out , How can I do this? Thanks kapil

• Introducing Dedicated Modules for Plans, Addons, and Coupons in Zoho Billing

  We’ve enhanced the way you manage Plans, Addons, and Coupons in Zoho Billing. Previously, all three grouped together under Subscription Items. Now, each one has its own dedicated module, giving you a cleaner and more intuitive experience. This update

• ZOHO Work Drive Back Up

  I am looking for a ZOHO Work Drive backup solution. Something that is cloud based. There's lots of these kinds of options for Google Drive and other providers, but I have not seen anything for WorkDrive. Any suggestions?

• ZOHO Reports - Filter Logic?

  Hi, I need a way to apply filter logics such as ((1 AND 2) OR 3). All I can see as of now is a way to enter different AND filters in the respective filter column. But how can I add an OR filter? Any advice would be highly appreciated. Mark

• Scanned Doc - selecting Item overwrites Rate

  I have a Vendor Invoice which was uploaded to Documents. I select Add To > New Bill. The OCR is actually quite good, but it is reading an Item Description instead of an Item Number. I remove the description and select the correct Item Number... and it

• Recruit API search

  Hi all, Attempting to call the search api endpoint from Postman using the word element as mentioned in api docs Search Records - APIs | Online Help - Zoho Recruit When making the call to /v2/Candidates/search?word=Saudi receive response of { "code": "MANDATORY_NOT_FOUND",

• Manage control over Microsoft Office 365 integrations with profile-based sync permissions

  Greetings all, Previously, all users in Zoho CRM had access to enable Microsoft integrations (Calendar, Contacts, and Tasks) in their accounts, regardless of their profile type. Users with administrator profiles can now manage profile-based permissions

• Saving reading position + Keep screen on

  While Zoho Notebook is excellent for saving and annotating articles, its utility is severely limited by the lack of reading progress synchronization. On the Android app, if a user exits a long note after reading 50%, the app fails to save the position.

• Zoho LandingPage is integrated with Zoho One!

  Greetings to the Zoho One users out there! We're delighted to let you know that Zoho LandingPage is available in Zoho One too! With Zoho LandingPage, you can host custom-made landing pages, and persuade the visitors to dive deeper by making further clicks,

• Android app sync problem - multiple devices have same problem

  Hello, I am having a problem with synchronization in the Android app. When I create a drawing, the data does not sync correctly—only a blank note is created without the drawing. I tested this on multiple devices, including phones and tablets, and the

• How can i resend a campaign to only one of the recipients on the original campaign

  How can i resend a campaign to only one of the recipients on the original campaign ? Sincererly, Mike

• How to show branch instead of org name on invoice template?

  Not sure why invoices are showing the org name not the branch name? I can insert the branch name using the ${ORGANIZATION.BRANCHNAME} placeholder, but then it isn't bold text anymore. Any other ideas?

• Create CRM Deal from Books Quote and Auto Update Deal Stage

  I want to set up an automation where, whenever a Quote is created in Zoho Books, a Deal is automatically created in Zoho CRM with the Quote amount, customer details, and some custom fields from Zoho Books. Additionally, when the Sales Order is converted

• Marketing Automation Requirements Questions

  I would like to set up a multi-email drip campaign- please see the structure below and confirm if I can achieve this set up in Zoho marketing automation. Where applicable, highlight gaps and workarounds. Thanks Drip email campaign- Can I create one drip

• Sharing URLs and direct access

  Hello, I am storing my team's email signature images on Workdrive. I am creating a public image download share and adding “?directDownload=true” so that the image can be accessed without the Workdrive interface. A few questions: 1) Can we generate friendly

• how to change the page signers see after signing a document in zoho sign

  Hello, How can I please change the page a signer sees after signing a document in Zoho Sign? I cannot seem to find it. As it is now, it shows a default landing page "return to Zoho Sign Home". Thanks!

• Question about using custom_fields in Storefront Add-to-Cart API (error 2003 – required details)

  Hi everyone, I’m working with the Zoho Commerce Storefront API, specifically the Add to Cart endpoint: POST /storefront/api/v1/cart According to the documentation, this endpoint supports a custom_fields parameter for adding line-item custom data. I’m

• Can a project be cloned?

  Good afternoon, greetings. I would like to ask if it's possible to clone a project in Microsoft Project. I found a way to do it using templates, but I'm not sure if there's a direct way to clone a project. Thank you in advance for your attention, and

• Timesheet Tasks in Zoho Books: associate to service item

  How do we associate a service item to timesheet tasks in Zoho Books? For example: Joe spent 5 hours on project:task1 which is Service Item#1 (Income:Service1). When the invoice is issued thru the Project Invoice section, this is not available. When the

• Why Sharing Rules do Not support relative date comparison???

  I am creating a Sharing Rule and simply want to share where "Last Day of Coverage" (Date field) is Greater than TODAY (Starting Tomorrow). However, sharing rules don't have the option to compare a date field to a relative date (like today), only to Static

• Next Page