| Gilles [MSFT] 2004-09-03, 5:49 pm |
| 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 artificats 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 to 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 (FILE, 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 ahve to write an adapter for SAP yourself.
Thanks,
-Gilles.
|