Sharepoint Online create an external list to on premise sql database

Rahul Aggarwal 21 Reputation points
2022-04-12T18:59:45.927+00:00

Hello,

I want to create an external list to on premise sql server using the business connectivity service. I know that you can do that with SharePoint On Premise using SharePoint Designer. Can I do the same with SharePoint Online.

Thanks
Rahul

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,009 questions
0 comments No comments
{count} votes

Accepted answer
  1. Kristopher White 76 Reputation points
    2022-04-13T01:27:39.91+00:00

    You can still use BCS with SharePoint Online but because of the lack of some features, and the difficulty in getting the connections to work with permissions, people switched to using PowerApps instead.

    Here is a good article if you have to use BCS. https://aqltech.com/connecting-sharepoint-online-with-bcs/

    Keep in mind SharePoint searching is not available using BCS so you would need to setup some fancy filtering instead.

    Hope that helps,

    Kristopher


0 additional answers

Sort by: Most helpful