Xml-данные в XML-тегах

---

В приведенном ниже xml-файле xml-данные содержатся под тегом xml : <bankenhanced>

Я должен извлечь данные с помощью инструмента etl informatica, но он не читает xml-теги, а читает внутренние теги как данные и сохраняет их в таблицах базы данных.

Как прочитать эти вложенные данные из xml ?

<?xml version="1.0"?>
<CallValidate><CreditApplicationID>1258412</CreditApplicationID><BankEnhanced><RawResponse><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<Results xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="C:/Users/hughc/PhpstormProjects/callvalidate/mantis-setup/Schema/5.7.0/Customer-Output-V5-7-0.xsd" APIVERSION="5.7.0 - 20150811">
  <Result RID="" PID="LTJ-OLS3-2479-15147-95584-1603" DateTime="01-01-2018 08:33">
    <Displays>
      <ChecksCompleted>
        <BankStandard>yes</BankStandard>
        <BankEnhanced>yes</BankEnhanced>
        <CardLive>no</CardLive>
        <CardEnhanced>no</CardEnhanced>
        <IDEnhanced>yes</IDEnhanced>
        <NCOAAlert>no</NCOAAlert>
        <CallValidate3D>no</CallValidate3D>
        <TheAffordabilityReport>no</TheAffordabilityReport>
        <DeliveryFraud>no</DeliveryFraud>
        <CreditScore>no</CreditScore>
        <Zodiac>no</Zodiac>
        <BankAccountPlus>no</BankAccountPlus>
        <BankOFA>no</BankOFA>
        <CardOFA>no</CardOFA>
        <RealTimeFraudAlerts>no</RealTimeFraudAlerts>
        <DeviceRisk>no</DeviceRisk>
        <MobileRisk>no</MobileRisk>
      </ChecksCompleted>
      <InputData>
        <Individual>
          <Dateofbirth>26/04/1977</Dateofbirth>
          <Title>Mrs</Title>
          <Firstname>xyz</Firstname>
          <Surname>abcr</Surname>
          <Emailaddress>abcxyz@gmail.com</Emailaddress>
          <IPAddress>2.111.222.77</IPAddress>
        </Individual>
        <Address>
          <Abodenumber>6</Abodenumber>
          <Buildingname>all </Buildingname>
          <Address1>NY</Address1>
          <Town>Westyorkshire</Town>
          <Postcode>LS123AJ</Postcode>
        </Address>
      </InputData>
      <BankcheckStandard>
        <Date_of_last_change>18/07/2017</Date_of_last_change>
        <BACS_Status>M</BACS_Status>
        <BACS_Settlement_Bank>0004</BACS_Settlement_Bank>
        <Settlement_section>02</Settlement_section>
        <Settlement_Subsection>14</Settlement_Subsection>
        <Handling_Bank>0004</Handling_Bank>
        <Account_numbered_flag>Y</Account_numbered_flag>
        <DDI_voucher_flag>N</DDI_voucher_flag>
        <CHAPS_Effective_date_of_last_change>09/07/2001</CHAPS_Effective_date_of_last_change>
        <CCCC_Settlement_bank>4</CCCC_Settlement_bank>
        <Debit_agency_sort_code>000004</Debit_agency_sort_code>
        <GB_Northern_Ireland_Indicator>GB</GB_Northern_Ireland_Indicator>
        <Branch_type_indicator>M</Branch_type_indicator>
        <Major_Location_Name>NY, KY</Major_Location_Name>
        <Branch_Name_or_Place>NY, KY</Branch_Name_or_Place>
        <Full_Branch_title_part_1>NY, KY(771408)</Full_Branch_title_part_1>
        <Address_line_1>PO Box 1000</Address_line_1>
        <Address_County>Essex</Address_County>
        <Post_Code_major_part>BX1</Post_Code_major_part>
        <Post_Code_minor_part>1LT</Post_Code_minor_part>
        <Telephone_1_area>0345</Telephone_1_area>
        <Telephone_1_number>3000000</Telephone_1_number>
        <Supervisory_Body>A</Supervisory_Body>
        <Bank_Code_of_owning_bank>0004</Bank_Code_of_owning_bank>
        <Full_name_of_owning_bank_line_1>LLOYDS BANK PLC</Full_name_of_owning_bank_line_1>
        <Short_name_of_owning_bank>LLOYDS BANK PLC</Short_name_of_owning_bank>
        <Short_Branch_title>LEEDS ARMLEY (771408)</Short_Branch_title>
        <Sub_Branch_suffix>00</Sub_Branch_suffix>
        <BIC_branch>N60</BIC_branch>
        <BIC_bank>LOYDGB21</BIC_bank>
        <sortcode>123654</sortcode>
        <CCCC_Effective_date_of_last_change>18/07/2017</CCCC_Effective_date_of_last_change>
        <CCCC_Status>M</CCCC_Status>
        <Date_closed_in_CHAPS_Euro_clearing>23/09/2008</Date_closed_in_CHAPS_Euro_clearing>
        <CHAPSE_Status>N</CHAPSE_Status>
        <CHAPS_routing_BIC_branch>XXX</CHAPS_routing_BIC_branch>
        <CHAPS_routing_BIC_bank>LOYDGB2L</CHAPS_routing_BIC_bank>
        <CHAPS_settlement_member>004</CHAPS_settlement_member>
        <CHAPS_Status>I</CHAPS_Status>
        <BACS_Date_of_last_change>06/06/2005</BACS_Date_of_last_change>
        <FPS_Status>M</FPS_Status>
        <FPS_DateLastChanged>23/02/2008</FPS_DateLastChanged>
        <FPS_SettlementBankConnection>01</FPS_SettlementBankConnection>
        <FPS_SettlementBankCode>0004</FPS_SettlementBankCode>
        <FPS_HandlingBankConnection>01</FPS_HandlingBankConnection>
        <FPS_HandlingBankCode>0004</FPS_HandlingBankCode>
        <FPS_AccountNumbersFlag>Y</FPS_AccountNumbersFlag>
      </BankcheckStandard>
      <BankcheckEnhanced>
        <Result>Pass</Result>
        <Score>75</Score>
        <AccountIssuer>LLOYDS BANK PLC</AccountIssuer>
        <OtherAccountsFoundForIssuer>no</OtherAccountsFoundForIssuer>
        <AccountStartDate>2014-08-01</AccountStartDate>
      </BankcheckEnhanced>
      <IdentityCheck>
        <addresspicklistfound>false</addresspicklistfound>
        <appverified>Yes</appverified>
        <cifas/>
        <confirmatorydobs>7</confirmatorydobs>
        <currentaddressmatched>4, LEYWELL TERRACE, LEEDS, LS12 3AJ</currentaddressmatched>
        <dvlawarning>false</dvlawarning>
        <ervalid>1</ervalid>
        <grodeceased>false</grodeceased>
        <halomatch>false</halomatch>
        <IDBasic/>
        <levelofconfidencebai>0</levelofconfidencebai>
        <levelofconfidenceccjs>0</levelofconfidenceccjs>
        <levelofconfidencedob>3</levelofconfidencedob>
        <levelofconfidenceer>5</levelofconfidenceer>
        <levelofconfidenceinvestors>0</levelofconfidenceinvestors>
        <levelofconfidenceshare>5</levelofconfidenceshare>
        <lorwarning>false</lorwarning>
        <matchlevel>IndividualReport</matchlevel>
        <namematched>MRS SRAIA AFSAR</namematched>
        <namepicklistfound>false</namepicklistfound>
        <numaddresslinks>0</numaddresslinks>
        <numbais>0</numbais>
        <numccjs>0</numccjs>
        <numcorroborativechecks>6</numcorroborativechecks>
        <numcorroborativeotheridsconfirmed>0</numcorroborativeotheridsconfirmed>
        <numinvestors>0</numinvestors>
        <numprimarychecks>8</numprimarychecks>
        <numprimaryotheridsconfirmed>0</numprimaryotheridsconfirmed>
        <numsharerecords>12</numsharerecords>
        <pafvalid>true</pafvalid>
        <passportwarning>false</passportwarning>
        <readmatch>false</readmatch>
        <sharelorwarning>true</sharelorwarning>
        <totaldobs>7</totaldobs>
      </IdentityCheck>
      <AgeVerify>
        <Age>40</Age>
        <DateOfBirth>1977-04-26</DateOfBirth>
        <Over18>yes</Over18>
      </AgeVerify>
      <OtherChecks>
        <IdentityResult>Pass</IdentityResult>
        <IdentityScore>0</IdentityScore>
      </OtherChecks>
      <DeviceRisk/>
      <Phone>
        <MobileRisk>
          <Standard/>
          <Live/>
          <Score/>
        </MobileRisk>
      </Phone>
      <Warnings>
        <NonGBRCardWarning>false</NonGBRCardWarning>
        <NamePicklistWarning>false</NamePicklistWarning>
        <AddressPicklistWarning>false</AddressPicklistWarning>
        <PAFNonValidWarning>false</PAFNonValidWarning>
        <CardAccountClosedWarning>false</CardAccountClosedWarning>
        <BankAccountClosedWarning>false</BankAccountClosedWarning>
      </Warnings>
    </Displays>
  </Result>
  <Errors/>
</Results>]]></RawResponse></BankEnhanced></CallValidate>

Что я уже пробовал:

I have to extract data using etl tool informatica but it doesnt read the xml tags but read the inner tags as data and store in database tables.

---