Hello all, We have to create a solution here, and I wanted to colloborate with some of you to try to nail down the "best" approach. Basically, we have a new client application (approx 70 required/validated fields). In some cases, we want to pull in this data
directly from our regional partners which already have it stored in their DBs ranging from SQL 2000 - Oracle - MSAccess - etc. Some of our preliminary solutions are: 1- Create an XML template for these regional partners to populate, and validate the data using
.dtd's (any better XML Validators in .NET C#?). We would also need to provide them a mapping tool from their database structure to ours (which would be represented in the XML template). Then create a simple asp.net file uploader to pull in their daily generated
XML docs, validate the XML doc on the fly, import if valilidation is successful, or not import and notify validation errors on webform. 2- This is more of a question ... would it be more plausable to publish a webservice that accepts the entire application,
then create an internal C#.NET validation/mapping tool that validates, imports, reports success/failure? 3- Are there any other approaches that are better then either or the 2 above? Maybe the .NET Framework may already have objects to accomplish much of this??
psinyc
Participant
1475 Points
293 Posts
XML Schema Mapping Solution
Aug 03, 2004 03:19 PM|LINK
Peter Iuvara, MCP