A handy application that will help you save time in writing XML Schema
EditByBSEditor: MOSS BDC Design Studio is a Tool to aid in writing the necessary XML Schema to Connect Microsoft Office SharePoint Server Business Data Catalog to remote back end systems. Writing this XML by hand is both time consuming and error prone however with this tool you could be up and running within minutes instead of days.

SQL Tables
Automatically Generates Entities, Finder, SpecificFinder and IDEnumerator methods from the database schema by simply dragging the Table onto the design surface from the inbuilt database schema explorer.

SQL Stored Procedures
SQL Server Stored Procedures are fully supported, browse the database schema and drag the procedure onto the design surface and the entity is discovered and wired up automatically.

Web Services
Simply connect MOSS BDC Design Studio to a We Service URL and it will discover the Objects and Methods within the Web Service. You then just drag the objects onto the design surface.

ROI
With Microsoft Office SharePoint Server Consultants costing upwards of $500/Day and typically taking 2-3 days to manually Create BDC Application Definitions this application is going to pay for itself the first time it is used. within minutes instead of days. you can free download MOSS BDC Design Studio 2.0.24 now.