Conditional SQL import allows you to set option to run the import only in cases when the data in database have changed. To allow this feature go to selected data source, open Conditional settings dialogue window and select option Conditional import enabled.
When this option is selected, scheduled import will run only if the data in the database have changed.
Click on button SQL query to open dialogue window where should be added SQL query which will check if the data have been changed. If the query returns data import will run.
Click on button Create to setup import settings of conditional import:
- Set Time interval in which changes will checked (minimum time interval can be set on 3 minutes)
- Select import method used for this import