Use KDSA to Develop Composite Applications on MOSS The OTB Composite Application Designer (CAD) enables a technical business analyst to:

1. Import one or more database schema and analyze these sources to extract relationships, changes to existing assets, etc.
2. Define information assets that combine information from these sources. For each asset, specify the scope of data object instances exposed in an InfoPath form, SharePoint list or web service.
3. Generate or update: Business Data Catalog application model Stored procedures for SQL Server or Oracle Data Access Service configuration file Web services definition files SQL Server report model

KDSA run time components include the OTB Data Access Service and OTB Host Web Part for InfoPath Forms. Use these components to expose information assets to users in InfoPath forms or ASPX web pages or to other external systems as web services.