topic Re: integrate XML files into SQL database in Talend Studio

integrate XML files into SQL database

ali_hijazi1 — Wed, 13 Jan 2016 13:31:05 GMT

Hello
I'm new to Talend and I downloaded Open Studio for data integration
I have a folder that contains a bunch of XML files (around 120 files)
each file is related to an employee and of course all got the same structure
what i want is to read all of these files and save the data as relational data in MS SQL server

Please advise on how to accomplish this

Re: integrate XML files into SQL database

Anonymous — Sat, 30 Jan 2016 13:38:04 GMT

Hi
Use tFileList to iterate each XML file and parse it with tFileInputXML, merge all the records and load them to MS SQL server. The job looks like:
tFileList--iterate--tFileInputXML--main--tUnite--main--tMSSQLOutput

Please read the component user documentation and learn these components.