Guidance Needed: Connecting an On-Premises SQL Database to a SharePoint Online Column via Azure Web App Hosting WCF Service

Mohammed El Saka 0 Reputation points
2023-07-16T22:39:14.6433333+00:00

Hello,

I'm working on a project that involves connecting an on-premises SQL Database table to a SharePoint Online lookup column. As a part of the process, I've successfully set up an Azure Web App to host a WCF Service, which is connected to the database server through a hybrid connection.

While I've been able to progress to this point, I'm finding it challenging to discern the next steps in integrating this setup with SharePoint Online. A significant portion of the resources and walkthroughs I've found appear to be outdated or not directly applicable to my situation.

Could you provide guidance on how to proceed? Specifically, I'm looking for the steps to integrate the WCF service (hosted on Azure and connected to the on-premises SQL database) with SharePoint Online. I am aware of using Business Connectivity Services and SharePoint Designer but understand these are less favored in modern SharePoint Online development. Is there a more current, recommended approach?

Any advice or resources that could point me in the right direction would be immensely appreciated.

Best regards,

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,174 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,176 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,275 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,164 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,506 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ajkuma 20,706 Reputation points Microsoft Employee
    2023-07-25T19:27:32.1933333+00:00

    Adding more info:

    From the scenario description, it might be an option to create a custom edit and new-form for the list that needs to include data from the WCF service.

    See for example Creating PowerApps SharePoint ListForms for Custom Lists

    In this form, you would access the WCF service to populate a dropdown field with data from the SQL database, but would store the selected value in a normal text field of the list.

    Note:
    This info contains a URL to a third-party article, I'm just sharing here for your reference. The URL is not controlled by Microsoft.

    0 comments No comments