The Business Data Catalog definition editor for MOSS is now available as part of the August MOSS SDK download.
[Via SharePoint Products and Technologies Team Blog]
The Business Data Catalog Definition Editor provides a visual tool for creating an Application Definition for BDC in MOSS 2007. Features include:
- Underlying XML is abstracted by the design surface and properties window
- Drag and drop web methods, tables, or views to create line of business (LOB) connections.
- Entities and methods are created automatically from database metadata and WSDLs.
- Additional method instances can be added to further enhance the database or web service connection.
- Method instances can be tested from within the tool, enabling incremental development of LOB connections
Once the SDK has been installed, go to <%Program Files%>\2007 Office System Developer Resources\Tools\BDC Definition Editor\readme.html for instructions on installing and using the tool.
I can’t get the Microsoft BDC Editor to work after a week of trying it on the AdventureWorks database. It’s totally worthless and a waste of time. If Microsoft ever wants to know what’s slowing down the rate of adoption of BDC, providing crappy tools is the pimary reason. I shouldn’t have to waste my time figuring out various “work-arounds” for the most simple things which should already have been QA tested before it ever made its first public appearance.
There has been an ongoing problem with the ‘Business Data Catalog Definition Editor’. It’s only SQL Server 2000 compatible and not SQL Server 2005/2008 compatible
It works fine with any table with a schema of dbo (e.g. dbo.tablename), but if the schema name is something other than dbo (e.g. HumanResources.Employee or Person.Contact) it generates an error message. It works fine with the old NorthWind or Pub databases, but not with the new AdventureWorks or AdventureWorksDW databases. I don’t think this Software was properly tested by MS.
netlinking referencement…
[...]Microsoft BDC Definition Editor for MOSS 2007 « CodeJedi.NET[...]…
Whats up! I simply wish to give an enormous thumbs up for the good data you will have here on this post.
I can be coming again to your weblog for more soon.