RayCan

Hello All,

I am just cusrious to know how are you guys generating your application definitions in BDC by hand or using one of the tools out there to auto generate that scary XML file I am unable to find a tool which gives me the ability to include stored procedures in my app def instead of pure tables or views

Any help would be appreciated.

Thanks a lot



Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

Mart Muller

Well the known community tools are getting better all the time but do not support everything yet. So, i've done some implementations now with the BDC and basically I did the first one by hand (beta 2). The second one I used ome of the tools to create the basis xml file and adjusted it by hand.

Right now, I basically copy/paste a lot when creating new xml, untill the tools are good enough to create more complex, non-SQL application definitions. As far as I know, the stored procedures are not yet supported but you should be able to get started using the SDK I guess.

-Mart






Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

RayCan

>>As far as I know, the stored procedures are not yet supported but you should be able to get started using the SDK I guess.

Do you mean that using the SDK , I can call my sps How

Thanks a lot





Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

Mart Muller

I haven't found a working example on stored procedures, but I found this:

Methods>
<Method Name="CustomerFinder">
<Properties>
<Property Name="RdbCommandText"
Type="System.String">SPFindCustomer</Property>
<Property Name="RdbCommandType"
Type="System.Data.CommandType">StoredProcedure</Property>
</Properties>
бн.
бн.
</Method>
</Methods>

So basically, you can use stored procedures. Btw, there is a new version of the MOSS SDK, so maybe there is some more info in that one:

http://www.microsoft.com/downloads/details.aspx familyid=6D94E307-67D9-41AC-B2D6-0074D6286FA9&displaylang=en






Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

SharePointing

What tools specifically are out there I found a couple of utlities but wondered if there are better ones out there.




Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

Chris Coddington

There are a couple of database tools floating around. Check out this one:

http://www.sharepointblogs.com/tbaginski/archive/2006/07/16/9259.aspx

Unfortunately I've yet to find one that generates an application definition file when consuming a web service.





Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

SharePointing

Thanks for the link Chris. I hadn't used that one yet. I'll try it out. Should save a considerable amount of time in creating the XML :-)




Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

Nick Swan

Hi all,

we're working really hard at the moment to get BDC Meta Man working for web services. We've got it working but there are a few guidelines here for the first version that we'll be releasing:

http://weblog.vb-tech.com/nick/archive/2007/01/06/2065.aspx

It should be out very very soon!!!

Thanks

Nick






Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

Frank Chiang

Hi All,

Wonder why Microsoft spent so much time creating SPS 2007 with BDC as its main feature failed to provide a tool to help devlopers generate BDC MetaData; that kind of defeat the purpose of trying to get more people to use SPS.

Wonder why BDCMetaMan is charging $1200 per license for the tool that can generate metadata for web service





Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

andrew woodward

Frank,

My take on this is

1) Microsoft have always stated that there is a significant market for partners to develop value added tools for the MOSS platform. BDCMetaMan is one example. What they have done is provide a very good import routine that will identify exactly where in the XML you have problems.

2) If you create a lot of BDC metadata files, it won't take very long for you to recover the $1200 cost of the license, if you just playing with the toolset then it is probably better that you get into the xml to understand it and what can be done.

Andrew






Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

Reza Alirezaei

I agree with Frank. I would not call a metadata generator for BDC a value-added tool, but an essential part of the framework. It should have been there either as an add-on or most likely an extension to VS 2005. When it comes to complex metadata files, digging into the XML file seems to be impossible for most of the people. I will give you an example (not very relevant, but you can get the point):

You probably know that Reporting services reports are infact rdl files that are basically another format of XML. You can go ahead audit these rdl files by hand and upload them to the Reporting Services engine and get them run without any another tool. For hello world demos or very simple reports that is doable approach, but not definitely for complex scenarios. Well, they did not leave it up to the partners and came up with an extension to VS since the beginning of this great product (Jan2004). I think Microsoft should have done the same thing for BDC.





Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

SharePointing

I agree with you all that there should be a better facility for managing the BDC MetaData.. But we have to understand this is the first release of the BDC in concept and we shouldn't expet it to have all of the bells and whistles that a "mature" product has :-)

This gives the partner market a way to buidl these tools and for Microsoft to take the time to build these features into subsequent versions.

Givent he enormity of this release, I think if given the choice of whether to have BDC but to have to muck with the XML myself or to NOT have BDC and wait until Microsoft Can (maybe) abstract it in such a way to make it easier, I'd choose to muck with the XML anyday ;-)






Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

Reza Alirezaei

Hello Steve,

>>the bells and whistles that a "mature" product has :-)

I am not sure if you are referring to Reporting Services here or not. If yes, then I'd say that those whistles and bells have been there with the product since the beginning. if you did not mean that then let's move on to the discussion itself :-)

I guess the point here is the usability. if I or Steve can muck with the XML today:-) , it does not mean that everyone else can do as well. A quick look at the newsgroup posts reveals that how much people are stuck with mucking with these xml files of BDC. Almost everyone I know who has used BDC ( at a higher level than a simple demo :-)) is nagging about the definition files. It is not easy to work with these xml file especially when entity relationships are a bit more complicated.





Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

andrew woodward

Reza

I think we all agree that it would be good to have these tools out of the box, and the 'code free' panacea that we would like has been replaced with coding (for want of a better description) xml files. For now we are left with two options, edit the xml or purchase a xml editor. The choice will probably be down to how many systems you need to integrate too and you confidence in hacking the XML.

Andrew






Re: SharePoint - Business Data Catalog How are you gnerating application definitions?

Reza Alirezaei

Andrew,

>>we are left with two options, edit the xml or purchase a xml editor

This time I do agree with you:-).

Point was that Microsoft should not leave these things to the partners.