Share via

Is it possible to have a link in SharePoint online to a dynamic report from an on-site SQL database?

Duncan Fisher 21 Reputation points
2020-09-07T16:23:18.033+00:00

I am seeking to use an existing SQL report to interrogate an on-site database but this be done from a SharePoint online interface, is this possible? If so, what is the architecture required to achieve this within the O365 tenant security bubble?

TIA,

Duncan

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,857 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,185 questions
0 comments
Accepted answer
  1. Echo Du_MSFT 17,141 Reputation points
    2020-09-08T09:53:54.6+00:00

    @Duncan Fisher

    By design, SharePoint Online does not support the SQL Server Reporting Services, so it is not possible to display On-Site Database by using an existing SQL report.

    However, you can choose to build a connection between SQL Database and SharePoint Online via Business Connectivity Services (BCS), and then you can directly view and display data in SQL BD through SharePoint Online.

    You could refer to this article Office 365 SharePoint Online BCS with Azure SQL Server database.

    Thanks,
    Echo Du

    ==============

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest