[midPoint] Any experience with using Database Views as a datbasetable resource?

Jason Everling jeverling at bshp.edu
Tue Jul 28 16:23:43 CEST 2015


Ok thanks for the feedback! Good to know that it is in use in production.

JASON

On Tue, Jul 28, 2015 at 2:44 AM, Ivan Noris <ivan.noris at evolveum.com> wrote:

>  Hi Jason,
>
> I have used DB Table in the similar setup as Pavol - DB View used instead
> of table for read only resource (for synchronization from HR). I have
> probably not used it as target resource that way yet.
>
> Regards,
> Ivan
>
>
> On 07/27/2015 08:38 PM, Jason Everling wrote:
>
> I did this just to test and see if it works,
>
>  Has anyone used a "View" instead of a table? Is using a database table
> view instead of connecting to real tables a supported configuration for the
> dbtableconnector?
>
>  It seems to work just fine, the only restrictions I could see is the
> normal SQL Server restrictions when updating views VS directly updating a
> table.
>
>
>
>  --
>  JASON
>
>
>
> 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.
>
>
> _______________________________________________
> midPoint mailing listmidPoint at lists.evolveum.comhttp://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
>
>


-- 
JASON

-- 


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/20150728/109dc802/attachment.htm>


More information about the midPoint mailing list