How to schedule data export?

Scheduling data export




You can schedule data export using different export configurations in DataPrep.

To schedule data export

  1. Click Export from the top bar in the Studio page and select Schedule export
      

2. Click the New schedule button to create a new schedule for export. 

You can also pause or resume, edit, share, and delete existing schedules from here.



 3. Select a Repeat method (Every 'N' hours, Every day, Weekly once, Monthly once). Choose a time to repeat (i.e. set a frequency) using the Perform every option and your Time zone .



4. You can type in the destination name in the search box or choose the required category and export option. For instance, click Google Drive.



5. If your data contains columns with personal data or ePHI data, you can choose to include or exclude them in the Columns section. 

Security measures to protect your PII data or ePHI data

You can also apply the necessary security methods to protect your personal data column:

A.  Data masking   
Data masking hides original data with 'x' to protect personal information.

B.  Data Tokenization  
Data tokenization replaces each distinct value in your data with a random value. Hence the output is statistically identical to the original data. 

C.  None
You can select none if you do not want to use any security method. You can choose whether to export these column using the corresponding check boxes.



6. You can also select the check box under Export handling and notifications to stop export if the data quality drops below 100%.

7. Select the file name and format in which the data needs to be exported. You can also compress the data as a zip file and encrypt the file with a password.

8. Select the required option from the File export option drop down. You can choose to update the file with a new version at the destination or add a new file during export. 
Note: The File export option is supported for OneDrive, Box, Dropbox, Zoho WorkDrive, and Amazon S3

10. After configuring where to export, click Save.



You can also export your files to your shared folders in Google Drive, Box, OneDrive, Zoho WorkDrive.

  1. Exporting datasets without securing personal data will be restricted if Secure data exports option is enabled in your organization's privacy settings. Click here to know more.
  2. Based on the Compliance settings of your organization, exporting datasets with ePHI data may be restricted or restricted without securing ePHI data with security measures or password protection. 

SEE ALSO

    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION








                                You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                    Manage your brands on social media

                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                        Zoho Marketing Automation

                                          Zoho Sheet Resources

                                           

                                              Zoho Forms Resources


                                                Secure your business
                                                communication with Zoho Mail


                                                Mail on the move with
                                                Zoho Mail mobile application

                                                  Stay on top of your schedule
                                                  at all times


                                                  Carry your calendar with you
                                                  Anytime, anywhere




                                                        Zoho Sign Resources

                                                          Sign, Paperless!

                                                          Sign and send business documents on the go!

                                                          Get Started Now




                                                                  Zoho TeamInbox Resources



                                                                          Zoho DataPrep Resources



                                                                            Zoho DataPrep Demo

                                                                            Get a personalized demo or POC

                                                                            REGISTER NOW


                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • Related Articles

                                                                                                  • Export data to Dropbox

                                                                                                    Zoho DataPrep supports exporting data to Dropbox, a file hosting service. Dropbox offers cloud storage, file synchronization, personal cloud, and client software. To export data to Dropbox 1. Click the Export now option from the Export menu in the ...
                                                                                                  • Export data to OneDrive

                                                                                                    Zoho DataPrep supports exporting data to OneDrive, a file hosting service operated by Microsoft. OneDrive enables registered users to store, protect, share and synchronize their files. To export data to OneDrive 1. Click the Export now option from ...
                                                                                                  • Export data to Panoply

                                                                                                    Zoho DataPrep allows you to export data to Panoply, a fully-integrated data management platform that syncs, stores, organizes and analyzes data from many sources. To export data to Panoply 1. Click the Export now option from the Export menu on the ...
                                                                                                  • Export data to Snowflake

                                                                                                    Zoho DataPrep supports importing data from Snowflake, a cloud database. Snowflake is a cloud data warehouse that can store, process and analyze data. To export data to Snowflake 1. Click the Export now option from the Export menu on the DataPrep ...
                                                                                                  • Export data to Box

                                                                                                    Zoho DataPrep supports exporting data to Box, a cloud storage service that allows users to store, collaborate and manage files securely in an online folder system accessible from any device. To export data to Box 1. Click the Export now option from ...
                                                                                                    Wherever you are is as good as
                                                                                                    your workplace

                                                                                                      Resources

                                                                                                      Videos

                                                                                                      Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                      eBooks

                                                                                                      Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                      Webinars

                                                                                                      Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                      CRM Tips

                                                                                                      Make the most of Zoho CRM with these useful tips.



                                                                                                        Zoho Show Resources