Delta processing means updating data records in the destination by only writing changed (update) or new (insert) data records into the destination. Instead of delta processing, data can be processed in so called “full load” by importing the whole amount of data repeatedly.
Delta processing in Xtract products #
There are three ways of delta processing supported by your Xtract product:
- Using DeltaQ component with the SAP’s own delta processing functionality
- Using ODP component with the SAP’s own delta processing functionality
- Using Table / Table Join component with a database destination
For delta processing it is advisable to use a database on the destination side.
Database destinations #
- Amazon Redshift
- Azure Synapse Analytics
- Azure SQL Database
- IBM DB2
- SAP HANA
- SQL Server