Import Incremental data from local databases
- MySQL
- MS SQL Server
- Oracle
- PostgreSQL
- Maria DB
- Pervasive SQL
- Sybase
- DB2
- Exasol
- Sqlite
- Actian Vector
- Greenplum
- Denodo
- Progress OpenEdge
- YugabyteDB
- Microsoft Access
- SAP Hana
- Connect using JDBC URL
To start with import
Info: You can also click the Import data 
8. Enter your Database name and provide the username and password if authentication is required.
Import configuration for local database
If you import data from local database using the Select tables option, you can configure how to import and fetch incremental data from your local database using the below Import configuration options.
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 data, Incremental file fetch, Do not import data.
Import all data
This option will import all available data for every run.
Incremental data fetch
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 data must be sorted and imported.
Use the previously imported data if no new data is available:
During incremental import,
- If the checkbox is checked: When there is no new data in the source, the last fetched data will be imported again.
- If the checkbox is unchecked: When there is no new data in the source, the import will fail and no files will be imported. This will, in turn, cause the entire pipeline job to fail.
Do not import data
The data is imported only once. The second time, the rules get applied to the same data and get exported.
Access your files securely from anywhere
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 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 Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
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.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Import incremental data from local files
Incremental data fetch is a method used to import new files or modified files from a source. Zoho DataPrep helps you import incremental data from your local files using Zoho Databridge. In DataPrep, you can incrementally import various file types, ...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 Microsoft Access
You can import data from the Microsoft Access database into Zoho DataPrep using Zoho Databridge. Click here to know about Zoho Databridge. Before looking into how to import data, let's take a look at the pre-requisites to connect to the Microsoft ...Import data from SAP Hana
You can import data from the SAP Hana database into Zoho DataPrep using Zoho Databridge. Click here to know about Zoho Databridge. Before looking into how to import data, let's take a look at the pre-requisites to connect to the SAP Hana database. ...Import data using Custom JDBC URL
You can import data using Custom JDBC URL into Zoho DataPrep using Zoho Databridge. Click here to know about Zoho Databridge. Before looking into how to import data, let's take a look at the pre-requisites to connect using the Custom JDBC URL. ...