[midPoint] Role assignment from db table

Jason Everling jeverling at bshp.edu
Thu Apr 11 16:51:07 CEST 2019


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/9425e424/attachment.htm>


More information about the midPoint mailing list