- This topic has 7 replies, 1 voice, and was last updated 9 years, 3 months ago by
.
-
Posts
-
-
Dear All,
I am new to biztalk application development. My project is EDI automation like convert tempaltes like xls, doc, xml, txt into our database. Please help me to how to start EDI automation related Biztalk Studies. I searched google and found some links. Please any body guide me to where i have to start…and give some good links related to EDI conversion schemas please..
I am expecting your reply.
Thanks and Regards
RAM
-
Hi Ram,
BizTalk and EDI are two different subjects to learn and master, each with its own domain of difficulty and complexity.
I would suggest that you start with BizTalk, then, once you have a good basic knowledge of that, move on to EDI.
I suggest that you go to this website for BizTalk training:
http://www.biztalk-training.com/news.php
They have good tutorials on BizTalk 2006 and they charge a reasonable fee for online learning.
As for EDI knowledge, here are a few links that you can read through to gain more understanding, the first two are from MSDN dealing with EDI Interface Developer Tutorial and EDI Solution Architecture, and the last two are blogs dealing with the concepts of Party resolution and Role links:
http://msdn.microsoft.com/en-us/library/bb226541(BTS.10).aspx
http://msdn.microsoft.com/en-us/library/bb246106(BTS.10).aspx
http://blog.biztalk-info.com/archive/2006/10/25/BizTalk_Role_Links_explained.aspx
One piece of advice with regards to BizTalk training: over the course of your training, you should always try to apply the knowledge that you have gained, by doing coding in BizTalk (orchestrations, maps, schemas, port settings, pipelines, XLANGs, XPath, etc.), as I found out that was the best way of understanding how BizTalk works and its numerous intricacies, and retaining the knowledge.
Best of luck!
Daniel.
-
Hi Daniel,
Many thanx for your reply. My task is convert MTML, XLS, DOC type orders into Our application. already Is there any procedure related to Marine domain , shipping domain EDI conversion document. Please help me to proceed.
Again thanks a lot for your reply.
Regards
Ram
-
Hi Ram,
Check out this thread on BizTalkgurus, dealing with Excel tie-in to BAM portal:
http://www.biztalkgurus.com/forums/p/9849/19509.aspx#19509
As far as shipping domain EDI, you must be referring to EDI 850 purchase order specification? I don’t have experience in that regard, as I work in the health care field, but you might want to go through the tutorials that come with BizTalk 2006, as they will walk you through some scenarios dealing with purchase orders.
I hope this information will help you proceed.
Daniel.
-
Hi Daniel,
With your reference help i am reading some links. I need some help to convert xml file to our orcale database tables. I explain our process
we have receive xml file from customer then convert in to our oracle quotation tables. I am explain my understaing here
1.I have created input port folder (for test purpose)
2. Created Schema for xml templete (customer)
3. Created Orchestration input port (my input dir)
4. If i Map , how can i map xml to orcale DB
I need some clarification : How can i process my receive xml from oracle table. Please help me to proceed.
Many thanks for your help.
Regards
Ram
-
Hi Ram,
Assuming that you are on BizTalk Server 2006, use the BizTalk Adapter for Oracle DB, that comes with the suite of BizTalk Line of Business Adapters in version 2006. Using that adapter, you should be able to generate your XML schema from the Oracle DB table that you are targeting in your map.
Hope this clarifies the process for you.
Daniel.
-
Hi Daniel,
Thanx. Before I go to oracle, I have tried get the xml input and store/update my SQL server database records. but could not able to do.
please help me to send sample steps or procedures to save my xml elements in to sql db. Your domain samples also ok . I tried google also but i can’t
sucess. Please show the step by step procedure to update/fetch sql db site.. one or two fields samples is enough. Again please send sample. I am
using Biztalk Server 2006 R2. I am expecting your reply.
Regards
Ram
-
Hi Ram,
Here are the steps that you would do to generate an XML schema in BizTalk from a Stored Procedure in SQL Server that fetches data (SELECT statement):
1) Your stored procedure would contain a SELECT statement like this: SELECT Field1 FROM Table1 FOR XML RAW, XMLDATA
Pay attention to the use of predicate FOR XML RAW, XMLDATA as this is important that it be there in order for you to successfully generate the XML schema
2) Go to your BizTalk project, and run the SQL Adapter Wizard from the option Add Generated Items -> Add Adapter Metadata, point to the targeted database server/database in Data Link Properties window, fill in the Schema information, and pick the stored procedure as the Statement Type information.
3) Once your schema is successfully generated by the wizard, you can modify your stored procedure to comment the XMLDATA part of your SELECT statement, before you are ready to this SP from BizTalk.
If you follow these steps, you should be able to generate your schema, use it in a map or orchestration and deploy your BizTalk project.
Good luck!
Daniel.
-
-
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.