Delta upload

[Former Member]

Will UD connection ( from sql database to BI 7.0) does support the delta upload.

Thanks

JSK

[Former Member · Accepted solution]

It will not support automatically. But you can create a field like "change date" in database table and based on that you can fetch daily data.

[former_member184494]

JSK,

Delta extraction works on the concept of delta queues and specific markers..

if you look at LO extraction - it works on a delta queue maintained in the source system

Generic Extraction delta works on the concept of storing the last time delta or init was done and identifying the records added / modified after that using the options of timestamp / date / number pointer

For you to have delta on SQL.. you need to :

a. Have a change capture mechanism in SQL server using a delta queue and extracting only from the delta queue

b. Have a mechanism by which you can identify changed records in SQL and build the logic into your extractor query...