How to migrate VSAM tables with EBCDIC format to MySQL

One Star

How to migrate VSAM tables with EBCDIC format to MySQL

Hello togehter,
I have to export VSAM data (in EBCDIC format)  to an MySQL DB by "TOS for Data Integration". As I researched online I found within Talend componets (connectors) two componets that may solve my problem:
# tExtractEBCDICFields
# tFileInputEBCDIC
My quesions:
1) does "TOS for Data Integration" generally support such data export/conversion to another system (readable for user)?
2) If not, do I need Talend Enterprise Edition for implementation of my project?
Any help would be appreciated.
Regards,
Wahid
Seventeen Stars

Re: How to migrate VSAM tables with EBCDIC format to MySQL

VSAM data are not in EBCDIC. You are mixing up 2 completely different formats.
VSAM is a host related file format and EBCDIC is another host related file format.
You can write Cobol jobs transferring the VSAM data into a EBCDIC file and EBCDIC files can be read in Talend with tFileInputEBCDIC (and by the help of the metadata wizard to get the structures and you need the copybook file for the EBCDIC file to know the structure).
One Star

Re: How to migrate VSAM tables with EBCDIC format to MySQL

Hello Jan,
Thank you very much for explanation. I will post the result here.
Kindest regards,
Wahid
One Star

Re: How to migrate VSAM tables with EBCDIC format to MySQL

Hello again,
I tried to open and convert a dummy file (in EBCDIC-format) once to ascii text also to an MySQL database based on the description of talend manual. The TOS version I used  for this sample is a TOS trial version for data integration (5.6.0). While those attemts I learnt that no copybook is a part of metadata to corresponde to EBCDIC file. I don't know why it's missing. Probably a license issue? Is copybook generally a part of TOS full licensed?
For configuration of "tExtractEBCDICFields" a copybook is necessary. How may I qualify my job for this step because of missing copybook?
Thank you for any clue.
Regards
Seventeen Stars

Re: How to migrate VSAM tables with EBCDIC format to MySQL

The copybook file is a file what the "source" must provide. It will be created in/for the same process which generates the EBCDIC file.
You need the copybook file to create the necessary metadata for the Talend component (xc2j file and the schema).
Unfortunately I do not know how to build the xc2j-file because I work usually with the enterprise edition of Talend and here we can use a wizard to build all necessary metadata.
Therefore please ask your partner which provides the EBCDIC file also to provide the copybook file. 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download