August 11, 2015 at 12:55 am
Hi Friends,
first of all, It s just a general question.
I had an interview last week. This guy raised a question " tell me the advantage of report manager over share point ?" . I have no knowledge in share point so I was not able to give the answer.
I am just curious to know the pros and cons of report manager over share point. Can some please advising me on this?
Any suggestions would be really appreciated.
Thanks,
Charmer
August 11, 2015 at 12:45 pm
The interviewer might be referring to SSRS deployment modes: SharePoint Integrated vs. Native (stand-alone with IIS). If you have an SP architecture setup, using the integrated deployment method can leverage account management setup in SP already. Native is easier to setup from scratch as it is standalone. Can't think of any difference feature-wise between the two on top of my head, just different ways of managing the reports.
August 11, 2015 at 10:15 pm
Hi Miranda,
Thanks for the information. Just curious...Can we do everything on share point that we do on report manager? like subscription and data driven subscription?
Thanks,
Charmer
August 12, 2015 at 6:27 am
Yes, just using SharePoint's interface.
August 12, 2015 at 6:34 am
Native comes out of the box so there is no additional cost associated.
Native is simple to use and setup
Native can be embeded in Webpages using Report viewer control
Sharepoint provides a more richer interface for deisgning reports
Sharepoint Support PowerBI
Sharepoint allows SingleSignOn behaviour
Sharepoint offers application type behaviour with Reports
Most times Native Reports are how projects startoff but as the project grows there soon comes a need to move to sharepoint to standardize the Reporting across the organization.
August 12, 2015 at 6:58 am
Jayanth_Kurup (8/12/2015)
Native comes out of the box so there is no additional cost associated.Native is simple to use and setup
Native can be embeded in Webpages using Report viewer control
Sharepoint provides a more richer interface for deisgning reports
Sharepoint Support PowerBI
Sharepoint allows SingleSignOn behaviour
Sharepoint offers application type behaviour with Reports
Most times Native Reports are how projects startoff but as the project grows there soon comes a need to move to sharepoint to standardize the Reporting across the organization.
There is no difference with Native and SharePoint when designing reports. Reports are designed on SSDT/BIDS or Report Builder and using either you can deploy Native or SharePoint without much difference except for the interface.
August 12, 2015 at 11:02 pm
Jayanth_Kurup (8/12/2015)
Native can be embeded in Webpages using Report viewer control
You can use the Report Viewer control in a stand-alone C# app and source report-content from a SSRS instance running in SharePoint mode so no difference there other than how you craft the Report Server URL.
Sharepoint Support PowerBI
SharePoint supports PowerPivot Galleries but that is an unrelated area of functionality from SSRS so its not a real comparison point.
Sharepoint allows SingleSignOn behaviour
Native instances also support Windows SSO.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
August 13, 2015 at 1:08 am
I should have been more clear about my points , sorry . My point revolve around the self service aspects of MSBI.
Its more difficult to implement singlesignon in SSRS than in Sharepoint , the only time its gets better for SSRS is when authenticating over untrusted domains. Also with SSRS you can embed within a report viewer control and be done unlike a standalone C# app, most reporting I have seen happens over the browser.
PowerBI is available in sharepoint which can use SSRS as a dataset and since the end goal is to achieve good looking reports its definitley something to consider when looking at pros and cons of Sharepoint and SSRS.
Hope his helped
August 13, 2015 at 6:15 am
Jayanth_Kurup (8/13/2015)
I should have been more clear about my points , sorry . My point revolve around the self service aspects of MSBI.Its more difficult to implement singlesignon in SSRS than in Sharepoint , the only time its gets better for SSRS is when authenticating over untrusted domains. Also with SSRS you can embed within a report viewer control and be done unlike a standalone C# app, most reporting I have seen happens over the browser.
My experience has been that getting people into SSRS Report Manager using their Windows Account is simple, I.e. no work required other than having everything joined to a domain. Now, getting a SSRS Data Source configured to use the report runner's credentials and have that work all the way from the client through SSRS and on to the SQL Server, that is another challenge entirely and has proven very difficult at times due to the complexity of configuring Kerberos delegation. That said, I find it far more difficult to get full-stack SSO and Kerberos working for a SharePoint farm than a standalone SSRS instance.
PowerBI is available in sharepoint which can use SSRS as a dataset and since the end goal is to achieve good looking reports its definitley something to consider when looking at pros and cons of Sharepoint and SSRS
Power BI is not a SharePoint-only technology. You can use Power Query in a standalone copy of Excel 2013 and source data from and SSRS report. Not sure if Report data sources are there in the Power BI Designer yet. While I haven't tried it I am pretty sure you can reference a report hosted in SharePoint as a data source too once you figure out how to craft the URL.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply