Office 365: How to sync external SQL data with native SharePoint lists?
The Cloud Connector for Microsoft Office 365 and
SharePoint connects almost any on-premise data source, e.g. ODBC,
OLEDB, OData, Microsoft .NET based providers, Files content (Excel, XML, CSV),
File shares, SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400,
IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision,
SAP, PowerShell and many more directly to native SharePoint
lists and libraries in the Microsoft Office 365 cloud - or any other Microsoft
SharePoint on-premise installation - in just minutes without any programming.
The step-by-step intro below is about connecting to SQL Server.
For any questions please use the FAQ Web Form or contact [email protected] directly.
Integrating external SQL data sources
(e.g. from SQL Server, Oracle, DB2, Informix, MySQL) with native
SharePoint lists (e.g. news, contacts, tasks or custom lists) in Office
365, SharePoint Online or SharePoint 2010/13/16 can close some gaps using
Microsoft SharePoint, on-premise or in the cloud. Please note: It's not only
about displaying external SQL data - it's about full integration with search,
lookups, change notifications, workflows, enterprise
metadata, attachments etc.
This FAQ gives a step-by-step example with MS SQL how to do this. It works in
the same way for any other database. You will find specific connection strings