Hi All,
Do we have any predefined option/mechanism in Syniti to extract the delta (changed or created) records from ECC source? If so can you please share the details?
If not what is the best way we can follow to identify the delta records from source?
Thanks & Regards
Ravi
Hi Ravi,
We do have a package type in Collect called "DBMoto Mirror" which performs CDC (changed data capture). https://dsphelp.syniti.com/744/general/Collect/Use_Cases/Extraction_Methods_for_End_to_End_Integration_Solution.htm#Extraction_Methods_and_Tools
DBMoto is now rebranded to Syniti Data Replication (SDR) and you can read more about it at https://support.hitsw.com/hc/en-us/categories/115001319647 or https://sdrhelp.syniti.com/974/UsersGuide/Quick_Start.htm
The replication of data occurs on the database-level, so the exact method used to identify delta records depends on the type of database underlying ECC. For Oracle databases, a very common method is to create Table Triggers in Oracle that write to a log that SDR can read.
We also have a general "delta" methodology for any Collect extract, which you can find an example of in the same Collect article linked above.
Thank you Ben for the update.
Does this feature requires any additional licensing cost or is it delivered as part of ADM?
Hi Ravi,
You'll want to check with your company's Syniti Account Executive to be certain, but every version of SST/DSP/ADM comes with at least a "limited" SDR license. The "limited" license requires that every Target and Source name registered in SDR lines up with a Collect Target and Source name. You can find the SDR license location and install instructions in the installation manual for SST/DSP/ADM (example).
Please sign in to leave a comment.
Comments
3 comments