Whats the best way to get a flat file from an EDI system
into SQL using BizTalk??

[ Post a follow-up to this message ]

That depends on a lot of things, but the generic answer is:
A) If you inbound EDI document is complex, map from the complex schema to a
simplified schema that holds the data in a manner very similar to how it
will be stored in the database.
B) annotate your simplified schema for the SQL Connector to use.
C) Use the Biztalk SQL Connector and SQL XML to store the data in a
database.

--- Nick

"Gary" <gary.turvey@poupart.co.uk> wrote in message
news:6be701c401de$45ff4020$a001280a@phx.gbl...
> Whats the best way to get a flat file from an EDI system
> into SQL using BizTalk??

[ Post a follow-up to this message ]

Thank you very much

Gary

>-----Original Message-----
>That depends on a lot of things, but the generic answer
is:
>A) If you inbound EDI document is complex, map from the
complex schema to a
>simplified schema that holds the data in a manner very
similar to how it
>will be stored in the database.
>B) annotate your simplified schema for the SQL Connector
to use.
>C) Use the Biztalk SQL Connector and SQL XML to store
the data in a
>database.
>
>--- Nick
>
>"Gary" <gary.turvey@poupart.co.uk> wrote in message
>news:6be701c401de$45ff4020$a001280a@phx.gbl... 
system 
>
>
>.
>

[ Post a follow-up to this message ]