On 03/04/2019 18:13, Jehan Procaccia wrote: > Still searching for features ... in fact we are comparing between LSC and > Talend for Data Integration workflows ..., I wonder if LSC can take inputs > from multiple sources , let's says a AD and an openldap to populate an SGBD > behind a webservice , or is this an overkill scenario for LSC ? > > we are using LSC for ldap trees aggregation from different institutions to > merge them below a new federated root tree, that works fine, for that purpose > we don't intend to change tools, but for the more complicated scenario above, > devs that use to work with Talend for SGBDs and WS, now that we want to add > ldap integration in the workflow, they push for their product . Will LSC be > a good candidate too ? > Hi,
I would write two tasks, one for each source, and use the executable plugin with scripts that collect and send operations such as get, create or update to your webservice. Not much different than your current set up, except LSC will output to a webservice. Choosing LSC depends on your needs, the kind of data you're syncing and what you need to achieve ; Here are some of the questions I would explore : - how complex are your synchronization rules : entity exists on both sources ? Which source has precedence? What kind of transformation is needed to push to your destination, is it simple or complex business rules to implement ? - Can your webservice fit LSC requirements ; eg. let you pull list or individual entries and their attributes, based on a pivot value shared both sides, perform creation or update operations on entries ? - Do you need to delete orphan entries in your destination (clean mode) ? It may be tricky as clean mode when executed will compare source and destination entries, and delete orphan ones in destination ; With two tasks/two sources you may not be able to identify the entries that have been removed from source, unless they never overlap and you can flag/search them based on their origin. Regards. -- Soisik Froger | Software Architect [email protected] Worteks | https://www.worteks.com _______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] https://lists.lsc-project.org/cgi-bin/mailman/listinfo/lsc-users
