- Release notes
- Before you begin
- Getting started
- Integrations
- Working with process apps
- Working with dashboards and charts
- Working with process graphs
- Working with Discover process models and Import BPMN models
- Showing or hiding the menu
- Context information
- Export
- Filters
- Sending automation ideas to UiPath® Automation Hub
- Tags
- Due dates
- Compare
- Conformance checking
- Root cause analysis
- Simulating automation potential
- Starting a Task Mining project from Process Mining
- Triggering an automation from a process app
- Viewing Process data
- Creating apps
- Loading data
- Customizing process apps
- Publishing process apps
- App templates
- Additional resources
Incremental extraction
Depending on your source system, it is possible to run incremental data extraction with CData Sync.
Also, you have to be able to load the data from staging into the blob store. This can be done with a CData Sync job, if your database is supported as a source, see Sources.
For most source systems, CData Sync has preconfigured how incremental extractions should be performed. If that's not the case, the settings have to be edited manually to perform incremental extractions. For more on how to do this, see the official CData Sync documentation.
Follow these steps to make sure incremental data extractions run properly.
- Start the CData Sync Admin console and login as and administrator using the credentials defined during installation of CData Sync.
- Go to Jobs and select the extraction job to display the job settings.
-
Go to the Advanced tab, and edit the Replication Option to deselect the Drop Table option. This enables incremental extraction.
The first time the CData Sync extraction job runs, a full extraction is performed and all source data is extracted. Every next time the CData Sync extraction job runs, only the data that has changed in the source is extracted and the delta is added to the already extracted data.
You need to create an additional CData Sync job to load the data from the staging database into the Azure blob store.
For more information on incremental data extraction with CData Sync, see the official CData Sync documentation.