October 31, 2011 at 8:46 am
Hi Folks
I was wondering if anyone can advise on what delivery options are avialable terms of publishing reports to external partners if your primary data warehouse is based internally behind a firewall.
Is it possible to have SSRS installed on a server that has external access and thus outside the firewall with connections through the firewall to the backend data warehouse. Would it then be possible to publish the reports to the users via HTTP ? I know SSRS is quote good for custom security.
I assume in terms of licence we would need a full SQL Server licence to run only the SSRS portion of SQL Server on a seperate server to our main data warehouse?
We are sizing up a new project and just wanting a bit of high level info on the what SSRS might be able to offer us in terms of delivering our MI to our end users, some of which are external to our company.
Thanks in Advance
Alan
October 31, 2011 at 10:01 am
I think you can follow two paths here, but I can't speak as to the best choice or many of the details.
1. Use SSRS Security Extensions to create a custom security structure using an infrastructure more or less as you mention.
2. Use an ASP.Net front end where you can control the security with a very high level of granularity and call the appropriate reports through the firewall from SSRS on the back end but display them on the ASP.Net page.
October 31, 2011 at 10:47 am
Thanks for the reply , sounds like a good way forward as I have access to .NET developers. Good to keep costs down as well only need to one licence on the Data Warehouse to run database and SSRS. Enough processor and ram to do this as well 🙂
I wonder what the performance will be like calling reports from .ASP over the firewall to the backend?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply