[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