The Wayward Programmer

1. Create a web service that returns data in xml format. 2. Open SharePoint Designer, Click on "Data View" on the top tool bar. In the side panel that opens click "Manage Data Sources". 3. Click "Connect to a web service..." 4. Data Source Properties -> Fill in values **Parameters -> Check "The value of this parameter can be set via a web part connection" and insert a default value. (if you don't add a default value then it won't hold the check mark value) To Use Parameters From/To Another Web Part: Drag/drop xml web service onto page. This creates a grid view. Click on it. Click the arrow on the top right corner fo the web service grid on page. Select Parameters link -> "Data View Parameters" window pops up -> Make sure "None" is selected Web Part Connections -> Get Parameters From -> Connect to a Web Prt on this Page -> Current User Filter & Send Filter Values To -> Cntrl Cl...

Security options available when using BDC: Authentication - verify a user is who he/she claims to be. Authorization - Determine if user is permitted access to data. Access Control - Manage access to business data exposed using BDC. When BDC data is exposed on a Web page, the BDC runs within the IIS worker process (w3wp.exe) and uses the IIS application pool user account. When BDC is crawled (search) to index content, it runs in the filter daemon process (msadmn.exe). Authentication models: Trusted Subsystem - System account is used ot access services and resources on behalf of all authenticated users. Fixed identiy is the application pool ID or group ID retrieved from Single Sign-On (SSO) database. Impersonation and Delegation - Delegates authentication to the WFEs and application pool ID impersonates the user. App pool Id connects to business application servers on user's behalf using Kerberos or SSO. Four Authentication Modes: (Defined on the LOBSystemInstance XM...

The Business Data Catalog (BDC) provides a method of exposing business data in SharePoint 2007 through a browser interface. Line of Business Interoperability (LOBi) Reduces or eliminates code Achieves a deeper integration of data into places where users work. Centralizes deployment of data source definitions. Reduce latency to data. Centralize data security auditing connections Perform structured data searches BDC uses ADO.Net, OLEDB, or ODBC drivers to connect to different databases. It can also use Web services to connect to business applications. i.e. SAP, or Sieble applications. Overview on How to Create: Create a SML file with details of data connection and data formats. The XML file is known as an "application definition file" (ADF). The ADF contains a hierarchy of XML elements, and must conform to the schema described in bdcmetadata.xsd (\Microsoft Office Servers\12.0\Bin\bdcmetadata.xsd) To configure Visual Studio 2005 to use bdcmetadata.xsd for Intelli...