I would like to get notification whenever something is deleted or upserted in semarchy. UPSERT is working nicely since notification's payload has attribute EntityNames which tells us where the data has changed its status. But when DDJ-job finishes it does not return any value for EntityNames. What would be suggested way to get notification of deleted records?
You are correct that the default Delete jobs do not fill in the parameter EntityName with a value. Typically this is because each delete job is specific to only the entity that triggered the Delete. In the Job Notification Policy, you could use the JobName parameter, which will include the entity name.
K
Krunal.parsana
said
about 3 years ago
Can you please provide more details on how to configure data notifications for deletion action without using default job notification server and policy. We are using kafka data notifications and notification server or job notification policy is not configured.
S
Stéphanie FOURRIER
said
about 3 years ago
Hi Krunal,
for record deletions, the ViewType of the data notification has to be set to Deleted Golden or Delete Master to let the notification retrieve the actual data deleted.
This would be different data notification. You will have 2 of them, one with Golden Data for create, update, the other for the deletions. The checkbox "notifiy on empty data set" needs to be unchecked to prevent any duplicate notification.
Stéphanie FOURRIER
I would like to get notification whenever something is deleted or upserted in semarchy. UPSERT is working nicely since notification's payload has attribute EntityNames which tells us where the data has changed its status. But when DDJ-job finishes it does not return any value for EntityNames. What would be suggested way to get notification of deleted records?
Hi,
I learn this option ; a sample in attachment :
Sorry, my UI is in french.
Regards,
Romain.
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstStéphanie FOURRIER
You are correct that the default Delete jobs do not fill in the parameter EntityName with a value. Typically this is because each delete job is specific to only the entity that triggered the Delete. In the Job Notification Policy, you could use the JobName parameter, which will include the entity name.
Krunal.parsana
Can you please provide more details on how to configure data notifications for deletion action without using default job notification server and policy.
We are using kafka data notifications and notification server or job notification policy is not configured.
Stéphanie FOURRIER
Hi Krunal,
for record deletions, the ViewType of the data notification has to be set to Deleted Golden or Delete Master to let the notification retrieve the actual data deleted.
I hope this helps.
Stéphanie.
Romain CHOLLET
Hi,
I learn this option ; a sample in attachment :
Sorry, my UI is in french.
Regards,
Romain.
1 person likes this
-
Recover Deleted(soft Delete) Record and Configure in Application
-
How Can I Trigger Enricher or Sql Procedure when deleting?
-
Unstructured and Semi Structured Data in Semarchy?
-
Read CSV files from AWS S3
-
Find SQL Statements Generated for Match Rules
-
Is it possible to disable specific steps of an Integration Job?
-
Reset the Override on Many Records Through the Interface or By Script
-
PL/SQL Procedure With B_CREDATE and B_UPDDATE Not Mapped or Loaded, Columns Will Be Null
-
Unable to Load Publisher Data Using Continuous Load
-
LoadDataRecord contains non persitable expressions when trying to publish Data using the Rest API
See all 61 topics