[midPoint] Database resource and multiple tables

[Jason Everling]

We use a few database tables, and I can say, technically no. For one
resource though I was able to work around it by creating a database view
and then using that as the table in midpoint. There is some restrictions to
inserts, updates, deletes, etc.. when using a view, you would need to check
your database docs for that info such as the one for mssql server,
https://msdn.microsoft.com/en-us/library/ms180800.aspx

We also have some others but I had to set those up using the scriptedsql
connector which allows for complex type connections to a database,
https://github.com/Evolveum/midpoint/tree/master/samples/resources/scriptedsql



JASON

On Tue, Aug 9, 2016 at 3:44 PM, Ana Pereyra <apereyra at identicum.com> wrote:

> Hi everyone. I'm writing to ask for information about the database
> connector. I'm using the ICF org.identityconnectors.databasetable.DatabaseTableConnector
> v1.1.0.3-SNAPSHOT version.
>
> What I need to do is synchronize MidPoint different objects to two
> different tables using one resource. For example, adding a user and all his
> attributes from MidPoint to one table and adding his user id and roles to
> another table.
> Is that possible? If it is, can anyone provide documentation about how to
> configure the resource? Thank you very much.
>
> Ana
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
>
>

-- 


CONFIDENTIALITY NOTICE:
This e-mail together with any attachments is proprietary and confidential; 
intended for only the recipient(s) named above and may contain information 
that is privileged. You should not retain, copy or use this e-mail or any 
attachments for any purpose, or disclose all or any part of the contents to 
any person. Any views or opinions expressed in this e-mail are those of the 
author and do not represent those of the Baptist School of Health 
Professions. If you have received this e-mail in error, or are not the 
named recipient(s), you are hereby notified that any review, dissemination, 
distribution or copying of this communication is prohibited by the sender 
and to do so might constitute a violation of the Electronic Communications 
Privacy Act, 18 U.S.C. section 2510-2521. Please immediately notify the 
sender and delete this e-mail and any attachments from your computer. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160809/b720f24e/attachment.htm>