How to map data from other languages to java

Question

We have to store data from some flat files that is created using IBM's Ab-Initio product. They have their own datatypes that I need to map to java data-types while I process that data in java.

Does anyone know what would a good technique to do so ? Are their any java APIs to do so ?

simplest technique I have in mind is to create a map of Ab-Initio to Java type after checking the size in Ab-Initio and choosing datatype that represents that size and type in Java.

Any inputs are appreciated !

Thanks, -JJ

Is there a way to convert the Ab-Inito files to a .csv format? — David Weiser, Mar 17 '11 at 17:38
Not sure how many people will know Ab-Initio, maybe if there is a way to rephrase the question on concrete data more people may help — Jan Zyka, Mar 17 '11 at 17:40

maerics · Accepted Answer · 2011-03-17T17:48:57.033

1

When converting data between various languages I like to stick to a couple basic data structures which seem to be able to handle any type of data:

Primitives - for storing basic values like strings and numbers.
Maps - for associating properties with values for an object.
Lists - for storing sequences of primitives and objects.

Of course, in Java, it's canonical to create an object with bean properties instead of a Map when the full domain of attributes is known.

edited Mar 17 '11 at 17:48

answered Mar 17 '11 at 17:43

maerics

151,642
46
269
291

My question was more like, if say you have : namevarchar20, you will make name a string java. So, how we create this mapping program. Should we make a mapping list that if input is varchar, create java type string. if input is float, make java type float etc. And then use this mapping to create java types from a fixed lenth line ? – user656189 Mar 17 '11 at 20:44

score 0 · Answer 2 · answered Oct 07 '12 at 20:18

In most ab-inito processes, just before a flat file is written, some transformation is performed on the data, even if there in no transformation performed, before writing to the file, or a step before the step that writes to the file, an intermediate DML is present which contains the data definitions for each columns, most of these are generic definitions, all you need to do is ask the ab-initio developer to send you a copy of that generic dml, and then you can you this DML to map values in java. Hope this helps.

How to map data from other languages to java

2 Answers2