I am just learning Biztalk. My goal is to take an IDOC
document from SAP and load it into SQL Server 2000. We
didn't buy any custom adapters but we do own whatever
Biztalk by default gives.

Can somebody give me some guidelines how to start this
project?

Any help will be appreciated.

Thanks

[ Post a follow-up to this message ]

MS has released a BTS2004 adapter for mySAP Business Suite that includes
IDocs. Having worked with SAP systems in past integrations I would really
recommend looking at this rather than developing your own.

http://www.microsoft.com/downloads/...&DisplayLang=en

--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/


"Poonam" <poonam_yadav@adaptec.com> wrote in message
news:5acb01c491e5$f1d198c0$a501280a@phx.gbl...
>I am just learning Biztalk. My goal is to take an IDOC
> document from SAP and load it into SQL Server 2000. We
> didn't buy any custom adapters but we do own whatever
> Biztalk by default gives.
>
> Can somebody give me some guidelines how to start this
> project?
>
> Any help will be appreciated.
>
> Thanks

[ Post a follow-up to this message ]

Hello,

>I am just learning Biztalk. My goal is to take an IDOC
>document from SAP and load it into SQL Server 2000. We
>didn't buy any custom adapters but we do own whatever
>Biztalk by default gives.
>
>Can somebody give me some guidelines how to start this
>project?

As far as the SQL part is concerned, the out of the box SQL adapter may suit
 your needs. Look for "SQL adapter"
in the documentation.

As far as getting the document out of SAP, you could write all the BizTalk a
rtificats to communicate with SAP yourself and pull the data.
This may be challenging and you will duplicate work that others did before. 
IMHO, you should investigate available SAP adapters:
Microsoft (and others) sell adapters for SAP. Ifnormation for the Microsoft 
adapter are here:

http://www.microsoft.com/biztalk/ev...dapters/sap.asp

In general, using an adapter can dramatically reduce your development time. 
However, these adapters are not free and buying
extra software might not be an option in your situation. I suggest you try t
o install a demo version of some adapters to get a feel of how complex
the solution would be with an adapter or without.

If you decide that you want to go with BizTalk alone, then you will need to 
understand how to communicate with SAP to get the data.
If this happens to match one of the out of the box protocols of BizTalk (FIL
E, FTP, SOAP, HTTP MSMQ) then you should not have too many problems.
You may need to create a custom pipeline to format the data as appropriate.

If communicating to SAP involves some proprietary protocol, then you will ah
ve to write an adapter for SAP yourself.

Thanks,
-Gilles.

[ Post a follow-up to this message ]