Before I get lynched, I have only advocated a read only view to data for use external to AC == we do this all then time, chart summation/extraction, reporting/analysis, and studies.
I have had commercial dialysis facility EMR vendors give me views into both Oracle and SQL Server DB's for quality reporting functions, so I know it can be done.
The database remains both intact and secure.
That's all.