Eight Steps to Connect Office 365/SharePoint Online with External Data

Email     |     Share  
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Next Eight Steps to Connect Office 365/SharePoint Online with External Data-7 Next

Public Content Type and Create List

Now most of the work is done. By clicking save, the external content type is saved back to SharePoint.

The next step involved in this process is to create an external list that enables users to see and use the data. This is done by clicking “Create Lists & Forms” in the Ribbon. You can specify a name and the default operation for this list. Now you are able to create, read, update or delete items (depending on the permissions and created actions) in the SQL Azure database without leaving SharePoint.

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

More Slideshows

infra100-190x128 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 >>

Global33-290x195 2017 and Beyond: How Digital Innovation Will Impact the World

Digital innovation is by far the biggest influencer, changing the way we do just about everything, from shopping to communication to running a business. ...  More >>

ArriaNLG-IoTAutomation0x Internet of Things Personified: Integration and Automation

The real value that the Internet of Things brings is at the intersection of gathering data and leveraging it. ...  More >>

Subscribe to our Newsletters

Sign up now and get the best business technology insights direct to your inbox.