Import configuration for local databases

Import configuration for local database

While configuring the Schedule, Manual reload, Backfill, Webhooks, or Zoho Flow runs, the import configuration needs to be mandatorily setup for all the sources. Without setting up the import configuration, the run cannot be saved. 


You can configure how to import and fetch incremental data from your databases using the Import configuration option. Select the Click here link to set the import configuration. 

Below is a snapshot from the schedule configuration.


How to import data from source? Select the way you would like to import your data from the drop-down - Import all dataIncremental file fetchDo not import data.

Import all data

This option will import all available data for every run.



Incremental data fetch

Incremental data import is a method used to import new or modified records after the previous sync.

Important: This incremental fetch option is not available when the data is imported using a query from databases.

 




Only modified and new data

To import the modified and new data incrementally from the last imported time, select Only modified and new data option from the drop-down.

Fetch based on: You can enter the date-time column name based on which the file must be sorted and imported.

Use the previously imported file if no new file is available: 

When there are no new files in the source during incremental import,

If the checkbox is checked: The last fetched files will be imported again.

If the checkbox is unchecked: The import will be skipped and no files will be imported.



Do not import data

The data is imported only once. The second time, the rules get applied to the same data and get exported.



    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









                                                                                                          • Related Articles

                                                                                                          • Import data from local databases

                                                                                                            You can import data from the following local databases into DataPrep using Zoho Databridge: MySQL MS SQL Server Oracle PostgreSQL Maria DB Pervasive SQL Sybase DB2 Exasol Sqlite Actian Vector Greenplum Denodo Progress OpenEdge YugabyteDB Microsoft ...
                                                                                                          • Import data from Panoply

                                                                                                            Zoho DataPrep allows you to import data from Panoply, a fully-integrated data management platform that syncs, stores, organizes and analyzes data from many sources. To import data from Panoply 1. Create a pipeline or open an existing pipeline from ...
                                                                                                          • Import data from Heroku PostgreSQL

                                                                                                            Zoho DataPrep allows importing data from PostgreSQL, a cloud database, also known as Postgres. It is a free and open-source relational database management system emphasizing extensibility and SQL compliance. To import data from Heroku PostgreSQL 1. ...
                                                                                                          • Import data from Amazon Redshift

                                                                                                            Zoho DataPrep supports importing data from Amazon Redshift, a cloud database. It is a fully managed, petabyte-scale data warehouse service in the cloud. To import data from Amazon Redshift 1. Create a pipeline or open an existing pipeline from the ...
                                                                                                          • Import data from cloud databases

                                                                                                            You can import data from the following cloud databases: Amazon RDS - MySQL Amazon RDS - MS SQL Server Amazon RDS - Oracle Amazon RDS - PostgreSQL Amazon RDS - Maria DB Amazon RDS - Amazon Aurora MySQL Amazon RDS - Amazon Aurora PostgreSQL Amazon ...
                                                                                                            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