Data Mapping between Applications.

[CV]

Hello,
Could anyone please throw your suggestions on the following
scenario?

(It would be really helpful if you could provide a solution using
..NET,XSLT,XSD,Web Service other than 'Biztalk Server' Approach.) -
Honestly speaking, I am new to this Data Exchanging Process, though I
have some knowledge in XML,XSLT,Webservice,C#,ASP.net etc.

In my project, there is a need to design an interface to handle data
exchange between two applications using XML, XSLT ,XSD,.NET , Web
Services,etc .

Business rule:
--------------
Let us say, The data in a XML file from Application A(Destination) has
a column name "Prod Id" needs to be mapped/changed to "Production Id"
column of Application B(Source) which is the Main Application. In the
same way, some more Applications will have the data for the same
Column, but Coulmn names could be represented in other ways like P.Id,
P.No,etc.

My Interface should provide options to map Columns between Source and
Destination Applications and to upload the XML file from destination
app into Source App.

After Saving the Mapping info. into database or a template, The
uploaded file file from Destination Application should be converted
into the format of Source XML file based on the mapping Info.

Please let me know your suggestions as to how to handle the above
scenario? Though you might have come across these kind of questions
already, Please give your Solutions using .NET technologies.

Thanks in advance,

Regards,
CV

[Kathleen Dollard]

CV,

I have done some simple ORM, which is the same sort of mapping. I thought
BizTalk offered some mapping. If not, you can brute force it. Create a
mapping file, differentiate what's a source and a target, and hope for one
to one mappings. There may be more sophisticated solutions.

--
Kathleen Dollard
Microsoft MVP
Author "Code Generation in Microsoft .NET"
"CV" <te*********@yahoo.com> wrote in message
news:52************************@posting.google.com ...

Hello,
Could anyone please throw your suggestions on the following
scenario?

(It would be really helpful if you could provide a solution using
.NET,XSLT,XSD,Web Service other than 'Biztalk Server' Approach.) -
Honestly speaking, I am new to this Data Exchanging Process, though I
have some knowledge in XML,XSLT,Webservice,C#,ASP.net etc.

In my project, there is a need to design an interface to handle data
exchange between two applications using XML, XSLT ,XSD,.NET , Web
Services,etc .

Business rule:
--------------
Let us say, The data in a XML file from Application A(Destination) has
a column name "Prod Id" needs to be mapped/changed to "Production Id"
column of Application B(Source) which is the Main Application. In the
same way, some more Applications will have the data for the same
Column, but Coulmn names could be represented in other ways like P.Id,
P.No,etc.

My Interface should provide options to map Columns between Source and
Destination Applications and to upload the XML file from destination
app into Source App.

After Saving the Mapping info. into database or a template, The
uploaded file file from Destination Application should be converted
into the format of Source XML file based on the mapping Info.

Please let me know your suggestions as to how to handle the above
scenario? Though you might have come across these kind of questions
already, Please give your Solutions using .NET technologies.

Thanks in advance,

Regards,
CV