convert SWIFT message to XML file (or) flat file

kkumardatastage · Post by **kkumardatastage** » Fri Aug 08, 2008 12:04 pm

hi
please can any one help me.
i got a task to convert a SWIFT message and this SWIFT message should be convert into the flat file (or) XML file. this XML file (or) flat file i got to use it in datastage parallel for my job.
the SWIFT message, we'd like to reformat it to a pipe delimited file too.
The end result should be a pipe delimited file with column heading (use each tag for now).
The value for each row,:
Repeat the values in {1:} and {2},
Repeat values for all tags except tag :61:.
The only difference in each row is the value in tag :61:
It's ":<tag>:<value >". The tags for each kind of message are SWIFT standard

the SWIFT message look like
for ex:

{1:F01BOFAUSNYJXXX4321000123}{2:I103BANKDEFFAXXXN2 020}{3:{103:CAD}}{4:
:20:NY20040126000111
:23B:CRED
:32A:040116USD1000000,00
:50K:/987654321
Big Deal Real Estate
Madison Avenue
New York, NY USA
:57A:/654321
NOSCATTT
:59:/1234567890123
I. Buy Buildings
200 Front Street
Toronto, Ontario
Canada
:70:re real estate purchase
10000 King Street East
Toronto
:71A:OUR
-}{5:{MAC:23456789}{PAC:23456789}{CHK:123456789012} {SYS:1231313}{TNG:}{PDE:12345}{DLM:}}

thanks

eostic · Post by **eostic** » Fri Aug 08, 2008 12:20 pm

...consider employing MapStage, which uses TX to do the SWIFT reading, putting the SWIFT into columns that are more easily consumed by DataStage. TX comes "out of the box" with SWIFT meta data maintained and kept up-to-date with the standard.

...of course, this means that you must also have a license for TX, although that license comes with some special pricing when its part of MapStage for DataStage integration.

Ernie

laknar · Post by **laknar** » Wed Aug 13, 2008 12:30 am

Is Mapstage is called as Datastage TX Job in Parallel Job processing Stage.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 13, 2008 12:39 am

laknar wrote:Is Mapstage is called as Datastage TX Job in Parallel Job processing Stage.

That's the bunny.

kkumardatastage · Post by **kkumardatastage** » Fri Aug 15, 2008 12:18 pm

pls i did't get you properly. pls can you tell me in detail. about the conversion.
thank you.

eostic · Post by **eostic** » Sat Aug 16, 2008 6:22 am

There is an IBM product offering called WebSphere TX. While part of Ascential, it was called DataStage TX and is the former Mercator product. It comes bundled with metadata to read things like SWIFT.

MapStage is the stage/utility that lets regular DataStage reach out to TX and invoke what is called a TX map, so that you can use functionality like it's SWIFT adapter to reader SWIFT sources and bring them into regular DS.

Ernie

ray.wurlod · Post by **ray.wurlod** » Sat Aug 16, 2008 5:01 pm

To be able to use MapStage you will, naturally, have to have a WebSphere TX map that it can invoke and that, in turn, means that you will have licensed (purchased) WebSphere TX.