I am Muhammad Hamid Munir Solution Architect from ELOG AB Sweden. We are working on a project and The major requirements that we need are described here below.

•    Code to code mapping
Explanation: Conversion from input code to ouput code wherein the lookup tables / expressions / functions will be used.
Example: Conversion of the Company code to Country code using the delivered lookup tables

•    Support of lookup tables, especially the following parts of the lookup tables are important
o    the format of the lookup tables will be CSV, Text, EDI and standard databases
o    It needs to support Browse-in functionality
o    Need functions to use the lookup tables
o    Needs expressions, constants and variables to use the lookup tables
o    It will be located inside the application machine. This is build using the JBoss suite.

•    Conversion of the ISO 8859-1 to UTF-8

•    Need library functions (mathematic functions, string functions , aggregate functions, logical functions, node functions) to support the mappings

•    Need the datatype conversion functions to support the mappings
Explanation: It should convert numeric to alpha-numeric and vice versa, date time conversion functions with time zones offset, string conversion functions, string to numeric functions
Example: YYYYMMDDhhmmss to YYYY-MM-DDThh:mm:ssTZD (TZD is the Time zone offset)

•    Need to map 1 to many and many to 1 with using lookup tables, expressions and functions
Example: concatenation functions, split functions, compare functions and  etc.

•    The mapping tool must support the CRUD functionality

•    The mapping tools should also support constants and variables

•    The output of the mapping schema must be in XSLT format

•    At the end the mapping schema format must be stored in the database.



The questions that we have are:
•    Is it at all possible to add the output in JBOSS ESB.
 

In case you need more clarity on these requirements.

I look forward to hear from you.


Thank you kindly in advance.


Kind regards,

Muhammad Hamid Munir
Solution Architect
ELOG AB