Talend ETL | Read XML and Load Oracle Table
Talend XML into Table
1. Make connection directory
2. Source - Create EMP.XML with employee details
3. Source - Create XML file connection under metadata
4. Target - Create T_EMP table with oracle database/HR schema
5. Job Design - Create a job using
1. dbFileInputXML component to read path query/field info
2. tLogRow - to display result info/trap error incase job flow runs smooth.
3. dbDBOutput component to write into target T_EMP table.
6. Run the job - Read/Write