[midPoint] Role assignment from db table

Jason Everling jeverling at bshp.edu
Thu Apr 11 17:02:24 CEST 2019


use the deprecated directory for reference, not sure but those new samples
might be related to the 2.0 connector in development?




On Thu, Apr 11, 2019 at 10:01 AM Jason Everling <jeverling at bshp.edu> wrote:

> see attached, I slimmed it down so you could just get the idea for each
> class. What you are referencing is included in midpoint already and what is
> included in the connector
>
>
> On Thu, Apr 11, 2019 at 9:51 AM Jason Everling <jeverling at bshp.edu> wrote:
>
>> You don't need to add anything else other than the scriptedsql jar ,
>> thats it. Just add it midpoint.home/icf-connectors . Gonna send a sample
>> schema script also so you dont have to create yourself
>>
>>
>>
>>
>> On Thu, Apr 11, 2019 at 8:49 AM Justin Stanczak <rizenine at gmail.com>
>> wrote:
>>
>>> One last last question. I noticed the samples from wiki use:
>>>
>>> *import
>>> org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConfiguration*
>>> *import org.forgerock.openicf.misc.scriptedcommon.ICFObjectBuilder*
>>> *import org.forgerock.openicf.misc.scriptedcommon.OperationType*
>>>
>>> dependencies... I'm not finding a jar with those on the Evolveum site.
>>> Can you point me in the right direction? or should I start a new email for
>>> this question?
>>>
>>> Thanks.
>>>
>>>
>>> On Thu, Apr 11, 2019 at 9:44 AM Jason Everling <jeverling at bshp.edu>
>>> wrote:
>>>
>>>> Yes, use 1.1.2.0.em3
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Apr 11, 2019 at 7:40 AM Justin Stanczak <rizenine at gmail.com>
>>>> wrote:
>>>>
>>>>> One last question before I start working with this connector. Is this
>>>>> the correct connector/version?
>>>>>
>>>>> The links on the wiki seem to be broken and I can't find a
>>>>> *2.0-SNAPSHOT* version.
>>>>>
>>>>> So I did this... Following this link (
>>>>> https://wiki.evolveum.com/display/midPoint/Identity+Connectors) gives
>>>>> me a page with *1.1.2.0.em3* as the recommended version.
>>>>>
>>>>> I then do a search (on nexus.evolveum.com) for that version and find
>>>>> this:
>>>>>
>>>>> https://nexus.evolveum.com/nexus/#browse/search=keyword%3D1.1.2.0.em3:4b378653591c67227aa72e3da422e215:71afea540e23dde5d3d50318239f5932
>>>>>
>>>>> Sound good? Thanks again for your help. Noobs are such a pain, right.
>>>>> :)
>>>>>
>>>>>
>>>>> On Wed, Apr 10, 2019 at 2:39 PM Jason Everling <jeverling at bshp.edu>
>>>>> wrote:
>>>>>
>>>>>> 1. Its the database connector
>>>>>> 2. switch connector
>>>>>> 3. same issue
>>>>>>
>>>>>> Switching your resource as it is is not to difficult to scriptedsql,
>>>>>> you just need to edit the resource xml file and then provide the groovy
>>>>>> scripts, i attached one of our database view scripts, the multivalue role
>>>>>> field is memberOf which in the view is seperated by a semicolon ; and is
>>>>>> constructed using STUFF in sql. I removed many of the column names and
>>>>>> trimmed down the sql script but you can get the idea of how easy it is to
>>>>>> move the scriptedsql. The update script is the same except you use standard
>>>>>> UPDATE/DELETE sql statements.
>>>>>>
>>>>>> _______________________________________________
>>>>> midPoint mailing list
>>>>> midPoint at lists.evolveum.com
>>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>>>
>>>> _______________________________________________
>>>> midPoint mailing list
>>>> midPoint at lists.evolveum.com
>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>>
>>> _______________________________________________
>>> midPoint mailing list
>>> midPoint at lists.evolveum.com
>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20190411/1197e202/attachment.htm>


More information about the midPoint mailing list