...
This community-developed plugin is provided by LegSem (www.legsem.com) and is available through the PDI Marketplace. It uses the JDK to compile a client library for parsing your specific COBOL Copybook file. After you install the plugin you should copy tools.jar (from JDK_HOME/lib) into the data-integration/lib directory where you have Pentaho installed.
1. To install the plugin, launch Sppon and go to the menu Help -> Marketplace
2. Search for z/os and you should see the LegStar z/OS File reader Plugin
...
The sample data needed for this guide is
File Name | Content |
|---|
...
Data.zip | Contains a COBOL copybook file |
...
and Mainframe file in EBCDIC format |
Step-by-Step Instructions
...
9. Configure HDFS Content. On the Content tab, make the following settings:
- Choose a separator character of semicolon ;
- Uncheck and change the format to Unix.
10. Configure HDFS Fields. On the Fields tab, select the Get Fields button to read in all of the fields that are created by the previous step. For every numeric field, you need to change the format to #.# to make sure that there are no extra spaces written to HDFS.
...
In this task you will create a Mapper Transformation that will parse the Mainframe file into a structured format, and pivot each transaction into its own row.
1. Choose Choose File -> New -> Transformation from the menu.
...