How to process XML File generated from PeopleSoft Integration Broker?

Hi All,

I would like to process the following XML file in BizTalk and generate Employees XML file. This is the sample of the XML file generated from PeopleSoft posted to BizTalk.

*************************************************************************************************************

<?xml version=”1.0″ encoding=”utf-8″?>

<xml xmlns:s=”uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882″ xmlns:dt=”uuid:C2F41010-65B3-11d1-A29F-00AA00C14882″ xmlns:rs=”urn:schemas-microsoft-com:rowset” xmlns:z=”#RowsetSchema”>

<s:Schema id=”RowsetSchema”>

<s:ElementType name=”row” content=”eltOnly” rs:CommandTimeout=”30″>

<s:AttributeType name=”Can_PK” rs:number=”1″ rs:nullable=”False” rs:writeunknown=”true”>

<s:datatype type=”int” maxlength=”4″ precision=”10″ fixedlength=”true” maybenull=”False” />

</s:AttributeType>

<s:AttributeType name=”Title” rs:number=”2″ rs:nullable=”True” rs:writeunknown=”true”>

<s:datatype type=”string” dbtype=”str” maxlength=”3″ />

</s:AttributeType>

<s:AttributeType name=”FirstName” rs:number=”3″ rs:nullable=”True” rs:writeunknown=”true”>

<s:datatype type=”string” dbtype=”str” maxlength=”15″ />

</s:AttributeType>

<s:AttributeType name=”MI” rs:number=”4″ rs:nullable=”True” rs:writeunknown=”true”>

<s:datatype type=”string” dbtype=”str” maxlength=”1″ />

</s:AttributeType>

<s:AttributeType name=”LastName” rs:number=”5″ rs:nullable=”True” rs:writeunknown=”true”>

<s:datatype type=”string” dbtype=”str” maxlength=”20″ />

</s:AttributeType>

<s:AttributeType name=”BaseSalary” rs:number=”20″ rs:nullable=”True” rs:writeunknown=”true”>

<s:datatype type=”string” dbtype=”str” maxlength=”255″ />

</s:AttributeType>

</s:ElementType>

</s:Schema>

<rs:data>

<z:row Can_PK=”100005″ Title=”Mr.” FirstName=”TESTFIRST1″ MI=”X” LastName=”TESTLAST1″ BaseSalary=”80,000.00″ xmlns:z=”#RowsetSchema”>

</z:row>

<z:row Can_PK=”100006″ Title=”Mr.” FirstName=”TESTFIRST1″ MI=”X” LastName=”TESTLAST1″ BaseSalary=”80,000.00″ xmlns:z=”#RowsetSchema”>

</z:row>

<z:row Can_PK=”100007″ Title=”Mr.” FirstName=”TESTFIRST1″ MI=”X” LastName=”TESTLAST1″ BaseSalary=”80,000.00″ xmlns:z=”#RowsetSchema”>

</z:row>

</rs:data>

</xml>

*************************************************************************************************************

Out put of the XML file should be

<?xml version=”1.0″ encoding=”utf-8″?>

<Employees>

<Employee>

<ID>100005</ID>

<FirstName>TESTFIRST1</FirstName>

<MI>X</MI>

<LastName>TESTLAST1</LastName>

</Employee>

<Employee>

<ID>100006</ID>

<FirstName>TESTFIRST2</FirstName>

<MI>Y</MI>

<LastName>TESTLAST2</LastName>

</Employee>

<Employee>

<ID>100007</ID>

<FirstName>TESTFIRST3</FirstName>

<MI>Z</MI>

<LastName>TESTLAST3</LastName>

</Employee>

</Employees>

**********************************************************************************

1) IS there a way to define the schema for the Source XML file?

2) Is there a map i can define for this type of XML file?

All suggestions to process this welcome.

Thanks!

Venkat