Field Mappings (Not Database fields)
-
Hi all, I have been pondering over possible solutions for replacement of a legacy application with .NET (2.0) The current app handles message transmision and format conversion for the finacial industry and the part of the design that I struggle with is as follows An incomming message (pure Text over IP or X25) will have a series of fields to hold counterparty, amounts deal dates etc and will be formatted something like this 52A: Counterparty : Bank code 36R: Payment : 300000000USD 40: Deal Date : 070101 The field numbers etc are not correct, it serves purely as an example The system would then be required to forward this recieved message on to one or more different systems with in the organisation, each of which may require the data to be in a different format and require differing transport methods, For example, delivery to a table in a database or simply a text file across the network Here is the main question, if these systems require different formats (or field names within a database table), I would like to devise a method of field mapping so each output format would not require any hard coding. Is anybody able to provide suggestions for suitable technology to achieve this mapping? Many thanks Paul please please ignore bad spelling (I do as you can most likely tell)
-
Hi all, I have been pondering over possible solutions for replacement of a legacy application with .NET (2.0) The current app handles message transmision and format conversion for the finacial industry and the part of the design that I struggle with is as follows An incomming message (pure Text over IP or X25) will have a series of fields to hold counterparty, amounts deal dates etc and will be formatted something like this 52A: Counterparty : Bank code 36R: Payment : 300000000USD 40: Deal Date : 070101 The field numbers etc are not correct, it serves purely as an example The system would then be required to forward this recieved message on to one or more different systems with in the organisation, each of which may require the data to be in a different format and require differing transport methods, For example, delivery to a table in a database or simply a text file across the network Here is the main question, if these systems require different formats (or field names within a database table), I would like to devise a method of field mapping so each output format would not require any hard coding. Is anybody able to provide suggestions for suitable technology to achieve this mapping? Many thanks Paul please please ignore bad spelling (I do as you can most likely tell)
I would look at BizTalk for this if I were you. It sounds like an ideal problem for BizTalk.
Deja View - the feeling that you've seen this post before.