I’m trying to update a record using Data Integrator. But currently, I have no good results with this. The record is just added, not updated. I would appreciate it if you could show me an example of updating the value of an existing record for an employee’s email address below. I might not have understood the publish name, or the unique key of TRIRIGA.
- (1) triIdTX: 1000004: This is the system generated number at record creation. I assume it’s used as the unique key. (I am not sure if it is the publish name or not.)
- (2) triLastName: Aaaaaaaa: This is the value with the same value when creating a record.
- (3) triFirstName: Bbbbbbbb: This is the value with the same value when creating a record.
- (4) triEmailTX: firstname.lastname@example.org: It was not set when creating a record. And I want to set this value as an update value.
Also, let’s suppose that some values are already set to other fields of triPeople, but are not specified in Data Integrator.
You are correct that it’s adding a record because you’re not using the Publish Name. Take a look at the documentation in Application Building for the IBM TRIRIGA Application Platform 3: Data Management (3.4.x PDF p.35 | 3.5.2 PDF p.31). I confirmed the publish name in our latest release is the same as documented: Last Name + ‘, ‘ + First Name + ‘ – ‘ + ID.
[Admin: To see other related posts, use the Data Integrator tag.]