Documenting XML integration (xpath)???

[jmoore00005]

What is the best method for documenting an integration project that utilizes XML for data exchange? We have an XML schema defined from a third party system and they will send us XML files for inserts and updates. We need to map these XML files to our database tables and fields. The current scope is to document the mapping between their XML schema and our tables and fields. What method is recommended for documenting this mapping. Should we just use the XPATH tied back to each field in the database?

Thanks for the help.

 

[JontyMC]

Personally, I would write an XSL stylesheet(s) that would create the SQL statements from the XML.

Jon

"I don't regret this, but I both rue and lament it.