EDI file as input and output

Saha · Post by **Saha** » Mon Dec 16, 2013 5:36 am

Hi , is there any stages/plug-in to read/generate EDI files using datastage?
Thanks!!

eostic · Post by **eostic** » Mon Dec 16, 2013 6:20 am

This is probably a good candidate for moving over to the regular PX/EE forum.

...a lot depends on what "kind" of EDI we're talking about. Legacy EDI, like SWIFT and EDI X12 or other standards, are best handled by tooling such as WebSphere TX, which comes with built in metadata mappings (called Type Trees) as part of their subscription. At one time there was a MapStage, which supports communication between WebSphere TX and DataStage, but it doesn't exist anymore, as the two can be connected via Java Integration Stage if necessary. If using the newer formats that are largely xml, TX is still a good choice because many of the mappings are already built for the standard, but the xml Stage in DataStage is capable of reading and writing.

Choosing one vs the other will depend on many factors, such as the available skill sets, the numbers of such interfaces you need to build, the nature of the targets (is this source EDI and target EDI, or source EDI to data warehouse, or data warehouse to EDI, etc.), the performance you need, the transactionality you need, etc.

Ernie

chulett · Post by **chulett** » Mon Dec 16, 2013 7:48 am

Moved.

Saha · Post by **Saha** » Thu Jan 02, 2014 12:13 am

eostic wrote:a lot depends on what "kind" of EDI we're talking about.

It is EDI X12.......to be specific EDI 864 and 867 are under my focus...
Thanks !!

eostic · Post by **eostic** » Thu Jan 02, 2014 11:19 am

Take a look at WebSphere TX....it's pre-built Type Trees may fit your requirement.

Ernie