Get this tool! Wow, Todd Baginski did a great job creating a BDC tool that makes life a lot more easier!
From his blog:
“What would you say if I told you that you could create a MOSS BDC Application Definition without writing a single line of code? How about if the process took less than 20 clicks of your mouse?
You'd probably say, I've seen that crazy Application Definition XML file and I think you are pulling my leg. You might recall seeing the contents of the nasty XML file during a demo at a recent SharePoint conference and think to yourself, there's no way, this is too good to be true.
Well, as you can probably guess by now, this is possible with the help of an application I created called the MOSS BDC MetaData Manager. The application allows you to point and click your way to BDC euphoria (if there is such a thing), and requires no knowledge of C#, VB.NET or XML. If you can use a computer then you can use this tool. Seeing that you are using a computer and found your way to this web page, you already qualify!”
download the tool here