SharePoint 2007 Developer's Guide to Business Data Catalog
Brett Lonsdale, Nick Swan
  • September 2009
  • ISBN 9781933988818
  • 304 pages
  • printed in black & white

This book is an absolute must-have!

Christina Wheeler, SharePoint Consultant, Summit 7 Systems

The data locked in your organization's systems and databases is a precious—and sometimes untapped—resource. The SharePoint Business Data Catalog makes it easy to gather, analyze, and report on data from multiple sources, through SharePoint. Using standard web parts, an efficient management console, and a simple programming model, you can build sites, dashboards, and applications that maximize this business asset.

SharePoint 2007 Developer's Guide to Business Data Catalog is a practical, example-rich guide to the features of the BDC and the techniques you need to build solutions for end users. The book starts with the basics—what the BDC is, what you can do with it, and how to pull together a BDC solution. With the fundamentals in hand, it explores the techniques and ideas you need to put BDC into use effectively in your organization.

Table of Contents show full



about this book

online resources

about the cover illustration

1. Introducing the Business Data Catalog

1.1. Life before the Business Data Catalog

1.2. What’s the Business Data Catalog?

1.3. BDC architecture

1.4. Data sources and how we connect to them

1.5. Summary

2. Understanding the application definition file

2.1. Introducing the application definition file

2.2. Creating an application definition file

2.3. Summary

3. Security

3.1. Authentication

3.2. Permissions

3.3. Exercise: employing RevertToSelf authentication

3.4. Summary

4. Out-of-the-box BDC Web Parts

4.1. The purpose of the out-of-the-box web parts

4.2. Using SharePoint Designer with the Business Data List Web Part

4.3. Sorting, grouping, and filtering

4.4. Exercise: joining two web parts

4.5. Summary

5. Using the Business Data field type in lists and libraries

5.1. The Business Data field type

5.2. Customizing the Document Information panel with InfoPath 2007

5.3. Creating a SharePoint custom field type

5.4. Summary

6. Configuring BDC search

6.1. Configuring the ADF to allow searching

6.2. Setting up crawling

6.3. Building a custom Search Results page

6.4. Exploring the search web parts

6.5. Modifying the core Search Results page

6.6. The Search API

6.7. Summary

7. MOSS user profiles

7.1. Exploring SharePoint user profiles

7.2. Configuring user profiles

7.3. Audience targeted web parts

7.4. Summary

8. The ApplicationRegistry namespace

8.1. Understanding the ApplicationRegistry namespace

8.2. Creating a WCF web service to expose BDC data

8.3. Using the BDC API with a WF workflow

8.4. Summary

9. Creating a custom BDC Web Part

9.1. Building a basic custom web part

9.2. Adding the functional code

9.3. Creating a code access security file

9.4. Summary

10. Integrating the Business Data Catalog with Microsoft Office

10.1. An introduction to Office Business Applications (OBA)

10.2. Where does the Business Data Catalog fit in?

10.3. Summary

11. Writing back to the line-of-business system

11.1. An introduction to writing back to the BDC

11.2. Creating custom web parts to update LOB data

11.3. Using InfoPath 2007 to write back to the LOB system

11.4. Summary

Appendix A: Connecting to SAP with the BDC

Appendix B: Connecting to Oracle with BDC

Appendix C: Connecting to data sources with web services


What's inside

  • The BDC Object Model
  • How to build BDC applications
  • BDC-driven search
  • Integrating with Office, CRM, and InfoPath

About the reader

Knowledge of SharePoint Server and WSS is required.

About the authors

Brett Lonsdale and Nick Swan are the founders of Lightning Tools, a UK-based SharePoint consulting company specializing in the SharePoint Business Data Catalog.

eBook $43.99 pdf + ePub + kindle

FREE domestic shipping on three or more pBooks

...from experts who know the BDC inside and out.

Monty Grusendorf, Senior Web Developer, Bantrel

An excellent guide for working with the BDC.

Darren Niemke, Author of "ASP.NET 2.0 Web Parts in Action"

A one-stop guide for SharePoint BDC developers.

Prajwal Khanal, SharePoint BDC developers