Microsoft SharePoint 2010 : business connectivity services

Introduction......Page 17
Planning and Maintaining Business Connectivity Services......Page 23
Making SharePoint the Central Hub for Business......Page 25
Reviewing How Businesses Store Data......Page 26
Bringing Data Together in One Place with Business Connectivity Services......Page 27
Using SharePoint as the Central Hub for All Your External Data Sources......Page 31
Building New Solutions......Page 35
Summary......Page 36
Introducing Business Connectivity Services......Page 37
What Is Business Connectivity Services?......Page 38
Types of BCS Solutions......Page 39
The Structure of a BCS Solution......Page 41
Alternative Methods of Connecting SharePoint 2010 with External Systems......Page 45
Introducing the BCS Architecture......Page 47
Connecting to Business Applications......Page 49
BDC Administration......Page 50
External Content Types......Page 51
BCS Security......Page 52
Extending Solutions......Page 55
Planning to Use BCS......Page 56
Summary......Page 57
Creating and Maintaining Business Data Connectivity Service Applications......Page 59
What Are Service Applications?......Page 60
BCS and the Service Application Architecture......Page 61
BCS and the Service Application Infrastructure......Page 66
Authentication......Page 70
Authorization......Page 74
Creating BDC Service Applications......Page 76
Configuring Business Data Connectivity Service Applications......Page 79
Creating a BDC Service Application Administrator......Page 80
Importing and Exporting BDC Models and Resource Files......Page 81
Setting BDC Metadata Store Permissions......Page 87
Configuring Profile Page Creation......Page 89
Configuring the Secure Store Service......Page 91
Creating a Secure Store Service......Page 92
Using the Secure Store Service......Page 95
Using Windows PowerShell to Administer BCS......Page 103
Importing a BDC Model......Page 105
Modifying External System Throttling......Page 106
Administrating BCS in a Tenant Environment......Page 108
Creating a PartitionMode BDC Service Application......Page 110
Summary......Page 111
Defining External System Connections Using SharePoint Designer......Page 113
Creating ECTs Using SharePoint Designer......Page 114
Using the ECT Summary View......Page 115
Using the Operations Design View......Page 123
Using the Summary View and Operations Design View Ribbon Tabs......Page 124
Defining a SQL Server Database Connection......Page 128
Defining a WCF Service Connection......Page 131
Modifying a Data Connection......Page 133
Creating and Maintaining Data Source Operations......Page 134
Defining Parameters for an Operation......Page 137
Understanding Filters......Page 139
Creating Associations......Page 142
Operation Considerations......Page 147
Exporting ECTs......Page 148
Summary......Page 149
Presenting External Data......Page 151
Creating and Using External Lists......Page 153
Creating an External List......Page 154
Creating External Lists Using SharePoint Designer......Page 159
Managing External List Views and Forms......Page 162
External Data and Throttling......Page 163
Creating Views Using the Browser......Page 164
Creating Views Using SharePoint Designer......Page 166
Managing Forms Using the Browser......Page 170
Creating Forms in SharePoint Designer......Page 173
Using External Data in Lists and Libraries......Page 175
Using External Data Actions......Page 179
Profile Page......Page 180
Summary......Page 182
Building Business Data Dashboards......Page 183
Designing a Dashboard......Page 185
PerformancePoint Dashboards......Page 186
Using a Report Library to Create Dashboards......Page 188
Business Data List Web Part......Page 190
Business Data Item and Business Data Item Builder Web Parts......Page 199
Business Data Related List Web Part......Page 202
Business Data Connectivity Filter Web Part......Page 205
Business Data Actions Web Part......Page 207
Chart Web Part......Page 209
Excel Web Access Web Part......Page 213
Status List and Indicator Details......Page 215
Visio Web Access......Page 217
Summary......Page 222
Using External Data with Office Client Applications......Page 223
Surfacing External Data in Word 2010......Page 225
Using External Data in InfoPath Forms......Page 229
Using External Data as Lookup Data......Page 230
Implications of Web Forms vs. Client Forms......Page 235
InfoPath Data Connections......Page 236
Customizing External List Forms with InfoPath......Page 242
Connecting External Data with Office Client Applications......Page 244
SharePoint Workspace 2010......Page 247
External Data and Access 2010......Page 248
Data Visualization in Excel and Visio......Page 251
Troubleshooting BCS Solutions on the Client......Page 253
Optimizing Back-End Synchronization......Page 255
Summary......Page 256
Finding Information from External Systems......Page 257
How SharePoint Search and BCS Work Together......Page 258
Creating Content Sources to Crawl External Systems......Page 261
Creating a Search Scope and Scope Rules......Page 265
Configuring Crawled and Managed Properties......Page 267
Customizing the Search Center......Page 271
Creating Search Tabs......Page 272
Introducing the Search Web Parts......Page 273
Amending the Search XSLT......Page 282
Creating Advanced Search Properties......Page 287
Summary......Page 291
Using External Data in User Profiles......Page 293
Audience Targeting......Page 294
People Search......Page 299
Introducing User Profile Service Applications......Page 300
Mapping External Data to User Profile Properties......Page 302
Business Data Connectivity Synchronization Connection......Page 303
Importing User Profile Properties from External Systems......Page 306
Using Duet Enterprise for Microsoft SharePoint and SAP......Page 308
Summary......Page 311
Introducing Office 365......Page 313
Exploring BCS Functionality in SharePoint Online......Page 315
Building BCS Solutions in SharePoint Online......Page 316
Different SharePoint Online Scenarios......Page 317
Connecting to SQL Azure with SharePoint Online......Page 318
Using a Data Source in SharePoint Designer to Expose External Data......Page 330
Summary......Page 331
Extending the Out-of-the-Box BCS Functionality......Page 333
Using Client-Side Code and External Data......Page 335
Creating Web-Based Solutions Using External Data......Page 336
SharePoint 2010 Client Object Model......Page 337
Client Object Model and Business Data Connectivity......Page 339
Building External Data Solutions Using jQuery......Page 341
Other Example Scenarios......Page 343
Client Object Model vs. BCS Client Runtime......Page 344
Using the BCS Client Runtime in an Excel Add-In......Page 345
Creating VSTO Add-Ins......Page 346
Declarative Outlook Solutions......Page 350
Creating a Declarative Outlook Solution for BCS......Page 353
Packaging the Outlook Declarative Solution......Page 357
Data Solution for Office Add-In......Page 361
Client-Side Caching Considerations......Page 362
Summary......Page 363
Using Visual Studio 2010 to Create SharePoint Solutions......Page 365
Creating BCS Connectors......Page 368
Stepping Through a BCS Connector Example......Page 369
Understanding the User Interface with the “Hello World” Example......Page 370
Creating Your First External Content Type......Page 373
Adding Filters......Page 380
Adding a SpecificFinder Method......Page 382
Writing C# Code for the BDC Model......Page 385
Importing BDC Models into Visual Studio......Page 388
Building Solutions Using the BCS Application Programing Interface......Page 389
Building Workflows with External Data......Page 391
Summary......Page 392
Basic Structure......Page 393
LobSystems......Page 394
LobSystemInstances......Page 395
Entities Element......Page 396
Method......Page 397
Filter Descriptors......Page 398
Parameters......Page 399
Method Instance......Page 400
Index......Page 401