2014-07-08 14:29 GMT+02:00 Brad Firestone <[email protected]>: > Hi, > > Hi Brad,
> I am just setting up LSC for the first time. I’ve done lots of searching, > reading the samples and documentation, and reading the mailing list. But > I’m still confused in places. > > I have a MySQL source and OpenLDAP destination. When I’m reading the > documentation for the XML Persistence Map, in the section for > getInetOrgPerson the Select statements are: > > SELECT id as uid, > lastname as sn, > name as cn, > etc…. > FROM users > WHEREid = #uid# > > but in the InetOrgPerson.xml file that is installed, the statements shown > are: > > Select > ‘inetOrgPerson’ objectClass, > pers.“ID”, > pers.“UID”, > pers.“SN”, > pers.”MAIL”, > etc…. > FROM csvdata pers > WHERE per.”MAIL” LIKE #mail# > > Can someone explain the differences to me? The example in the > documentation seems to make sense to me and seems like a clear mapping of > values: Select “id" (from the table: users) to be the value “uid”. But I > don’t understand the purpose of: > ‘inetOrgPerson’ objectClass and: pers.”ID”, > > I don’t see a mapping of values. I also don’t understand the FROM > statement. I assume that the table name is csvdata, but I don’t know why > pers follows the table name. > > Is there any reason to NOT go with the format used in the documentation? > Just in case it matters, I am using a custom objectClass in my LDAP > schema: gnPerson. So I’m modifying the name and values in the XML file to > reflect this: GNPerson.xml and <select id=“getGNPerson”…. I’m not > sure that this makes any difference, but thought I’d mention it. > > I appreciate any help you can provide. I may have other questions in the > future, but I’m trying to work through this, and make sense of all the > configuration one step at a time. > > Well, both configurations are ok, it just need to be valid SQL. You can get some info by searching iBatis documentation (we use iBatis in LSC). For the attribute mapping, you can do it in the SQL (with the "AS" statement), or in lsc.xml with <dataset> and srcBean.getDatasetFirstValueById. Clément.
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
