RE: Biztalk Connecting to As400

The thing im finding really frustrating is that there is barely any
documentation on pulling data from a satasource into a webservice every
book and tutorial I have looked at never cover using databases which
suprises me somewhat as I would've thought it is an ideal thing to use a
web service for.
I think the problem I am having is that the actual webservice isnt
populated with any fields/nodes until the query is submitted so
obviously biztalk cannot see these.

Thanks for all your pointers so far would it be possible to email me
when you get your as400 webservice up and running it would be
interesting to look at

Rohan


>>> albartell@xxxxxxxxx 08/06/2005 15:20:32 >>>
It sounds like you already know a .NET language and how to build a web
service end point in Visual Studio, so that is the direction I would
keep
going until you can get the full loop working.  At that point if you
decided
that having .NET in the mix isn't right you can move to Java to process
the
XML and do the talking to DB2.

Biztalk can get busy quick.  I would recommend building a full loop
process
that doesn't have any complication built into it but instead is just
for the
purpose of unit testing the connections to all machines/programs
involved.
In effect just build a hello world web service that goes from Biztalk
to
your .NET web service.  Put plenty of console messages in the process
so you
can see exactly where the process is stopping. 

One thing that I do when working with remote communication is write
everything you receive into the .NET web service out to the console.
That
way you know exactly what is being sent and can then determine how to
process it.  Sometimes it is hard to get to the raw HTTP request with
all of
the high level tooling in the IDE's these days.

After you have that written then start building on that knowledge and
add in
content.

HTH,
Aaron Bartell

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On
Behalf Of Rohan Sootarsing
Sent: Wednesday, June 08, 2005 8:50 AM
To: web400@xxxxxxxxxxxx 
Subject: RE: [WEB400] Biztalk Connecting to As400

Yeah something like that,
I have nothing on the iseries itself yet waiting for the request
I know nothing about the as400 i have been having to wing this
I have a file on the as400 which i have build a .net webservice to
access using the .net provider and a sql query. This works fine when I
test it in ie and returns all the data from the as400 file however
when
i try to connect to this webservice it can only see the dataset node
of
the xml and nothing else im guessing this is because all the other
nodes
are generated on the fly.
I Would be interested in learning more about setting up a listener or
this webservice you talk about on your site.
I will be very grateful for any help you can give me 

Regards
Rohan Sootarsing


>>> albartell@xxxxxxxxx 08/06/2005 14:30:16 >>>
Just so I am understanding you here.  You are trying to send an XML
request
from Biztalk to an iSeries machine, correct?  What is waiting for the
XML
request on the iSeries?

You need to have some sort of service (FTP, HTTP, SMTP) on the iSeries
waiting for the XML request. An interesting product I evaluated awhile
back
that allowed Biztalk to make requests direct to RPG programs is called
Attunity (http://www.attunity.com/). Check out their Attunity Connect
product.

If you are looking to create an RPG XML Web service check out my
XMLSAX
parser at http://mowyourlawn.com. Use that coupled with an RPG CGI
program
to create a "Biztalk Listener" on your iSeries.

HTH,
Aaron Bartell

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]

On
Behalf Of Rohan Sootarsing
Sent: Wednesday, June 08, 2005 3:35 AM
To: web400@xxxxxxxxxxxx 
Subject: [WEB400] Biztalk Connecting to As400

Hello,
I have created a webvservice to connect to as400 
however im having problems connecting to this from biztalk 
I was wondering if anyone had managed to connect biztalk to as400

Thanks in advance 
Rohan


____________________________________________________________________________
__
This message has been checked for viruses by Corpex
using the ArmourPlate Virus Scanning Service. To find out
how to protect your company visit http://www.armourplate.com 
or call Corpex on +44 (0)207 430 8000.