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

Pavol Mederly mederly at evolveum.com
Tue Jul 28 07:56:24 CEST 2015


Hello Jason,

I use DB view in MS SQL Server as a data source at Comenius University 
Bratislava - (project currently in progress) - approx 35000 students and 
5000 FTE.
It's working just fine, as a read-only resource.

Pavol

On 27. 7. 2015 20:38, 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 list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20150728/94596e06/attachment.htm>


More information about the midPoint mailing list