Share via

SP Online BCS to on premises sql database (SQL Azure/WCF service)

Shri-6058 326 Reputation points
2022-01-18T06:25:14.787+00:00

Hello,

We use SQL Server databases havily using BCS in SharePoint 2013 onpremises. After I setup SPO tenant, I realize that either I should have SQL Azure or WCF services to connect to onpremises data. Our org do not want to have SQL Azure(additional expense), so the only left out option is WCF service I beleive. I checked over internet and couldnt find clear instructions on how to setup the service. Also there is old approach using OData Service for hybrid solution (https://www.maadarani.com/introduction-to-hybrid-bcs-architecture-part-1/) Is there any WCF Service application sample which connects onprem sql database to SPO online BCS service? I still want to use SharePoint Designer to setup a external content if possible. Company is not recommended to this route as there may be a data compromise or hacker attack. What is the most/best secure and cost effective solutions? I still want to parse WCF service sample database from onprem to SPO BCS for the demo. Will you please advise/direct me the sample WCS services which connects bridges between SPO and Onprem sql database?

Thanks
Shri

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,260 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,928 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,737 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,584 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,853 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CaseyYang-MSFT 10,321 Reputation points
    2022-01-18T09:33:25.717+00:00

    Hi @Shri-6058 ,

    From this: How to connect SharePoint Online to an on-premises SQL Server?

    1.Build an Azure provider hosted app using Hybrid Connections.

    Getting on-premises data from SQL to SharePoint Online using Azure Hybrid Connections

    2.Use WCF services collaborating with Business Connectivity Services (BCS):

    a. Azure Web App hosting WCF Service and External Lists

    b. Azure Web App hosting WCF Data Service and Hosted Apps

    Options to connect SharePoint Online to SQL Server On-Premises with BCS/SharePoint Apps using Hybrid Connection and WCF Services

    For Reference:

    Connecting to SharePoint Online to On-Premises Databases with SharePoint Framework

    Exposing SQL Data in SharePoint Online
    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.

    0 comments