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!

Parse JSON from column in ODI 12c

choracy69Mar 26 2019 — edited Mar 27 2019

Hi, I transform data from postgresql to oracle table with ODI 12.2.1 - next I want parse column JSON_F which contains JSON value or null. How can I parse values from this json column and insert in different table? Must I write some 'parser' in sql or can I use ODI?

Added on Mar 26 2019

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

1 comment

668 views