We will be deploying an application with a Postgres back-end and need to provide report writing capabilities in SQL Server. I am exploring options for real-time or near real-time reporting in this environment.
I am curious about linking the Postgres database to our SQL Server environment. Would I be able to build views against the Postgres database that our SQL Server report writers could then use? Are there any additional performance considerations beyond the normal ones? (i.e. views are slower than tables)