How to import the data to Data manager

[Former Member]

Hi All,

I am new to MDM and need your help in handling the following issue

In our setup we are sending the Customer master data from R/3->XI->MDM (R/3-> XI IDOCs, XI->MDM XML files).

with the help of extraction job in R/3 IDOCs r generated and XI has onverted these IDOCs to XML Files and created at MDM Server. Now my Question is how to import the Data from these XML files to Data Manager !!!!

Note : Import Map settings are done already in the system.

Can any one help me the steps requeired to get this data to Data manager .

and am I need to do some activity in MDM to import the data to Data manager each and every time or is there any automatic way of doing this .

Please guide me.

Thanks in advance!

[Former Member · Accepted solution]

1. Use the MDM Import Manager to develop an "import map".

2. Save the map.

3. In the Console, create an inbound Port (in admin)

4. Choose your map and add it to the port.

5. Point XI to the directory that gets created by the port.

6. Turn on your import server

That will automate the process

[Former Member]

Hi,

For Manually- You have to create map ( one time) next time u can use same map. suppose ur map name is XYZ

Just have to map the fields in import manager by selecting proper source and destination table.

Aoutomatic-

For automatic u have to make ports. Make port in console (type inbound)> then while making port in field details there is a drop down showing MAP. Select the map( it will show all maps that u saved initially while importing maually- now this makes clear that even for aoutomatic u have to create map manually one time)

also make the process automatic.

In this port MDM automaticly creates ready folder.

You have to check that at server level.

Just put file in inbound>ready folder it will import data automatically.

Regards

Himanshu

[former_member201266]

Hi,

As you said you do already have a map, then you need not any thing manullly, apart from placing the xml file in the prorper folder.

In you MDM Server folder you have a foler with the remote system name(search it in program file; you will find it); inside that you have folders for each map within that remote system. Select the map which was used for that particular file and place your xml file in that folder. Depending upon the size of the file, with in few minutes it will be imported and visisble in Data Manager once refreshed.

Cheers,

Cherry.

[Former Member]

Hi MDM User,

Generally there are 2 cases while importing the data,

1) Initial Load

2) Delta Load

Initial Load means importing the data into MDM at first time.This is usually done by manual importing

without using import server.

Delta Load means importing the data into MDM when we have changes to existing data or added new data

to existing data.This is usually done by automatically using import server.

To manually import the data,just create a remote system and port in console and login into import manager

using remote system.Create ,save the map and execute the map.There is no other configurations needed.

To automatically import the data without manual intervention,we go for import server.

To let this happen we need to set some configuarations in mdis.ini file of import server.

Give the repository name,username and password which are set in console for that repository and also

give schedule time based on which import server picks the file from ready folder.

Go to the import manager , change the map and import action depends on your requriment and save that

map.

and also you need to set port type as inbound and automatic and select the map which you saved earlier in

MDM console.

As soon as we start the import server, it picks the file from ready folder of MDM server based on

configurations which we set in mdis.ini file and executes the map.

Here i am giving complete path of ready folder.

SAP MDM 5.5> Server>Distributions>bp1bocap080.bp.co_MSQL> BP3_PoC_Customer> Inbound>Siebel> SIEBEL_OB_CUS_SIEBELCUS01> Ready)

This path has to be given in target directory of receiver communication channel of XI so that it puts XML

file in the above path.

For better understanding,go through below blogs.

/people/balas.gorla/blog/2007/02/05/r3-xi-mdm-outbound-scenario

/people/balas.gorla/blog/2006/09/27/mdm-xi-r3-integration

Hope it helps

Reward points,if found useful

Thanks

Narendra

[Former Member]

Hi,

The steps to import filesare:

1. Firstly you should have selected the schema in console.

2. Import lookup tables got after MDMC transaction by choosing the particular tables.

3. Import the data into MDM, map all the fields & values in source items.

4. Choose the import action.

5. Import the records.

You should also makr the import server automatic.

Reward points if useful.

Regards,

Pramod