Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

XML import to MDM

When I try to import an XML file to MDM, using the Import Manager GUI,

if a node in the XML file has more than one value (the node repeats many times),

Import Manager creates a new table as a source.

Is there a way to have all XML data in one table as a source in the Import Manager?

Thanks

Nicolas

Tags:
Former Member
replied

Hi Nicolas,

how does your MDM repository look like? I'd expect something like a "Client - Maintable" having a "Family Member - Qualified lookup table". If this is the case, the import is quite easy. First of all you should use an XML Schema as already explained. Then you should use an XML message that describes the full set of the data that might occur (an XML that has a client and at least one familiy member) to create an import map. Uses the "Client" as a source table. In the source hierarchy view you'll see that below the "Client" table the "Family Member" table is linked. If you right-click on this one, you can lookup fields. Then you can use these fields in the mapping.

BR Michael

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question