Share via

Sync SharePoint Online List with SQL Server (on-prem) table

Anonymous
2016-07-15T15:42:07+00:00

Hi,

I've been looking into creating a list in SharePoint Online, and have the list sync directly with a sql server table on our network. 

I've been trying to make this work, but can't get it done. I did some reading and from what i'm seeing, i guess it's b/c you can't directly link to a sql server on-prem from SharePoint Online? Is that correct? So, is the right approach to create a Azure SQL database and lync to a table there? 

Thanks,

Vince

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-07-15T21:26:14+00:00

    Hi Vince,

    Yes , you are right. You need to use the Azure SQL database and Business Connectivity Services (BCS) to achieve your requirement.

    For your reference: https://support.office.com/en-us/article/Make-an-External-List-from-a-SQL-Azure-table-with-Business-Connectivity-Services-and-Secure-Store-466f3809-fde7-41f2-87f7-77d9fdadfc95

    http://www.entranceconsulting.com/2015/07/31/office-365-sharepoint-online-azure-data-sync-easy-access-to-line-of-business-data/

    Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

    However, since our forum focuses on Office 365 for Business service, if you need further assistance on the configuration in Azure, I would suggest you post the question in the Azure forum.

    Thanks,

    Cliff

    Was this answer helpful?

    0 comments