SharePoint 2007: The Definitive Guide
by James Pyles, Christopher M. Buechler, Bob Fox, Murray Gordon, Michael Lotter, Jason Medero, Nilesh Mehta, Joris Poelmans, Christopher Pragash, Piotr Prussak, Christopher J. Regan
External Data Sources
Generally an external data source can be either external to the Report Center site but within SharePoint or completely external to SharePoint. External SharePoint sources can include Web Parts, Web Part pages, and Lists. Sources external to SharePoint can be SAP, Siebel, Microsoft Office Access 2007, and Microsoft SQL Server 2005. While it's outside the scope of this book, you can also write your own data sources.

Figure 15-6. Selecting a workbook to display in an Excel Services Web Part
You can create connections to your external data sources and then store them in the Report Center's Data Connection Library (DCL). The DCL provides a single interface, allowing you to easily manage all of your external data connections. You can also create such connection libraries in any other part of your MOSS 2007 site as you see fit. Connections can be reused or shared as needed, and they allow anyone with access to view and interact with information from disparate data locations, all presented in SharePoint. As Figure 15-7 shows, creating a DCL is pretty much the same as creating any other list or library. One difference you may notice is that you have the option of versioning in this library. As your needs progress over time, you will likely find yourself either updating a data source you manage or finding that the owner of an external data source has modified that source. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access