How to update records using transform map

reddy8055
Tera Contributor

‎03-28-2023 12:55 PM

Hi,

We have created custom table called Active directory groups and every day groups will be created in this custom table from AD. We have 3 fields (name, Source, email, description), name is marked as collease field. We are looking to update the source and email fields whenever there is change/update happened at AD side. Currently only records are being inserted but data is not being updated.

 

Thanks,

0 Helpfuls
  • 527 Views
3 REPLIES 3

DrewW
Mega Sage
Mega Sage

‎03-28-2023 12:58 PM

Pull over the "objectGUID" and store it in a field and then use that as the coalesce field in your transform map.  I have found thats the best AD attribute to use for this kind of thing.

 

0 Helpfuls

reddy8055
Tera Contributor
In response to DrewW

‎03-28-2023 02:43 PM

By adding objectGUID attribute, this will update all fields in the table ?

 

Thanks,

0 Helpfuls

DrewW
Mega Sage
Mega Sage
In response to reddy8055

‎03-28-2023 03:16 PM

The reason its just inserting new rows all the time is because you do not have a key value in the imported data that also exists in the table you are inserting the data into.  The objectGUID will give you that when you make it the coalesce field.

0 Helpfuls