Business Data Catalog Editors
Defining the metadata model in the Business Data Catalog (BDC) application definition file can be time consuming and error prone. The Business Data Catalog Definition Editor, which is provided in the SharePoint Server 2007 SDK, helps you to write this file. It uses a graphical user interface and automatically creates entities and methods from the database metadata and the Web Services Description Language (WSDL). For a demonstration of how to use the editor, see Creating a Web Service Connection by Using the Business Data Catalog Definition Editor on MSDN.
Another option is to use a commercial editor. An example is BDC Meta Man. This has a number of features that are not available in the BDC Definition Editor.