Skip to Main Content

SQL & PL/SQL

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: Processing .json file in to oracle table

user9977206Dec 27 2020

Hi,
I'm trying to load a JSON file into an Oracle table using ODI12c.
I created the data server in Complex file technology,as the documentation, I'm able to generate the XSD files successfully.I created the physical schema,it gets the xsd schema .I'm able to reverse the file I see the root element and content column in the model . I'm not able to see the data in the reversed XSD file.
Not Sure What I missed, how to see the data to create the mapping to populate the Oracle table. Any inputs are appreciated.

Thanks,
Ravi

Comments
Post Details
Added on Dec 27 2020
1 comment
1,119 views