<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<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:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Roboto;
panose-1:2 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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]-->
</head>
<body lang="FR-CH" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi everyone,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-GB">I am currently deploying midpoint and I am using the ”ConnId com.evolveum.polygon.connector.scripted.sql.ScriptedSQLConnector v2.1“<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">I have to manage account for multiple custom application, but all those applications use on the same database to manage accounts.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">So I have a table called USER_ACCOUNTS where the key composed of two fields : the name of the user and the name of the application. This table also have multiple other fields to store user data (Phone number, mail, ..)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">If an user have multiple account, he will be inserted multiple time in this table with different applications names.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">What I was planning to do is to use multiple account intents to allow an user having multiple account on the ScriptedSQL resource.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">As the APP name is a field the database table I also managed it as a schema attribute (app_name) and the outbound mapping of this attribute was the AppName. (Which is the same as the intent name)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">It is working for the CreateScript.groovy as I get all the required attributes to create the user but I have a problem with the Update and Delete scripts:
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">In the delete script, no user attributes are given except the user uid and in the update script, only the attributes that need to be updated are passed to the script. So I cannot retrieve the application name from the
attribute (Which I did in the create script).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">In the same way, I don’t seems to be able to retrieve the intent on the scripts, so I can not use it either.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">Is there a way to retrieve intent on the ScriptedSQL scripts, so I can use it to manage different account type in groovy scripts?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">I also cannot use the DatabaseTable connector because I need to update multiple tables on the database when inserting an user.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">I will add that I am not the one in charge of the database architecture and I am not able to change it.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">Thanks for your help,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td colspan="3" valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-GB" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:#E22D36;mso-fareast-language:FR-CH">Loïc Schamber</span></b><span lang="EN-GB" style="mso-fareast-language:FR-CH">
</span><span lang="EN-GB" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:#919191;mso-fareast-language:FR-CH"> | Junior IT Consultant<br>
</span><span lang="EN-GB" style="mso-fareast-language:FR-CH"> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="188" valign="top" style="width:141.0pt;border:none;border-right:solid #E22D36 1.5pt;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a href="https://www.serial.ch/"><span style="color:blue;mso-fareast-language:FR-CH;text-decoration:none"><img border="0" width="193" height="69" style="width:2.0104in;height:.7187in" id="_x0000_i1028" src="cid:image001.png@01D5E674.4658D7C0" alt="logo"></span></a><span style="mso-fareast-language:FR-CH"><o:p></o:p></span></p>
</td>
<td width="10" style="width:7.5pt;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><span style="mso-fareast-language:FR-CH"> <o:p></o:p></span></p>
</td>
<td width="497" valign="top" style="width:372.75pt;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:9.0pt;font-family:"Tahoma",sans-serif;color:#E22D36;mso-fareast-language:FR-CH"><a href="mailto:lschamber@serial.ch"><span style="color:#E22D36">lschamber@serial.ch</span></a>
| <a href="tel:+41%2022%20555%2027%2069"><span style="color:#919191">+41 22 555 27 69</span></a>
<br>
</span><span style="font-size:9.0pt;font-family:"Tahoma",sans-serif;color:#919191;mso-fareast-language:FR-CH">Chemin du Pré-Fleuri 5 – CH 1228 Plan-les-Ouates
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="bottom" style="border:none;border-right:solid #E22D36 1.5pt;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a href="https://www.linkedin.com/company/redcactus-by-positivethinkingcompany" target="_blank"><span style="color:blue;mso-fareast-language:FR-CH;text-decoration:none"><img border="0" width="19" height="19" style="width:.1979in;height:.1979in" id="_x0000_i1027" src="cid:image002.png@01D5E674.4658D7C0" alt="LinkedIn"></span></a><span style="mso-fareast-language:FR-CH">
</span><a href="https://www.instagram.com/positivethinkingcompany" target="_blank"><span style="color:blue;mso-fareast-language:FR-CH;text-decoration:none"><img border="0" width="19" height="19" style="width:.1979in;height:.1979in" id="_x0000_i1026" src="cid:image003.png@01D5E674.4658D7C0" alt="Instagram"></span></a><span style="mso-fareast-language:FR-CH"><o:p></o:p></span></p>
</td>
<td valign="bottom" style="padding:0cm 0cm 0cm 0cm"></td>
<td valign="bottom" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-fareast-language:FR-CH"><a href="www.serial.ch"><b><span lang="EN-GB" style="font-size:9.0pt;font-family:"Tahoma",sans-serif;color:#E22D36">Redcactus by SERIAL
</span></b><span lang="EN-GB" style="font-size:9.0pt;font-family:"Tahoma",sans-serif;color:#E22D36">www.serial.ch</span></a></span><span lang="EN-GB" style="mso-fareast-language:FR-CH"><br>
</span><span style="mso-fareast-language:FR-CH"><a href="www.positivethinking.co"><span lang="EN-GB" style="font-size:9.0pt;font-family:"Tahoma",sans-serif;color:#919191">www.positivethinking.co</span></a></span><span lang="EN-GB" style="mso-fareast-language:FR-CH"><br>
</span><span lang="EN-GB" style="font-size:3.5pt;font-family:"Tahoma",sans-serif;color:#919191;mso-fareast-language:FR-CH"> </span><span lang="EN-GB" style="mso-fareast-language:FR-CH"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<div class="MsoNormal" align="center" style="text-align:center"><span style="mso-fareast-language:FR-CH">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><b><span lang="EN-GB" style="font-size:8.0pt;font-family:Roboto;color:#E22D36;mso-fareast-language:FR-CH">Help save paper, do you really need to print this email?</span></b><span lang="EN-GB" style="mso-fareast-language:FR-CH"><br>
</span><i><span lang="EN-GB" style="font-size:8.0pt;font-family:Roboto;color:black;mso-fareast-language:FR-CH">The content of this email and any attachments are confidential and are intended solely for the person and/or company to whom they are addressed. The
information may also be legally privileged. No employee or agent is authorized to conclude any binding agreement on behalf of SERIAL with another party by email without express written confirmation. If you have received this email in error, any use, reproduction
or dissemination of this transmission is strictly prohibited. If you are not the intended recipient, please immediately notify the sender by return E-mail and delete this message, its attachments and all copies from your system. Internet communications cannot
be guaranteed to be timely, secure, error or virus-free. The sender does not accept liability for any errors or omissions.
</span></i><i><span style="font-size:8.0pt;font-family:Roboto;color:black;mso-fareast-language:FR-CH">Thank you for your cooperation.<br>
</span></i><o:p></o:p></p>
</div>
</body>
</html>