|
Home > Archive > BizTalk Server General > March 2004 > Flat File - SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Whats the best way to get a flat file from an EDI system
into SQL using BizTalk??
| |
| Nick Malik 2004-03-05, 4:34 am |
| 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??
| |
|
| 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[color=darkred]
>
>
>.
>
|
|
|
|
|