| Author |
Message
|
| Michael Dag |
 Posted: Tue Feb 24, 2004 3:22 am Post subject: NEON to MRM (TDS) Migration/Converter |
 |
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
I must not be the first one with this idea...
I know IBM have migration services, but never heard any experiences
SO...
I thought of writing a NEON to MRM (TDS) migration tool.
I did some preliminary work and think it should be possible!
Functionality I can think of:
- interpret existing NEON input formats from the export files
- reverse engineer input formats to readable and understandable documents
- validate what type of input (fixed length, tagged data, etc)
- interpret existing NEON output formats and show mapping in readable documents
- generate 'skeleton' message sets and accompanying ESQL code to generate output messages
THIS WILL NOT BE A FREEBIE!!! 
What I am looking for is:
Are you interested in buying this tool (what would it be worth to your company)
Are you interested in migration service (send me your input/output formats, the tool converts and tests and you get the stuff back at a fee)
Anything else I can't think up right now...
Needless to say, no response or interest and I will not proceed as I have lots of other things to do...
If someone already started doing this, let me know...
Michael |
|
| Back to top |
|
 |
| Missam |
| Posted: Tue Feb 24, 2004 8:17 am Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
| Can Your Tool deal with optional and repeating elements in formatter and convert into TDS message set. |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Tue Feb 24, 2004 10:08 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
The tool does not exist today, so it can't
Optional and or repeting elements would qualify into the "medium" complex area of conversion and is certainly my tartget.
I think most NEON interfaces are relatively simple to convert, but the sheer amount of work to be done is holding conversion up.
Then there is the medium category where also even more work needs to be done, but if TDS can handle it (never pushed the TDS limits...) why not.
Lastly there is the "wacky" interface category within NEON wherein even NEON limits are pushed, I doubt wheter those can even be handled by TDS today.
Michael |
|
| Back to top |
|
|
| kspranava |
| Posted: Wed Feb 25, 2004 1:04 am Post subject: I have a done a part of it already |
|
|
Centurion
Joined: 27 Apr 2003
Posts: 124
|
Hi,
I have a done a part of it already, though not exact one. Also interested in proceeding further.
My tool has two parts,
1) Reads input from a text file which has literal names and literal values seperated by a delimiter. Then creates a file which will look similar to *.nnfie file, so that it can be imported in to the database. In this case, creation of 1000s of literals were made easy as compared to creating one by one using NEON Formatter GUI.
2) It has a GUI, where in user needs to input data such as name of i/p format, i/p control, fields, literals, etc, all in a single page. Then on click of a single button, a file similar to *.nnfie file will be created with all the elements created. Again, same can be imported in to a database( A Point to remember, this is not applicable for very complex compound formats).
Reason why am stating this is, reverse engineering or understanding the relationship is not very difficult by interpreting a *.nnfie file.
So, i think reverse engineering part can be done. Since we know all the elements with their relationship to each others, it should not be a problem to generate ESQL code to get the desired output message. Again, we are left with two options, either we can generate a XML similar to *.mrp file (in case, message set is needed) or ESQL (to embed in a compute node).
Ofcourse, I know, in practical it may not be as easy as it sounds.
I welcome any inputs on this.
Pranava. |
|
| Back to top |
|
|
| HugoB |
| Posted: Fri Feb 27, 2004 2:28 am Post subject: |
|
|
Acolyte
Joined: 26 Jun 2001
Posts: 67
|
Well we wrote something to handle SWIFT messages.
Without using NEON, so pure MRM/ESQL based.
It´s even more future proof then the NEON solution.
Since it is rather simple to modify the ESQL code if
there is a new SWIFT release.
And yes we have a customer being verry happy about it.
http://www.virtualsciences.nl/
But then again, just only SWIFT and therefore not a real migration tool. |
|
| Back to top |
|
|
| kspranava |
| Posted: Sun Feb 29, 2004 11:33 pm Post subject: English Version |
|
|
Centurion
Joined: 27 Apr 2003
Posts: 124
|
Hi KlassBaas,
Can I get an English version of the document ?
Pranava. |
|
| Back to top |
|
|
| HugoB |
| Posted: Mon Mar 01, 2004 2:11 am Post subject: |
|
|
Acolyte
Joined: 26 Jun 2001
Posts: 67
|
kspranava,
An english translation, yes that would be practical.
But we offer it for the dutch market, but then again.
I would like to visit KL again, it has been a while since I´ve
been there. I worked then for Astro in Malysia, actually in KL.
The satellite business that is.
But the info (in dutch) is more or less an advert for a product we sell.
The product is able to convert SWIFT (also 2003 release) to some XML.
We can rather flexibel change the layout of the XML, like the tagnames etc. And we can do the opposite, that is XML IN and SWIFT OUT.
It´s all based on native WMQI 2.1 (also WBI 5 compatible).
It uses the MRM and flows with ESQL code in compute nodes.
So no need for NEON, thus no license needed.
After some little rework, it´s easy adapted to a new SWIFT release.
Hope this helps you a bit ! |
|
| Back to top |
|
|
| kspranava |
| Posted: Thu Mar 04, 2004 11:00 pm Post subject: Interesting... |
|
|
Centurion
Joined: 27 Apr 2003
Posts: 124
|
KlassBass,
Its interesting to know that u had been in KL. Yeah, I know ASTRO very well since they are the cable tv operators/providers here.
And Thanks for the info on the tool.
Pranava. |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Mon Mar 08, 2004 9:27 am Post subject: Re: NEON to MRM (TDS) Migration/Converter |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
| MichaelDag wrote: |
I thought of writing a NEON to MRM (TDS) migration tool.
I did some preliminary work and think it should be possible!
Functionality I can think of:
1. interpret existing NEON input formats from the export files
2. reverse engineer input formats to readable and understandable documents
3. validate what type of input (fixed length, tagged data, etc)
4. interpret existing NEON output formats and show mapping in readable documents
5. generate 'skeleton' message sets and accompanying ESQL code to generate output messages
THIS WILL NOT BE A FREEBIE!!!
|
Rough work 1 to 4 are done, polishing to required output format (i.e. Word document) will be optional
Let's say it was a very educational exercise ...
So if you are stuck with a lot of 'undocumented' NEON formats or MQSI 1.x formats ... you know where to find me.
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| HugoB |
| Posted: Tue Mar 09, 2004 2:00 am Post subject: |
|
|
Acolyte
Joined: 26 Jun 2001
Posts: 67
|
Most interesting.
And now the hard part I think.
Maybe the MRM is too limited to handle it all.
Keep us posted. |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Tue Feb 22, 2005 9:11 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
Got some time on my hands so thought I'd give this one a bump...
Anyone out there wondering what their NEON/NNSY formats are all about?
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| HugoB |
| Posted: Tue Feb 22, 2005 11:28 am Post subject: |
|
|
Acolyte
Joined: 26 Jun 2001
Posts: 67
|
Oh bugger.
Spend already a few weeks on a tool called BizTracker.
Which was from NEON.
God, it's terrible. It's realy houtje touwtje sopware 
I hope they throw it away, otherwise i will never fly again. |
|
| Back to top |
|
|
| dfdyer |
| Posted: Tue Jan 13, 2009 12:53 pm Post subject: Was this tool ever developed? |
|
|
Newbie
Joined: 13 Jan 2009
Posts: 1
|
I found this link via a Google search - it describes something we are looking to do. The initial work seems like ancient history, but wondering if this was ever successful and/or what the final result was.
DD |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Tue Jan 13, 2009 1:49 pm Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
well... NEON err I should say New Era of Networks... sounds like history to me... 
I found the original files dating back to 2004 and have no clue wether it would work on current NNSY formats.
roughly the transformer can 'spit' out a more readable document you can use as input for any further manual mapping.
how many formats need to be converted???
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
|
|
