mdm syndication and importing – configurations and automation · 2019-11-12 · mdm syndication...

MDM Syndication and Importing – Configurations and Automation

SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com

© 2007 SAP AG 1

MDM Syndication and Importing – Configurations andAutomation

Applies to:

SAP MDM – SP 05

Summary

This document was written primarily for syndication and import of records into SAP NetWeaver MDM fromdifferent legacy systems. It explains the step by step configuration. This piece is also about automation ofthe process.

Author: Ganesh Kotti

Company: Seal Consulting Inc.

Created on: 8 September 2007

Author Bio

Ganesh Kotti has got around 9 years of experience in SAP and has worked as Technical as well as TechnoFunctional Consultant. He has been with Seal Consulting Inc for last 4+ years and is a member in SealConsulting MDM Competency group, and has been working in SAP MDM more than a year.



© 2007 SAP AG 2

Table of Contents

SDN Community Contribution................................................. Fehler! Textmarke nicht definiert.

Applies to:...................................................................................................................................1

Summary ....................................................................................................................................1

Author Bio...................................................................................................................................1

Table of Contents........................................................................................................................2

Introduction.................................................................................................................................3

Prerequisites...............................................................................................................................3

Step By Step Procedure :............................................................................................................4

MDM Syndication Configuration Design...................................................................................4

MDM - Syndication ................................................................................................................4

Mount MDM Server ..............................................................................................................4

Create Remote Systems ......................................................................................................6

Create Port ..........................................................................................................................6

Import XML Schema ............................................................................................................8

. ...........................................................................................................................................8

Create Map – MDM Syndicator ............................................................................................9

Attaching Map – MDM Console .......................................................................................... 13

MDM Importing of Records........................................................................................................ 14

XSD Upload ....................................................................................................................... 14

Remote Systems................................................................................................................ 14

Create Port ........................................................................................................................ 15

Create – Map - MDM Importing Manager............................................................................ 15

Mapping............................................................................................................................. 17

Attach Map – MDM Console............................................................................................... 19

Disclaimer and Liability Notice................................................................................................... 21



© 2007 SAP AG 3

Introduction

All the data from legacy systems has to be imported to SAP NetWeaver MDM through the Import Manager.For the Excel import or initial load there is no need of Automation process. For the scenarios likeconsolidation and duplication of materials, vendors or any other master data objects, the importing shouldhappen automatically without manual intervention.

For the central data maintenance, the data has to be sent to other legacy systems without manualintervention. For doing the importing and syndication process, we have to configure MDM Console, MDMImporting and MDM Syndicator. This document will explain step by step the procedure for accomplishing theabove mentioned task.

Prerequisites

SAP MDM SP05 or above



© 2007 SAP AG 4

Step By Step Procedure :

MDM Syndication Configuration Design

Below is the step by step process to configure MDM syndication process which is used to send the data outto other systems. For doing this MDM Console and MDM Data Manager should be installed on clientmachines.

MDM - Syndication

Mount MDM Server

The First thing we need to do is to mount MDM Server in your MDM Console. When you open it, you will see“SAP MDM Servers” in the left column.

Right Click “SAP MDM Servers“ Mount MDM Server

Enter a server address or select one from the drop down menu and press ok.

Before doing any configuration, ensure that MDM repository should be unloaded.

Place the cursor where the configurations to be done and right click and login to the MDM repository.



© 2007 SAP AG 5

Press ok to go into SAP NetWeaver MDM repository.



© 2007 SAP AG 6

Create Remote Systems

From the admin tree, select “Remote Systems”.

In the right hand Section of the screen, in the remote systems section, right click add client system.

Create Port

From the admin tree, select "Ports".

In the ports window, right click add port.

When you create a port in the MDM console, the server automatically creates a set of directories on thephysical server for files to be imported and exported, and logs regarding this port to be generated.Essentially, a port is just a way to define what map to use and the basics on where to generate the files itexports or imports.



© 2007 SAP AG 7

