What does the file use?

[Former Member]

When we open a repository stencil, let's say "Material", after unzip we can see other 3 zip files, respectively named XSD.zip, ImportMaps.zip, ExportMaps.zip and MDM Lookup Tables.xml as well as 55310_Material.a2a.

The question is the meaning of each file and the which kind of fuction will be carried out through these files?

[Former Member]

Hi Alfred,

What is your source for MDM?

Client system is mandatory if you want to import from a source system.

If you’re using local excel file or xml file as your source then you don’t need to define a port.

If you’re using any client system such as ERP, Oracle as source system then you got to define a port for each client systems.

Follow the steps to define client system.

1. Define a remote system in Repository->Admin->Remote systems.

2. If the remote system is supplying data to MDM (Source system) select type as Inbound.

3. If the remote system is retrieving data from MDM (Destination system) select type as Outbound.

4. If the remote system is supplying data to and retrieving data back from MDM (Source and Destination are same) select type as Inbound/Outbound.

Thanks,

Arun prabhu S

[Former Member]

Thank you, Arun!

Now we test to create new port for Inbound, we choose the Excel as the format. And then, we go to outbund creation with new port, during port saving, system show a warning message:" You must enter the client system". In this case we try to make a selection in the field named " Client system", but this field is not optional. How should we do the next step?

[Former Member]

Hi Alfred,

Answers for your questions...

1) If we unarchive a repository based on stencil e.g. Material, after unarchving successfully, the only thing that we can see is a null folder, under the directory of Sever/Accelerators/SQL name. In contrast, when a repository creation, after that we can see a lot of files automatically generated by system. Why?

When we create/ unarchive a repository the MDM creates two databases in the database server. The files that created automatically are used to accelerate the data transaction between MDM and database.Not sure.

2) After one repository creation, system automatically creates two null folder named Inbound and Outbound under Server/Distributions/SQL name/Repository name/. Why?

When you add a port of type inbound or Outbound in the Repository->Admin->Ports table MDM creates a folder with the “port name” under …Server/Distributions/SQL name/Repository name/.

Under the folder “Port Name” it will create folders for Inbound and Outbound ports.

MDM picks source data comes from source system in the form of xml and puts data which need to be sent to destination system.

If we want to automate the import and syndication action from client systems, we go for import server and syndication server.

During import action the source system puts the data into the Server/Distributions/SQL name/Repository name/Inbound/Ready folder. Syndication server uses outbound port.

3) Let's say, now we use the standard stencil provided by SAP, but if we want to create own customer-specific stencil, so, in this case how to make these kind of files like xsd, import map, export map,... within one package just like SAP provided us.

It is not necessary to have all the content in a single package.

SAP provides the business contents which are applicable to most of the business environment.

If you want to define customer specific business content, then you have to create all by your own including maps, schema files.

Thanks,

Arun prabhu S

[Former Member]

Thank you, Arun!

1) If we unarchive a repository based on stencil e.g. Material, after unarchving successfully, the only thing that we can see is a null folder, under the directory of Sever/Accelerators/SQL name.In contrast, when a repository creation, after that we can see a lot of files automatically generated by system. Why?

2)After one repository creation, system automatically creates two null folder named Inbound and Outbound under Server/Distributions/SQL name/Repository name/. Why?

3) Let's say, now we use the standard stencil provided by SAP, but if we want to create own customer-specific stencil, so, in this case how to make these kind of files like xsd, importmap, exportmap,... within one package just like SAP provided us.

[Former Member]

Hi Alfred,

.a2a file is the archive file of a repository.It is the predefined repository structure ie business content. Paste this file in the ../MDMServer/Archives folder if you want to unarchive the repository and make use of the predefined structure.

.xsd file is the schema file, a predefined file that is used to define the xml structure of the data for syndication.

Import Maps and Export maps are the predefined maps for the Source and destination system resp. Open the import mgr after giving the source data details. Open the Import map. This will do the automatic mapping of source and destination fields. Similar steps for Syndication.

I guess the MDM Lookup Tables.xml is the given sample source data.

Thanks,

Arun prabhu S

[Former Member]

Thanks in advance!