mdm , XML

[Former Member]

Hi All,

what is the need of xml schema in import manager.

Can we create a an XML schema from an XML file.

what is the use of Altova XML spy,why exactly we will use this tool in our mdm project.

pls explain in detail, examples if any.

thanks,

ve

[Former Member · Accepted solution]

Hi Veena,

what is the need of xml schema in import manager.

XML schema is required to be imported in console so that we can acertain the incoming xml against it.

It tells MDM that incoming xml has valid structure as per the xml schema defined in MDM Console.

Can we create a an XML schema from an XML file.

Yes we can create XML schema from from xml file using Altova and other such tools.

what is the use of Altova XML spy,why exactly we will use this tool in our mdm project.

Altova XMLSpy® 2011 is an integrated development environment (IDE) for XML that is used to create and edit XML-based applications. With XMLSpy® 2011 we can easily define XML Schemas and construct XML documents, then automatically generate runtime code in multiple programming languages for use in XML-based applications. XMLSpy® 2011 includes powerful features for all XML-related development tasks, including editing, troubleshooting and debugging, validating, transforming, and more.

In short XSD creation from avilable xml,editing of xml,and other xml related activities are supported in Altova XMLSPY.

Lets take a scenario in which a remote system A sends MDM data in xml file.

So first thing is to have a port for that Remote system.Once we have defined inbound port,we should go ahead define the XSD in SAP MDM and upload it in console.Inbound maps need to be prepared using those "valid" xmls.

And for automatic import that map can be set to that port and port type can be automatic.

Now valid xmls coming in Ready folder will be imported if they dont have data or import related discripancy and

xmls which have structure related discrepancy will goto StucX folder of exception.

Hope it helps!

Thanks,

Ravi

[Former Member · Accepted solution]

Ravi / Shiv - Thanks a lot for your explanation...very helpful.. thanks

just one more thing - in general how do we create this XSD

do we have standard xsd delivered from SAP OR do we take the incomming XML file and create our own XSD from that OR any other way ??

regards,

ve.

[Former Member · Accepted solution]

if u are using standard SAP content (scenarios) the XSD is supplied - which u have to edit to ur purposes.

else the easiest way is to ask ur PI guy (if u have a PI interface for data transmission) - to generate a XSD for each data channel (a click of a button)

thanks

-Adrivit

[Former Member · Accepted solution]

Hi Veena,

Yes XSDs are provided with standard business content.

If we want to integrate a 3rd party or the standard content provided does not meet your requirement,we prepare XSD for that source.

A simple way is to prepare xml using notepad and generating XSD based on that xml using PI/Altova or many other online xsd generators.

Thanks,

Ravi

[former_member205403]

Hi Veena,

Please find my comments below:

what is the need of xml schema in import manager.

If you are doing frequent import from the same XML File format then it is suggested to define XML Schema in Console and use it in Import Manager. This way you can validate the source data XML file against the XML Schema. Also for automatic import from XML file, it is mandatory to define XML Schema first in Console.

Can we create a an XML schema from an XML file.

Yes, You can create an XML Schema from an XML File. Many XML/XSD editing tools has this feature including XML spy .

what is the use of Altova XML spy,why exactly we will use this tool in our mdm project.

You use this tool in your project to define different Import or syndication XML Schema definition files (.XSD) files.

Please revert if any further query..

- Shiv