<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Irfan, all,<br>
<br>
I have published preliminary Oracle Connector documentation here:
<a class="moz-txt-link-freetext" href="https://wiki.evolveum.com/display/midPoint/Oracle+Connector">https://wiki.evolveum.com/display/midPoint/Oracle+Connector</a><br>
<br>
The sample (referenced from above wiki page) is:
<a class="moz-txt-link-freetext" href="https://github.com/Evolveum/midpoint/blob/master/samples/resources/oracle/resource-oracle-medium.xml">https://github.com/Evolveum/midpoint/blob/master/samples/resources/oracle/resource-oracle-medium.xml</a>
(tested with 3.3.1 and 3.4-SNAPSHOT).<br>
<br>
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.<br>
<br>
The connector can be downloaded from OpenICF, e.g.
<a class="moz-txt-link-freetext" href="https://github.com/OpenRock/OpenICF-oracle-connector">https://github.com/OpenRock/OpenICF-oracle-connector</a> (source code).
We will put the connector JAR to our Nexus soon to have it also in
binary form.<br>
<br>
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).<br>
<br>
See also:
<a class="moz-txt-link-freetext" href="https://wiki.evolveum.com/display/midPoint/MidPoint+Home+Directory">https://wiki.evolveum.com/display/midPoint/MidPoint+Home+Directory</a><br>
<br>
More documentation will come to wiki, just check the above link.<br>
<br>
Best regards,<br>
Ivan<br>
<br>
<div class="moz-cite-prefix">On 05/31/2016 10:06 AM, Irfan Ali Khan
wrote:<br>
</div>
<blockquote
cite="mid:ce06a1a0174249739275be4f066f8842@srvinfmbx02.kfupm.edu.sa"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Times New Roman \,serif";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.message-info
{mso-style-name:message-info;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle25
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle26
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle27
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Ok sure. Can
you tell me now how can I use the forgerock version.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D">Thanks &
Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><img
id="_x0000_i1027"
src="cid:part1.04000909.02020206@evolveum.com"
alt="cid:image001.png@01CE0203.4B683100" height="56"
width="230"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="color:#7F7F7F">Irfan Ali
Khan</span></b><br>
<span style="color:#A6A6A6">Oracle Apps DBA</span><span
style="font-size:9.5pt;color:#A6A6A6">
</span><span
style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:9.5pt;color:#4F6228">Email: <u><a
moz-do-not-send="true"
href="mailto:irfankhan@kfupm.edu.sa"><span
style="color:#4F6228"><a class="moz-txt-link-abbreviated" href="mailto:irfankhan@kfupm.edu.sa">irfankhan@kfupm.edu.sa</a></span></a></u><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:9.5pt;color:#4F6228">Tel: + 966 3
860 7536
<o:p></o:p></span></p>
<p class="MsoNormal"><u><span
style="font-size:9.5pt;color:#4F6228"><a
moz-do-not-send="true"
href="http://staff.kfupm.edu.sa/itc/irfankhan/"><span
style="color:#4F6228"><a class="moz-txt-link-freetext" href="http://staff.kfupm.edu.sa/itc/irfankhan/">http://staff.kfupm.edu.sa/itc/irfankhan/</a></span></a></span></u><span
style="color:#1F497D"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span
style="color:windowtext"> midPoint
[<a class="moz-txt-link-freetext" href="mailto:midpoint-bounces@lists.evolveum.com">mailto:midpoint-bounces@lists.evolveum.com</a>]
<b>On Behalf Of </b>Ivan Noris<br>
<b>Sent:</b> Tuesday, May 31, 2016 11:01 AM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br>
<b>Subject:</b> Re: [midPoint] User creation in oracle
database through midpoint<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi,<br>
<br>
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/...<br>
<br>
Regards,<br>
Ivan<span style="font-size:12.0pt"><o:p></o:p></span></p>
<div>
<p class="MsoNormal">On 05/31/2016 09:51 AM, Irfan Ali Khan
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="color:#1F497D">Hi Ivan,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">I was not
aware of oracle connector, that’s why trying to use the
Database Table connector.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">It will be
great help of yours if you send me any sample.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D">Thanks
& Regards,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><img
id="Picture_x0020_2"
src="cid:part4.08020501.09070401@evolveum.com"
alt="cid:image001.png@01CE0203.4B683100" height="56"
width="230" border="0"></span><o:p></o:p></p>
<p class="MsoNormal"><b><span style="color:#7F7F7F">Irfan
Ali Khan</span></b><br>
<span style="color:#A6A6A6">Oracle Apps DBA</span><span
style="font-size:9.5pt;color:#A6A6A6">
</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:9.5pt;color:#4F6228">Email: <u><a
moz-do-not-send="true"
href="mailto:irfankhan@kfupm.edu.sa"><a class="moz-txt-link-abbreviated" href="mailto:irfankhan@kfupm.edu.sa">irfankhan@kfupm.edu.sa</a></a></u></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:9.5pt;color:#4F6228">Tel: + 966 3
860 7536
</span><o:p></o:p></p>
<p class="MsoNormal"><u><span
style="font-size:9.5pt;color:#4F6228"><a
moz-do-not-send="true"
href="http://staff.kfupm.edu.sa/itc/irfankhan/"><a class="moz-txt-link-freetext" href="http://staff.kfupm.edu.sa/itc/irfankhan/">http://staff.kfupm.edu.sa/itc/irfankhan/</a></a></span></u><o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span
style="color:windowtext"> midPoint [<a
moz-do-not-send="true"
href="mailto:midpoint-bounces@lists.evolveum.com"><a class="moz-txt-link-freetext" href="mailto:midpoint-bounces@lists.evolveum.com">mailto:midpoint-bounces@lists.evolveum.com</a></a>]
<b>On Behalf Of </b>Ivan Noris<br>
<b>Sent:</b> Tuesday, May 31, 2016 10:43 AM<br>
<b>To:</b> <a moz-do-not-send="true"
href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br>
<b>Subject:</b> Re: [midPoint] User creation in oracle
database through midpoint</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Irfan,<br>
<br>
... are you trying to provision Oracle accounts? I.e.
accounts that are able to log in to the Oracle database?<br>
<br>
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:
<a moz-do-not-send="true"
href="https://github.com/ForgeRock/oracle-connector">https://github.com/ForgeRock/oracle-connector</a><br>
<br>
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.)<br>
<br>
Regarads,<br>
Ivan<o:p></o:p></p>
<div>
<p class="MsoNormal">On 05/31/2016 09:13 AM, Irfan Ali Khan
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="color:#1F497D">Hi Ivan,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Thanks for
the reply, please find the attached XML file.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D">Thanks
& Regards,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><img
id="_x0000_i1026"
src="cid:part4.08020501.09070401@evolveum.com"
alt="cid:image001.png@01CE0203.4B683100" height="56"
width="230" border="0"></span><o:p></o:p></p>
<p class="MsoNormal"><b><span style="color:#7F7F7F">Irfan
Ali Khan</span></b><br>
<span style="color:#A6A6A6">Oracle Apps DBA</span><span
style="font-size:9.5pt;color:#A6A6A6">
</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:9.5pt;color:#4F6228">Email: <u><a
moz-do-not-send="true"
href="mailto:irfankhan@kfupm.edu.sa"><a class="moz-txt-link-abbreviated" href="mailto:irfankhan@kfupm.edu.sa">irfankhan@kfupm.edu.sa</a></a></u></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:9.5pt;color:#4F6228">Tel: + 966 3
860 7536
</span><o:p></o:p></p>
<p class="MsoNormal"><u><span
style="font-size:9.5pt;color:#4F6228"><a
moz-do-not-send="true"
href="http://staff.kfupm.edu.sa/itc/irfankhan/"><a class="moz-txt-link-freetext" href="http://staff.kfupm.edu.sa/itc/irfankhan/">http://staff.kfupm.edu.sa/itc/irfankhan/</a></a></span></u><o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span
style="color:windowtext"> midPoint [<a
moz-do-not-send="true"
href="mailto:midpoint-bounces@lists.evolveum.com"><a class="moz-txt-link-freetext" href="mailto:midpoint-bounces@lists.evolveum.com">mailto:midpoint-bounces@lists.evolveum.com</a></a>]
<b>On Behalf Of </b>Ivan Noris<br>
<b>Sent:</b> Tuesday, May 31, 2016 9:59 AM<br>
<b>To:</b> <a moz-do-not-send="true"
href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br>
<b>Subject:</b> Re: [midPoint] User creation in
oracle database through midpoint</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Irfan,<br>
<br>
no idea yet, can you send the resource XML? I would like
to see the configuration and schema handling.<br>
<br>
Please remove any confidential info such as passwords etc.
from the XML before sending.<br>
<br>
Thank you,<br>
regards,<br>
Ivan<o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman ,serif",serif"> </span><o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New Roman
,serif",serif"><br>
<br>
<br>
</span><o:p></o:p></p>
<pre>-- <o:p></o:p></pre>
<pre> Ing. Ivan Noris<o:p></o:p></pre>
<pre> Senior Identity Management Engineer & IDM Architect<o:p></o:p></pre>
<pre> evolveum.com evolveum.com/blog/<o:p></o:p></pre>
<pre> ___________________________________________________<o:p></o:p></pre>
<pre> "Semper ID(e)M Vix."<o:p></o:p></pre>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman",serif"><br>
<br>
<br>
<o:p></o:p></span></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>midPoint mailing list<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"Times New
Roman",serif"><br>
<br>
<o:p></o:p></span></p>
<pre>-- <o:p></o:p></pre>
<pre> Ing. Ivan Noris<o:p></o:p></pre>
<pre> Senior Identity Management Engineer & IDM Architect<o:p></o:p></pre>
<pre> evolveum.com evolveum.com/blog/<o:p></o:p></pre>
<pre> ___________________________________________________<o:p></o:p></pre>
<pre> "Semper ID(e)M Vix."<o:p></o:p></pre>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ing. Ivan Noris
Senior Identity Management Engineer & IDM Architect
evolveum.com evolveum.com/blog/
___________________________________________________
"Semper ID(e)M Vix."
</pre>
</body>
</html>