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

[etltnandini]

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

[Lusemar_Oliveira]

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-struct...

https://community.qlik.com/t5/Talend-Studio/How-to-read-multiple-json-objects-which-is-not-an-json-a...

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!