topic Re: EBCDIC format in Talend Studio

EBCDIC format

JaneYu — Mon, 21 May 2018 22:36:43 GMT

The client is requesting an report with EBCDIC format. Is it possible in Talend? Thank you

Re: EBCDIC format

vapukov — Mon, 21 May 2018 22:44:02 GMT

in commercial version

request from Talend more information about Talend Data Mapper.

Re: EBCDIC format

Jesperrekuh — Mon, 21 May 2018 23:02:38 GMT

Mainframe ... I suggest looking at the IBM Toolbox for Java / JTOpen is a library of Java classes supporting the client/server and internet programming models to a system running OS/400, i5/OS, or IBM i.

https://sourceforge.net/p/jt400/wiki/Home/

If you wanna go deep and do it yourself:
http://demo.icu-project.org/icu-bin/convexp?s=JAVA

Enjoy!

Re: EBCDIC format

vapukov — Tue, 22 May 2018 02:56:01 GMT

all depends from real business case (what real needs, tasks and goals).

always possible organize process for delegate parts for most relevant tools.

For example

- Mainfraims have database (which is could be DB2 in most cases), Talend support it

- Mainframes supports IBM MQ, Talend as well support it

So it possible todo in Talend what Talend can, and use DB2 or MQ as interface

Of course - possible todo all with different libraries ... but this is would be also not a Talend

Re: EBCDIC format

JaneYu — Tue, 22 May 2018 15:47:57 GMT

My data source is hadoop (hive tables). Is it possible to output a text file in EBCDIC format? Thank you

Re: EBCDIC format

Jesperrekuh — Tue, 22 May 2018 16:29:42 GMT

Yes convert encoding ( utf-8 -> CCSID1208 ), look at my first post
Or at IBM side import with the correct encoding and ask if they import at DB2 or SAS...