Steps for implementing and utilizing Business Connectivity Services to integrate data from external sources into SharePoint Online.
Conclusion
After migrating SharePoint from an on-premise system to SharePoint online, all external content types and lists will not work anymore because of missing BCS definitions. If these connections are still needed, there are two possible ways to get reconnected.
- Migrate Data to SQL Azure.
- Publish the line of business data as WCF web service.
This enables companies to continue line of business data after moving their on-premise environments to Office 365. Because a fair amount of manual work and planning is involved, customers should include consulting work into the project budget.