ETL ldap connection : how to modify a value if already exist in ldap ?

[gilles_chevrier]

Hi,
I need some help to construct a job doing the following :

the system gets a csv file from sftp (tFtpGet -> tFilelist -> tFileInputDelimited). Fine. this part works.
This file contains the uid, the attribute's name ("internalNumber" : not a native attribute the shema) and the internalNumber (this is a telephonenumber) value to be written/updated to the LDAP Directory (OpenDJ).

Now, in order to send the right order (add or update the internalNumber trough the component tLDAPOutput), I need to know if, for each uid, the telephonenumber is already existing or not. Because adding a a value that already exists is not allowed and gives an error.

I really don't know how to go ahead with this problem. As I'm new in ETL, I need your help !

Best regards,
Gilles

[Anonymous]

Hi  Gilles,

This file contains the uid, the attribute's name ("internalNumber" : not a native attribute the shema) and the internalNumber (this is a telephonenumber) value to be written/updated to the LDAP Directory (OpenDJ).
Now, in order to send the right order (add or update the internalNumber trough the component tLDAPOutput), I need to know if, for each uid, the telephonenumber is already existing or not. Because adding a a value that already exists is not allowed and gives an error.

Did you set any primary key in schema setting of tLDAPOutput?
Best regards
Sabrina