Support Questions
Find answers, ask questions, and share your expertise

Data ingestion from Oracle to Oracle

New Contributor

Hi experts,

We want to create a workflow from an oracle source to a oracle target table. Steps used are below.

1. ExecuteSQL processor -> selecting a single column : select carr_cd from carr_t

2. ConvertAvroToJSON

3. ConvertJSONtoSQL

4. PUTSQL --> Insert into target_t ("carr_cd") VALUES (?)

When I execute the flow, I get an error saying 'json does not have a value for the required column CARR_CD' in step 3. Is there anything that is missed out ?

Or is the steps correct, is there any other way to do this ?

Thanks !