SharePoint 2007 Developer's Guide to Business Data Catalog

by Lonsdale, Brett

• ISBN13: 9781933988818
• ISBN10: 1933988819
• Format: Paperback
• Copyright: 2009-09-28
• Publisher: Manning Pubns Co

Summary

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.Knowledge of SharePoint Server and WSS is required."This book is an absolute must-have!" -Christina Wheeler, SharePoint Consultant, Summit 7 Systems" from experts who know the BDC inside and out." -Monty Grusendorf, Senior Web Developer, Bantrel"An excellent guide for working with the BDC." -Darren Neimke, Author of ASP.NET 2.0 Web Parts in Action"A one-stop guide for SharePoint BDC developers." -Prajwal Khanal, Senior Software Engineer, D2HawkeyeServices Pvt. Ltd.

Author Biography

* Brett Lonsdale is a founder of Lightning Tools (www.lightningtools.com), a UK-based SharePoint consultancy specializing in BDC. Brett is a Microsoft Certified Trainer and an experienced trainer for MindSharp in the US and Combined Knowledge in the UK. * NIck Swan is a founder of Lightning Tools (www.lightningtools.com), a UK-based SharePoint consultancy specializing in BDC. Nick is a SharePoint MVP and an experienced trainer for MindSharp in the US and Combined Knowledge in the UK.

Table of Contents

preface	p. xiii
acknowledgments	p. xv
about this book	p. xvii
online resources	p. xxi
about the cover illustration	p. xxii
Introducing the Business Data Catalog	p. 1
Life before the Business Data Catalog	p. 2
Data View Web Part	p. 2
Custom web part	p. 3
Third-party components	p. 3
What's the Business Data Catalog?	p. 3
Business Data Web Parts	p. 4
Business Data column	p. 6
Business Data Search	p. 7
User profile import	p. 8
Custom solutions	p. 9
BDC architecture	p. 10
Data sources and how we connect to them	p. 12
Oracle and SQL	p. 12
Web services	p. 12
Other data sources	p. 12
Application definition file	p. 13
Summary	p. 16
Understanding the application definition file	p. 17
Introducing the application definition file	p. 18
LOBSystem section	p. 19
LOBSystemInstances section	p. 20
Entities	p. 23
Filter descriptors	p. 26
Parameters	p. 27
Business Data Catalog actions	p. 36
Creating an application definition file	p. 37
Summary	p. 40
Security	p. 41
Authentication	p. 42
Integrated Windows Authentication	p. 43
Configuring Single Sign-On	p. 46
Kerberos	p. 50
Permissions	p. 53
Exercise: employing RevertToSelf authentication	p. 56
Summary	p. 57
Out-of-the-box BDC Web Parts	p. 59
The purpose of the out-of-the-box web parts	p. 60
Business Data List Web Part	p. 60
Business Data Item Web Part	p. 64
Business Data Filter Web Part	p. 65
Other out-of-the-box BDC Web Parts	p. 67
Using SharePoint Designer with the Business Data List Web Part	p. 68
Number formatting	p. 70
Conditional formatting	p. 73
Modifying the columns using Microsoft SharePoint Designer	p. 75
Sorting, grouping, and filtering	p. 77
The View footer	p. 78
Tweaking the XSL	p. 79
Exercise: joining two web parts	p. 80
Summary	p. 82
Using the Business Data field type in lists and libraries	p. 83
The Business Data field type	p. 84
Using the Business Data field type	p. 86
The ShowInPicker property	p. 89
The Business Data column with a view	p. 91
Customizing the Document Information panel with InfoPath 2007	p. 93
Creating a SharePoint custom field type	p. 99
Summary	p. 108
Configuring BDC search	p. 109
Configuring the ADF to allow searching	p. 110
Setting up crawling	p. 113
Building a custom Search Results page	p. 118
Exploring the search web parts	p. 120
Search Box Web Part	p. 120
Search Summary Web Part	p. 121
Search Action Links Web Part	p. 121
Search Best Bets Web Part	p. 121
Search Statistics Web Part	p. 122
Search Paging Web Part	p. 122
Search High Confidence Results Web Part	p. 122
Search Core Results Web Part	p. 122
Modifying the core Search Results page	p. 122
The Search API	p. 125
Security trimming the search results	p. 127
Summary	p. 128
Moss user profiles	p. 129
Exploring SharePoint user profiles	p. 131
Identifying colleagues	p. 132
Searching user profiles	p. 133
Audience targeting	p. 134
Configuring user profiles	p. 135
Audience targeted web parts	p. 139
Summary	p. 141
The ApplicationRegistry namespace	p. 143
Understanding the ApplicationRegistry namespace	p. 144
Microsoft.Office.Server.ApplicationRegistry.Administration	p. 145
Microsoft.Office.Server.ApplicationRegistry.Infrastructure	p. 148
Microsoft.Office.Server.ApplicationRegistry.MetadataModel	p. 150
Microsoft.Office.Server.ApplicationRegistry.Runtime	p. 152
Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.db	p. 153
Creating a WCF web service to expose BDC data	p. 153
Using the BDC API with a WF workflow	p. 160
Types of workflow supported by SharePoint	p. 162
Summary	p. 170
Creating a custom BDC Web Part	p. 171
Building a basic custom web part	p. 172
Adding the functional code	p. 178
The Ajax-style refresh interval	p. 180
Creating a code access security file	p. 187
Summary	p. 192
Integrating the Business Data Catalog with Microsoft Office	p. 193
An introduction to Office Business Applications (OBA)	p. 194
Overcoming an everyday problem with OBA	p. 195
Collaboration of applications	p. 196
Where does the Business Data Catalog fit in?	p. 197
Outlook	p. 197
Excel	p. 198
Word	p. 205
Summary	p. 213
Writing back to the line-of-business system	p. 215
An introduction to writing back to the BDC	p. 216
Creating custom web parts to update LOB data	p. 218
Wiring up the web parts	p. 222
Configuring the web parts with BDC Meta Man	p. 224
Using InfoPath 2007 to write back to the LOB system	p. 226
Summary	p. 235
Connecting to SAP with the BDC	p. 237
Connecting to Oracle with BDC	p. 255
Connecting to data sources with web services	p. 257
index	p. 269
Table of Contents provided by Ingram. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program

Currently unavailable