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 - Read a JSON File and load Oracle table

User551626-OCJan 22 2020 — edited Feb 6 2020

Hello

has anyone used the 'Complex Technology' in ODI 12c to parse a JSON document and then create a mapping and load the data in a oracle table?

We have a complex JSON file, and we are unable to load any data. The mapping runs fine, but does not load any data?

If we modify the joins then partial data gets loaded, since lot of the parent/child relationship is lost.

Thanks

Added on Jan 22 2020

#business-intelligence-applications, #data-integrator, #system-management-and-integration

2 comments

6,324 views