XML Source Connector > XML Source Connector > XML Source Connector Example
  

XML Source Connector Example

The XML document contains customer account details. The following shows an example of XML file:
<?xml version="1.0"?>
<CustomerAaccountSummary>
<Customers>
<Customer Id="CUST12001">
<name>Premkumar S</name>
<DOB>10-05-1972<DOB>
<Salutation>Sir.</Salutation>
<Status>Verification</Status>
<Accounts>
<Account Account No="TAXACCNT23490796">
<PhoneNumbers>
<Phone type="Work">
<Number>+91 (080) 78092132</Number>
</Phone>
<Phone type="Home">
<Number>+91 (080) 32153345</Number>
</Phone>
<Phone type="Mobile">
<Number>+91 9676531675 </Number>
</Phone>
<PhoneNumbers>
<Addresses>
<Address>
<Address type="Work">
<Line1>Informatica Buss Soln.</Line1>
<Line2>Bagmane Tech Park</Line2>
<City>Bengaluru</City>
<Territory>Karnataka</Territory>
<Country>India</Country>
<ZipCode>560088</ZipCode>
</Address>
<Address type="Home">
<Line1>DNo-17, Achan Street</Line1>
<Line2>Indiranagar</Line2>
<City>Bengaluru</City>
<Territory>Karnataka</Territory>
<Country>India</Country>
<ZipCode>560078</ZipCode>
</Address>
<Addresses>
</Account>
</Accounts>
</Customer>
</Customers>
</CustomerAccountSummary>
The XML Source Connector organizes the elements into tables and fields, and segregates unbound elements as separate tables.
The following table lists the tables and fields that XML Source Connector creates after parsing the XML file:
Table ID
Table Name
XML Path
Table-1
CustomerAccountSummary_Customers_Customer
/CustomerAccountSummary/Customers/Customer
Table-2
Accounts_Account
/CustomerAccountSummary/Customers/Customer/Accounts/Account
Table-3
Accounts_Account_PhoneNumbers_Phone
/CustomerAccountSummary/Customers/Customer/Accounts/Account/PhoneNumbers/Phone
Table-4
Accounts_Account_Addresses_Address
/CustomerAccountSummary/Customers/Customer/Accounts/Account/Addresses/Address
Note: Any bound element to the former element becomes the child element of the former element. For example, PhoneNumbers is the child element of Accounts and Accounts is the child element of Customers.
Note: All simple and attribute elements are considered as fields. Complex elements are not considered as fields to the table.
The following image shows the tables on the Source tab:
The following image shows the relations between different tables:
The following image shows the sibling relation between tables: