How to read multiple JSON files with different structures and load data into Oracle?

etltnandini — Tue, 22 Jul 2025 14:06:28 GMT

Hello Friends,

I'm new to Talend.

How to read multiple JSON files with different structures and load data into Oracle? I need to build a single Talend reusable job where it reads(iterates) multiple JSON files with different structures and loads the data into Oracle.

Please help with any sample job designs or any info.

Thank you

Nandu

Re: How to read multiple JSON files with different structures and load data into Oracle?

Lusemar_Oliveira — Tue, 22 Jul 2025 15:44:04 GMT

Hi etltnandini,

Have you had a chance to look into the following documentation?

https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2025-06/reading-from-multiple-files

https://community.qlik.com/t5/Talend-Studio/Read-and-write-multiple-JSON-files-with-different-structure/td-p/2469263

https://community.qlik.com/t5/Talend-Studio/How-to-read-multiple-json-objects-which-is-not-an-json-array-in/m-p/2363171

https://community.qlik.com/t5/Talend-Studio/tFileInputJSON-access-iterating-key-value/td-p/2300612

https://help.qlik.com/talend/en-US/components/8.0/json/tfileinputjson

It may help you.

Good Luck!

topic How to read multiple JSON files with different structures and load data into Oracle? in Talend Studio

How to read multiple JSON files with different structures and load data into Oracle?

Re: How to read multiple JSON files with different structures and load data into Oracle?