[midPoint] Role assignment from db table

[Jason Everling]

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/c0573e26/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: schemaScript.groovy
Type: application/octet-stream
Size: 2546 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20190411/c0573e26/attachment.obj>