Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI 12c Cobol Reverse engineering

Dinesh AtluriApr 15 2025

Hello Oracle Data Integrator group,

I do have a cobol source file and it's copybook which matches 100%

As it is having 95 columns, so when I am trying to do reverse engineering by following the below steps

In the Models, created new datastore and named as Source
Resource name: Sourcefile.txt

In the Files Tab,
File Format: Fixed
Heading: 0
Record Separator: Unix
Field Separator: Tab

Tried Reverse Engineer Cobol Copybook
File: Copybook.txt
Description format: EBCDIC
Data format: EBCDIC

Tried with EBCDIC option, getting the below error
ODI-23033: The file reverse-engineering is only possible for delimited files.

Tried with ASCII option, getting the below error
ODI-20741: This is not a valid Cobol Copybook.
com.sunopsis.dwg.SQLWorkReposException: ORA-00001: unique constraint (ODIPROD_ODI_REPO.AK_REV_COL) violated

ODI Client version: 12.2.1.4

Source file: FIXED WIDTH

Please share your ideas, many thanks.

Regards,

Mr Dev

Comments
Post Details
Added on Apr 15 2025
0 comments
245 views