Five Stars

Reading Mainframe File

Team, Team, I have a requirement to read the mainframe files in Talend, basically these files will be in non readable format(EBCIDIC format). The mainframe files and the respective copybooks are available, please let me know how can i read the data and process them further. Thanks in advance.
6 REPLIES
Community Manager

Re: Reading Mainframe File

Hi
You can try tFileInputEBCDIC component on Talend exchange:
https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

Here is a KB article about how to install a custom component.
https://help.talend.com/reader/Jkvp187bw8jcmAsfn~skJQ/MUwk3e4kaqATWxjH~quy9A

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: Reading Mainframe File

Team, The EBCDIC components have been deprecated several version ago to be replaced by Talend Data Mapper. Currently we are using Talend Big Data Platform 6.2.1. So i need help on the below items, 1) Read the COBOL copybook and generate the structures. 2) Using the structure generated, how to read the mainframe file. I'm not sure if the above steps are right, correct me if we have an alternate approach. If you could explain this entire process using a example it would be highly helpful for our team.
Employee

Re: Reading Mainframe File

You need to use TDM.  We have a Cobol Lab in our TDM training.  It is a good way to get started.  It has a ramping up curve.  You may need 2 - 3 days just to get familiar with TDM, go through the training, and then do your use-case.

 

Generally, you need to create all the structures you need in TDM.  It depends on your copybook structure.  And if it is a hierarchy of structures, you may need to build that first, then build a master structure in TDM.  Then map the elements to your target.  

Four Stars

Re: Reading Mainframe File

Can you give me a link where the solution is explained.


iburtally wrote:

You need to use TDM.  We have a Cobol Lab in our TDM training.  It is a good way to get started.  It has a ramping up curve.  You may need 2 - 3 days just to get familiar with TDM, go through the training, and then do your use-case.

 

Generally, you need to create all the structures you need in TDM.  It depends on your copybook structure.  And if it is a hierarchy of structures, you may need to build that first, then build a master structure in TDM.  Then map the elements to your target.  


 

Employee

Re: Reading Mainframe File

TDM is not opensource.  You only get it with the Platform products.  And this is explained in the TDM training.

Six Stars

Re: Reading Mainframe File

Here's a link to the Mapper documentation: there is a section devoted to processing COBOL files that might help:

 

http://doc.talend.com/enterprise/talend_data_mapper/3.3/

 

I agree that there is a learning curve with this tool: if you decide it's worth investing in, be sure to read the documentation carefully before you start writing the job. That said, it's a very powerful tool once you learn how to use it (I have to process EDI records, which may even be worse than COBOL in my experience).

 

Good luck,

 

David