Loading complex XML file into MySQL tables

One Star

Loading complex XML file into MySQL tables

Hi,
I am very new to Talend and I am trying to parse a complex XML file and load into multiple MySQL tables.
here is a snippet of the file that I am trying to load.
<?xml version="1.0" encoding="UTF-8"?>
-<hasMember>

    -<OrganisationAuthority gml:id="OrganisationAuthority1" xmlns="">
         <identifier xmlns="" codeSpace="">d34e4849-77d1-4b77-a5cd-8d3cec72a451
         </identifier>
-<timeSlice>
   -<OrganisationAuthorityTimeSlice gml:id="OrganisationAuthority1_TS1">
 -<validTime xmlns="">
    -<TimePeriod ns:id="OrganisationAuthority1_TS1_TP1" xmlns:ns="">    
        <beginPosition>2013-01-10T09:01:00Z  
         </beginPosition>   
         <endPosition indeterminatePosition="unknown"/>
   </TimePeriod>
</validTime>
   <interpretation>BASELINE</interpretation>
   <sequenceNumber>1</sequenceNumber>
   <correctionNumber>0</correctionNumber>
-<featureLifetime>
  -<TimePeriod ns:id="OrganisationAuthority1_TP1" xmlns="" xmlns:ns="">
    <beginPosition>2013-01-10T09:01:00Z
    </beginPosition>
    <endPosition indeterminatePosition="unknown"/>
  </TimePeriod>
  </featureLifetime>
  <name>R-2508 COMPLEX CONTROL BOARD</name>
  <designator>R2508CCB</designator>
  <type>OTHER</type>
  </OrganisationAuthorityTimeSlice>
  </timeSlice>
  </OrganisationAuthority>
</hasMember>
-<hasMember>
-<OrganisationAuthority gml:id="OrganisationAuthority2" xmlns="">
<identifier xmlns="" codeSpace="">D0598777-DFB5-7019-E044-00144F1E5345
</identifier>
-<timeSlice>
-<OrganisationAuthorityTimeSlice gml:id="OrganisationAuthority2_TS1">
-<validTime xmlns="">
-<TimePeriod ns:id="OrganisationAuthority2_TS1_TP1" xmlns:ns="">
      <beginPosition>2012-11-15T09:01:00Z
      </beginPosition>
      <endPosition indeterminatePosition="unknown"/>
      </TimePeriod>
   </validTime>
<interpretation>BASELINE</interpretation>
<sequenceNumber>1</sequenceNumber>
<correctionNumber>0</correctionNumber>
-<featureLifetime>
-<TimePeriod ns:id="OrganisationAuthority2_TP1" xmlns="" xmlns:ns="">
   <beginPosition>2012-11-15T09:01:00Z
   </beginPosition>
   <
endPosition indeterminatePosition="unknown"/>
</TimePeriod>
</featureLifetime>
<name>FEDERAL AVIATION ADMINISTRATION</name>
<designator>FAA</designator>
<type>NTL_AUTH</type>
</OrganisationAuthorityTimeSlice>
</timeSlice>
</OrganisationAuthority>
</hasMember>
I would like to insert the data into two tables; parent_table and parent_time_slice table,. can someone point me in the right direction?
thanks
Rajani
One Star

Re: Loading complex XML file into MySQL tables

I am sorry, I didn't realize that I posted this question under the wrong topic. Please let me know if I should repost the question under a different thread.
thanks
Rajani

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now