As far as I know, Biztalk can receive EDI from trading partner, look up schema, validate the edi, generate ack, PROCESS EDI , convert edi to XML. These are what I have learnd from MSDN.Currently we don't implment biztalk and what we are doing is receive product information (spreadsheet/csv file) from trading partner, process the received file by using a processor we build, store all product information in SQL Server.
I have three questions:
Our received EDI contains products information, when biztalk processes edi, how and where can we apply our business rules/needs? E.g. we can calculate our selling price based on the promotion information contained in the edi file. Another example is we can modify the product description...etc, those sort of thing.
How to store edi data in SQL Server? Is that SQL Adapter? WCF-SQL? All product informaiton will be stored in one table and what are the key steps we need to do here?
After biztalk convert edi to xml, then what can biztalk do with the converted xml? Can Biztalk process the xml and map all data into our SQL DB schema?
Thanks in advance