Eight Steps to Connect Office 365/SharePoint Online with External Data
|
 |
|
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.
In the last couple of years, a lot of companies have started using BCS (Business Connectivity Services) to integrate data from external data sources into SharePoint. It was initially available with Microsoft Office SharePoint Server 2007 and was called Business Data Catalog. Since Version 2013, it is not only possible to read information but also to create, delete or update.
According to Mario Spies, senior strategic consultant at AvePoint, a lot of companies are in the process of moving their SharePoint content from on-premise to Office 365 / SharePoint Online, using tools such as DocAve Migrator from SharePoint 2010 or DocAve Content Manager from SharePoint 2013. In most of these projects, the question arises about how to handle SharePoint external lists connected to data using BDC.
The good news is that SharePoint Online also supports Business Connectivity Services.
Related Topics : Vulnerabilities and Patches, Resellers, Broadcom, Broadband Services, Supercomputing
Ten New Technologies Transforming the Classroom
Here are 10 ways that college professors are taking advantage of the technology students currently use and adding new technologies to enhance the teaching and learning experiences. ... More >>
How and Why Companies Are Incorporating the Power of IBM Watson
Watson continuously learns from previous interactions, gaining in value and knowledge over time. Learn how companies are harnessing that AI power to create and improve products and services. ... More >>
Top 10 Strategic Technology Trends for 2017
Here are the top 10 strategic technology trends that will impact most organizations in 2017. Strategic technology trends are defined as those with substantial disruptive potential or those reaching the tipping point over the next five years. ... More >>