260 likes | 681 Views
Business Data Catalog. Todd Kitta 1.8.08. Agenda. Business Data Catalog (BDC) Basics Web Parts BDC Development Search API Demo. BDC Basics. Expose business data with little to no code Consumes data from relational databases and web services Read-only; no updates out of the box
E N D
Business Data Catalog Todd Kitta 1.8.08
Agenda • Business Data Catalog (BDC) Basics • Web Parts • BDC Development • Search • API • Demo
BDC Basics • Expose business data with little to no code • Consumes data from relational databases and web services • Read-only; no updates out of the box • Requires Enterprise Edition of MOSS
Scenarios • Bring business data into SharePoint using web parts • Link business data to list items • Augment back-end application functionality • Search
BDC Terminology • Application • Entity • Action • Method • Association
BDC Actions • Actions bridge the gap between SharePoint and the backend application • Actions are links, therefore they can be whatever you want • Custom Web Part Page • Custom ASP.NET application • InfoPath form
BDC Web Parts • List • Item • Related List • Actions • Item Builder
Development • BDC Applications are just XML; you can create apps in notepad • BDC Meta Man ($1,200) • Includes web parts for KPIs, mapping business data, and displaying business data in a calendar • BDC Definition Editor (free with SharePoint SDK) • BDC Snippets in Visual Studio
BDC & Search • Define method to return a list of crawlable entity IDs • For incremental crawling, you also need to return the last modified date of the entity • Crawled properties are those returned in your BDC application • Mapped properties are available in the search experience (e.g. “lastname:smith”)
BDC & Search • Once your application is created… • Add a content source with type of Business Data • Defined mapped properties • Create Search Scope
Search & Security • Security must be treated specially when doing search because items are already indexed • This is done through “security trimming” • The back-end system must expose some method of checking access on an entity • The BDC will call this method at query time to ensure security is up to date
API • Access BDC functions like get lists and find specific • Perform administrative functions • Develop custom search experiences for business data
Predefined BDC Applications • SAP • Siebel • Dynamics • AutoDesk • Rockwell Software • Many more...
Links • MSDN: http://msdn2.microsoft.com/en-us/library/ms563661.aspx