- This topic has 8 replies, 1 voice, and was last updated 9 years, 3 months ago by
.
-
Posts
-
-
Hi, everyone!
I have a problem with dataset type. I have a Webservice returning dataset type. Orchestration use Webservice by adding reference to it. I need map dataset to xml schema to process, but I can’t.
Plesase help me! Thank so much!!
-
Hi,
The DataSet class is supported in BizTalk Server as described in this article:
http://msdn.microsoft.com/en-us/library/aa561724(BTS.20).aspx
In your VS project, after adding a reference to your web service, did you check to see if you also have a reference to System.Data assembly in your project? The DataSet class is derived from that assembly…
Daniel.
-
Hi, Daniel !
I added a reference to System.Data assembly in my project. I try to convert dataset into xmldoccument , but I don’t know how to map
Please tell me clearly!!!
thank so much!!!
-
Hi,
Assuming that your DataSet object exposes a table in a straightfoward manner and that you have your BizTalk schema defined already, in your VS project, after you create a Map, pull the web port (that references your web service response message) as your Source schema, and the BizTalk schema as your Target schema.
Then, on your map grid, drag and drop a Looping Functoid onto it, link the the left-hand side of the functoid to the parent node of your web port schema (that represents a record node) and link the right-hand side of the functoid to the record node of your BizTalk schema. Afterwards, you can link the fields from the web port schema directly to the elements of the BizTalk schema.
Open the properties area of the Map, and make sure you test its functionality by setting its input and output, to verify that things will be fine, before you compile and deploy it.
I hope this is enough information to get you started.
Daniel.
-
Thanks for your response.
I newly learn biztalk because i need your helping so much. I think i did like you. I created two new messages in orchestration that have type of web type.
I creat a transform to map dataset (response from webservice) to biztalk schema. When I choose source schema, no message that I created appear, so I can’t map!!!
I think do I have to convert dataset type into biztalk schema before mapping?
-
Hi,
If you are using BizTalk version 2006 R2, one workaround solution would be to consume this web service in your VS project by using the “Consume WCF Service” wizard when you right-click on your project in Solution Exlorer and select Add -> Add Generated Items..
In the Metadata Source step in the wizard, make sure to choose Metadata Exchange (MEX) endpoint.
The end result is that the wizard will produce an XSD file in your project that represents the signature of your web service method(s), so that you can use that schema in a map in your project.
Hope this helps,
Daniel.
-
-
Hi, Daniel
I have the same problem. But I use biztalk 2006 (not R2). Do you have other solutions for this problem without Biztalk 2006 R2.
Waite for your response soon!!! Thanks!
Steven.
-
Hi Steven,
The other solution that comes to mind is to redesign your web service (if that is possible) using a Contract-First approach. You can download and install the WSCF toolkit from this site:
http://www.thinktecture.com/resourcearchive/tools-and-software/wscf
They also have a walkthrough showing you how to design a web service using the toolkit. Basically, when you build such a web service, the WSDL will expose the underlying message schema, and when you consume the web service in your BizTalk project using a web reference, your Reference.map object (in the generated proxy) will expose a Reference.xsd schema, which will show up in your BizTalk map’s list of available schemas.
Hope this helps,
Daniel.
-
-
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.