ETL Tools for EDI to DB Import

21 Oct 2005 1:45 PM

Joseph George

Hello,

We're trying to come up with a solution for loading large EDI (X12)
batch files into a SQL Server 2005 system.

We tried using Altova Mapforce which now has a code generation feature
which can be compiled and run, but it does not seem to scale well for
large data loads.

Any one have any other suggestions for tools to help import large EDI
X12 flat files with really complex data structures?

Thanks,
JGP

21 Oct 2005 3:29 PM

JT

I'm not familiar witht he X12 data format but:
Perhaps the most scalable and performant solution would be to extract and
transform the X12 data to flat (tab delimited) text files that match the
structure of the SQL Server 2005 tables. This could be done on a staging
server or local workstation. Once done, load the data into SQL Server using
DTS or the bulk copy (BCP.EXE) program.

Show quote

"Joseph George" <josep***@gmail.com> wrote in message
news:1129902346.725796.33710@g44g2000cwa.googlegroups.com...
> Hello,
>
> We're trying to come up with a solution for loading large EDI (X12)
> batch files into a SQL Server 2005 system.
>
> We tried using Altova Mapforce which now has a code generation feature
> which can be compiled and run, but it does not seem to scale well for
> large data loads.
>
> Any one have any other suggestions for tools to help import large EDI
> X12 flat files with really complex data structures?
>
> Thanks,
> JGP
>