XML Source Connector Example
XML document contains customer account details.
The following shows an example of XML file:
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:
- •Table-1 and Table-2 has a parent-child relation.
- •Table-2 is parent to Table-3 and Table-4.
The following image shows the sibling relation between tables:
- •Table-3 is sibling to Table-4