Enter the port information in the “Port Detail” section of the screen. Select type “Outbound”, and the remotesystem that we created in the last step. Leave the map entry blank, as we’ll be creating our map soon, so wewill come back to this later. Pay close attention to the “Processing” field. If you select manual, then MDM isexpecting you to manually export materials using the MDM Syndicator program. If you select Auto, then thesyndication server will automatically create XML files based on your mapping and place them in the portdirectory that is created on your server when you save this port.



© 2007 SAP AG 8

Import XML Schema

In order to perform the mapping in the Syndication Server, we need to define the XML schema to which wewill map.

.



© 2007 SAP AG 9

Create Map – MDM Syndicator

Login to the MDM Syndicator.

Click “Destination Properties”.

In the pop-up window, select XML schema as the type, the remote system you created earlier as the remotesystem, the XML schema for SEAL_LEGACY, and press OK.



© 2007 SAP AG 10

You may notice that the “Destination Items” section of the screen should now look similar to the screen shotbelow:



© 2007 SAP AG 11

Expand the products node and map it accordingly.

Make changes in the map properties window. Change the setting to single file all records.

Filter qualified links.

Suppress unchanged records.

Make thousand separator to None.

Map the fields as per below.



© 2007 SAP AG 12

After mapping save the map. File Save as

Enter SEAL_LEGACY_MAP and press ok.

Go to destination Items and change the map to required, so that empty node will be created.

After you made mapped fields as required, save the map.

Put the validation in the MDM Syndicator.



© 2007 SAP AG 13

Attaching Map – MDM Console

Unload the repository.

Go – Admin Ports – and assign the map what we created before.

Attach the SEAL_LEGACY_MAP. After you made all the configurations MDM Syndication will start working.



© 2007 SAP AG 14

MDM Importing of Records

Prepare the XSD.

XSD Upload

Go to Admin XML Schemas Upload the xml Schema.

Remote Systems

Create remote systems as type inbound.



© 2007 SAP AG 15

Create Port

Go to “Port” and create inbound port.

Load the repository after you create port and remote systems.

Create – Map - MDM Importing Manager

Create a sample XML file for the above .xsd and follow the below steps.

Connect to the repository



© 2007 SAP AG 17

Select source and target –MDM Import Manager

Mapping

After selecting source and target, map the source and target fieldsaccordingly.

For multi-valued qualified update option, follow the below steps, other wise it is not needed. Specifically, withqualified lookup fields (which are always multi-valued), each of the multiple values is not just a single datavalue, but rather an entire sub-record consisting of a set of values for both the display fields and thequalifiers of the qualified table record. With qualified lookup fields, the Append and Replace settings of theQualified Update option have precisely the same meaning and behavior as they do for the Multi-ValuedUpdate option with normal multi-valued fields and attributes.

Right click on the destination field which is mapped to Compound field. - > Set Qualified update to Updateand do configuration below.



© 2007 SAP AG 18

Also do the below configuration .It is used for automation. The below will be important. If you don’t do thisstep, SAP NetWeaver MDM will not pick the file from the ready folder. The status in MDM Console will show“Has data”. You can’t find this step in any documentation. For more information, please contact me.

Go to “Match Records” to tab and do the configuration as per below. You can create or update (All Mappedfields or Update (Null Fields) based on the business scenario,



© 2007 SAP AG 19

After all the above steps are done, save the map.

Attach Map – MDM Console

Logon to console - Ports Material_Valuation Attach the map to port.



© 2007 SAP AG 20

After you finish all the steps, your automation will start working. When you place a sample file in the readyfolder, based on the polling interval set in the MDM Ini file MDM Import manager will pick the file.

MDM Transports and MDM INI file setting will follow in forth coming articles.



© 2007 SAP AG 21

Disclaimer and Liability Notice

This document may discuss sample coding or other information that does not include SAP official interfacesand therefore is not supported by SAP. Changes made based on this information are not supported and canbe overwritten during an upgrade.

SAP will not be held liable for any damages caused by using or misusing the information, code or methodssuggested in this document, and anyone using these methods does so at his/her own risk.

SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content ofthis technical article or code sample, including any liability resulting from incompatibility between the contentwithin this document and the materials and services offered by SAP. You agree that you will not hold, orseek to hold, SAP responsible or liable with respect to the content of this document.

mdm syndication and importing – configurations and automation · 2019-11-12 · mdm syndication...

Documents