[midPoint] User creation in oracle database through midpoint

Ivan Noris ivan.noris at evolveum.com
Tue May 31 11:11:18 CEST 2016


Hi Irfan, all,

I have published preliminary Oracle Connector documentation here:
https://wiki.evolveum.com/display/midPoint/Oracle+Connector

The sample (referenced from above wiki page) is:
https://github.com/Evolveum/midpoint/blob/master/samples/resources/oracle/resource-oracle-medium.xml
(tested with 3.3.1 and 3.4-SNAPSHOT).

The connector requires JDBC driver; I have used Oracle JDBC driver
11.2.0.3.0. The JDBC driver JAR must be installed (copied) to your
application server e.g. Tomcat.

The connector can be downloaded from OpenICF, e.g.
https://github.com/OpenRock/OpenICF-oracle-connector (source code). We
will put the connector JAR to our Nexus soon to have it also in binary form.

The Oracle Connector is not embedded in midPoint, so the JAR file must
be installed separately to $midpoint.home/icf-connectors/ directory.
After midPoint restart, the connector should be discovered and usable.
(It also requires Oracle JDBC driver as noted above).

See also: https://wiki.evolveum.com/display/midPoint/MidPoint+Home+Directory

More documentation will come to wiki, just check the above link.

Best regards,
Ivan

On 05/31/2016 10:06 AM, Irfan Ali Khan wrote:
>
> Ok sure. Can you tell me now how can I use the forgerock version.
>
>  
>
> Thanks & Regards,
>
>  
>
> cid:image001.png at 01CE0203.4B683100
>
> *Irfan Ali Khan*
> Oracle Apps DBA
>
> Email: _irfankhan at kfupm.edu.sa <mailto:irfankhan at kfupm.edu.sa>_
>
> Tel:  +   966  3 860  7536           
>
> _http://staff.kfupm.edu.sa/itc/irfankhan/_
>
>  
>
> *From:*midPoint [mailto:midpoint-bounces at lists.evolveum.com] *On
> Behalf Of *Ivan Noris
> *Sent:* Tuesday, May 31, 2016 11:01 AM
> *To:* midpoint at lists.evolveum.com
> *Subject:* Re: [midPoint] User creation in oracle database through
> midpoint
>
>  
>
> Hi,
>
> Oracle connector exists, but was/is developed by Forgerock and I have
> not used it before. I use it now, it works and I will prepare samples
> as soon as possible in the following days and commit to master
> (3.4-SNAPSHOT) tree under samples/resources/...
>
> Regards,
> Ivan
>
> On 05/31/2016 09:51 AM, Irfan Ali Khan wrote:
>
>     Hi Ivan,
>
>      
>
>     I was not aware of oracle connector, that’s why trying to use the
>     Database Table connector.
>
>     It will be great help of yours if you send me any sample.
>
>      
>
>     Thanks & Regards,
>
>      
>
>     cid:image001.png at 01CE0203.4B683100
>
>     *Irfan Ali Khan*
>     Oracle Apps DBA
>
>     Email: _irfankhan at kfupm.edu.sa <mailto:irfankhan at kfupm.edu.sa>_
>
>     Tel:  +   966  3 860  7536           
>
>     _http://staff.kfupm.edu.sa/itc/irfankhan/_
>
>      
>
>     *From:*midPoint [mailto:midpoint-bounces at lists.evolveum.com] *On
>     Behalf Of *Ivan Noris
>     *Sent:* Tuesday, May 31, 2016 10:43 AM
>     *To:* midpoint at lists.evolveum.com <mailto:midpoint at lists.evolveum.com>
>     *Subject:* Re: [midPoint] User creation in oracle database through
>     midpoint
>
>      
>
>     Irfan,
>
>     ... are you trying to provision Oracle accounts? I.e. accounts
>     that are able to log in to the Oracle database?
>
>     Database Table Connector is for provisioning applications with
>     custom tables (one table only). If you wish to provision real
>     Oracle accounts, you should use Oracle connector. I can find it
>     e.g. here: https://github.com/ForgeRock/oracle-connector
>
>     The configuration properties for Oracle connector are different. I
>     will prepare some sample and commit to samples/resources soon.
>     (There are no samples available yet, but I'm using that connector
>     now.)
>
>     Regarads,
>     Ivan
>
>     On 05/31/2016 09:13 AM, Irfan Ali Khan wrote:
>
>         Hi Ivan,
>
>          
>
>         Thanks for the reply, please find the attached XML file.
>
>          
>
>         Thanks & Regards,
>
>          
>
>         cid:image001.png at 01CE0203.4B683100
>
>         *Irfan Ali Khan*
>         Oracle Apps DBA
>
>         Email: _irfankhan at kfupm.edu.sa <mailto:irfankhan at kfupm.edu.sa>_
>
>         Tel:  +   966  3 860  7536           
>
>         _http://staff.kfupm.edu.sa/itc/irfankhan/_
>
>          
>
>         *From:*midPoint [mailto:midpoint-bounces at lists.evolveum.com]
>         *On Behalf Of *Ivan Noris
>         *Sent:* Tuesday, May 31, 2016 9:59 AM
>         *To:* midpoint at lists.evolveum.com
>         <mailto:midpoint at lists.evolveum.com>
>         *Subject:* Re: [midPoint] User creation in oracle database
>         through midpoint
>
>          
>
>         Hi Irfan,
>
>         no idea yet, can you send the resource XML? I would like to
>         see the configuration and schema handling.
>
>         Please remove any confidential info such as passwords etc.
>         from the XML before sending.
>
>         Thank you,
>         regards,
>         Ivan
>
>          
>
>
>
>
>     -- 
>
>       Ing. Ivan Noris
>
>       Senior Identity Management Engineer & IDM Architect
>
>       evolveum.com                     evolveum.com/blog/
>
>       ___________________________________________________
>
>       "Semper ID(e)M Vix."
>
>
>
>
>     _______________________________________________
>
>     midPoint mailing list
>
>     midPoint at lists.evolveum.com <mailto:midPoint at lists.evolveum.com>
>
>     http://lists.evolveum.com/mailman/listinfo/midpoint
>
>
>
> -- 
>   Ing. Ivan Noris
>   Senior Identity Management Engineer & IDM Architect
>   evolveum.com                     evolveum.com/blog/
>   ___________________________________________________
>   "Semper ID(e)M Vix."
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint

-- 
  Ing. Ivan Noris
  Senior Identity Management Engineer & IDM Architect
  evolveum.com                     evolveum.com/blog/
  ___________________________________________________
  "Semper ID(e)M Vix."

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160531/44da961a/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3152 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160531/44da961a/attachment.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3152 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160531/44da961a/attachment-0001.jpe>


More information about the midPoint mailing list