Hi, Le 2014-07-31 17:59, Natan Sanson a écrit :
Hi lsc users,I have to sync a lot of jdbc rows with an ldap destination. Any row to update is composed by COL1: USERID COL2: ROLEID COL3: ROLESTATUS The "key" is composed by USERID an ROLEID Inside my ldap I have the users stored with an ldap attribute valued with USERID value, and for each user a multivalued attribute with all the ROLEID values If I try to create a task where the "ldap store" is the sourceservice and the jdc store the "destination service", I don't have a smart way to have multiple entries for each USERID, because the multivalued attribute ROLEID cannot be used to fetch more than a time the same user. LDAP returns always only one time each DN, it doesn't matter how you compose your filter If I try to create a task where the JDBC is the source service and LDAP the destination, I cannot find a way to update the JDBC rows, that it is my goal to achieve I tried to put inside my lsc.xml rows like that without success //If a user does not have this ROLEID, I have to update that it was removed. getOneFilter: (&(objectClass=inetOrgPerson)(USERID={USERID})(!(ROLEID={ROLEID}))) //IF THE ROLEID IS NOT LONGER REPLICATED ON THE LDAP STORE SO I HAVE TO REPORT THE REVOCATION WITHOUT DELETING THE JDBC ROW srcBean.setDataset("ROLESTATUS",dstBean.getDatasetById("AnyLdapAttributeJustToTestTheWriteCapability")); srcBean.datasets().put("ROLESTATUS",dstBean.getDatasetById("AnyLdapAttributeJustToTestTheWriteCapability")); srcBean.datasets().put("ROLESTATUS",dstBean.getDatasetById("AnyLdapAttributeJustToTestTheWriteCapability")); THIS DOES NOT WORK
I'm not sure to understand what you are doing, but of course you can't update source service. Else this would not be a "source" service...
Please let me know if there is a way to update the lack of a value inside an LDAP multivalued attribute on a JDBC store where each value is represented by a row
Still not sure to understand. Maybe if you have a limited set of ROLEID, you can make a task by ROLEID. If you have more complex needs, you can try the executable plugin: it would allow you to do what ever you want, including modifying the source.
Regards, Raphaël Ouazana. _______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
