Find content about external data

Looking for help and resources about external data? You've come to the right place. The following resource guide contains useful links to articles about creating and surfacing external data. Why not bookmark this help topic as a browser Favorites for quick access the next time you need it?

In this article

Overview and Basics

Planning and configuring

Surfacing external data in SharePoint products

Surfacing external data in Office 365

Surfacing external data in Microsoft Office products

Overview and Basics

• Introduction to external data

• Create external content types for SQL Server in SharePoint 2013

• External content types in SharePoint 2013

• Deploy an on-premises Business Connectivity Services solution in SharePoint 2013

Top of Page

Planning and configuring

• Prerequisite software needed to work with external data in Office 2013

• Plan for Business Connectivity Services in SharePoint 2013 (TechNet)

• Configure Business Connectivity Services solutions for SharePoint 2013 (TechNet)

• Business Connectivity Services in SharePoint 2013 (MSDN)

Top of Page

Surfacing external data in SharePoint products

• Create an external list

• Use the Business Data Web Parts

• Differences between native and external lists

• Create and update an external data column in a list or library

Top of Page

Surfacing external data in Office 365

• Create or edit a Secure Store Target Application

• Make an External List from a SQL Azure table with Business Connectivity Services and Secure Store

• Manage Business Connectivity Service Applications

Top of Page

Surfacing external data in Microsoft Office products

• Export an external list to Excel

• Connect an external list to Outlook

• Use external data columns in a Word document

• Use an external list with Visio

• Use external data with Access

Top of Page