Syndication of data in mdm 7.1

[Former Member]

Hello,

Can anyone guide me for the steps to syndicate data from mdm 7.1 to a flat file or ecc.Thanks in advance.

[Former Member · Accepted solution]

Hi Chinu,

Please refer the below steps:

1. Open MDM syndicator with Login Credentials

2. Go to File>New> A pop up window will come here,Select Type = Flat and Remote System = Required Target system and then Press OK.

3. Now click on Destination Items Tab, Here you can add Destination Item(target Fields) as per your requirement.

4. Now go to Item Mapping tab, map your MDM fields with this created Destination Items tab

5. After mapping fields, Go to syndication-->Execute

Also refer, this article page 11 onwards http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/80eb6ea5-2a2f-2b10-f68e-bf735a457...

Regards,

Mandeep Saini

[Former Member · Accepted solution]

Thank you so much .This answer was really helpful for me.But still im not getting the exact steps for PI part.If anyone can provide me with the screen shots it will be really helpful.

Keep up the good work guys!!

[former_member208981 · Accepted solution]

Hi Chinu,

Please refer the below links for PI-MDM integration: (From MDM 7.1 we are usinf MDM-PI adapter for the integration)

/people/ramesh.gulipalli2/blog/2009/11/16/sap-47-to-mdm-integration-using-pi71-part1

/people/ramesh.gulipalli2/blog/2009/11/27/sap-47-to-mdm-integration-using-pi71-part2

http://help.sap.com/saphelp_nwmdm71/helpdata/en/48/956cd09521062de10000000a42189d/frameset.htm

Thanks,

Priti

[Former Member · Accepted solution]

Hey Mandeep,

Thank you so much for your information.But I could nt find 'Destination properties' tabh in MDM.And how we have to send it to a flat file and where it gets stored also not mentioned.Please throw some light on that side as 'Destination Properties' tab also.Please guide me.Thanks in advance.

[former_member208981 · Accepted solution]

Hi Chinnu,

After connecting to syndicator, you should be able to see the Destination properties tab (3rd tab .. after Item mapping , map properties..)

The path for the outbound ready folder is as below at the server level:

root/DBMSinstance_DBMStype/RepositoryName/Outbound/ RemoteSystem/PortName/Ready

If you want the file on your local desktop:

1. Connect to Syndicator

2. Destination Items -> Right click -> Add Destination Item -> Exmple: material Number, Material Desc

3. Item Mapping : Map the fields

4. Save the map

5. Click Syndicate icon

If you want the file in a outbound Ready folder, from where PI will pick up the file: (Automatic syndication to port)

1. Connect to Syndicator

2. Destination Items -> Right click -> Add Destination Item -> Exmple: material Number, Material Desc

3. Item Mapping : Map the fields

4. Save the map

5. In console : Create a Remote system (Outbound)

6. Create Port -> Select Format as delimited Text , Delimiter \t , assign map

7. keep Processing: Continous

8. Test: Create new record

9. Check in the outbound ready folder : the file should be there

10. Configure PI to pick the files and send it to ECC

If you want the file in a outbound Ready folder, from where PI will pick up the file: (Manual syndication to port)

1. Connect to Syndicator

2. Destination Items -> Right click -> Add Destination Item -> Exmple: material Number, Material Desc

3. Item Mapping : Map the fields

4. Save the map

5. In console : Create a Remote system (Outbound)

6. Create Port -> Select Format as delimited Text , Delimiter \t , assign map

7. keep Processing: Continous

8. Connect to syndicator

9. File -> New

10. Type -> Port , Select the RS and port you created in the above steps

11. The map you created would have opend not

12. Syndicate

[Former Member · Accepted solution]

Thankyou so much for your guidance.The 3rd tab is destination items.But i mean the tab for destination properties in File menu is not being shown for me so that automatically it will get the destination fields rather than manually typing all the fields in destination tab.This answer was really very helpful for me.

[former_member208981 · Accepted solution]

Hi Chinu,

The Destination items option is not part of the File menu.

The fields need to be created the first time. After you save the map, they will be present.

Thanks,

Priti

[Former Member · Accepted solution]

Hi Priti,

Thanks s lot for your response.But in this following link i followed all the steps but in page 9 ,there is destination properties tab mentioned which im not getting to get that xml schema in mdm.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0827507-7d4d-2a10-91b1-e85ef67f0...

Please guide me.

[Former Member · Accepted solution]

Hi ,

Please can you guide me how to use abap apis for mdm 7.1 rather than using XI as middleware.Scenario is MDM-> ECC using abap api.Plesae guide me .its really urgent.Thanks for you effort ! keep up the good work!!!!

[Former Member · Accepted solution]

Hi,

Please anyone guide me in this syndication.I was succeeful in doing for flat file .now i want to send using abap api to ecc.and while configuring im not getting that Destination properties tab to import that xml schema as specified in that link.Please guide me.Thanks in advance.

[Former Member]

Hi Chinu,

You should understand here one thing like whether you are going to use PI or not. If you are using PI then give them the fields you are going to use then they can create an xsd schema for you. Once when you have the xsd you can upload in MDM console and can use this xsd directly. Else you have to create flat file and here you have to create all the fields manually in MDM syndicator. Once when you have the target fields in syndication map it directly. Some help you can get here also, it is for mdm 5.5 but the steps are same in 7.1 also:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0827507-7d4d-2a10-91b1-e85ef67f0...

Also please follow other suggestions in this thread for automatic syndication in production. Also if you have MDM PI adapter in PI then you can directly send from MDM to PI.

Regards,

---Satish

[Former Member]

Thank you so much for throwing some light on the exact requirement.I want to syndicate data to flat files in mdm 7.1.So i dont know whether i need to configure port and PI as well.Please guide me in this.

[former_member182007]

Heyy for more insights on PI adapter you can follow below threads.

hope it helps.

-Deep

[former_member208981]

Hi Chinu,

To syndicate date to Flat file:

1. Connect to Syndicator

2. Destination Items -> Right click -> Add Destination Item -> Exmple: material Number, Material Desc

3. Item Mapping : Map the fields

4. Save the map

5. In console : Create a Remote system (Outbound)

6. Create Port -> Select Format as delimited Text , Delimiter \t , assign map

7. keep Processing: Continous

8. Test: Create new record

9. Check in the outbound ready folder : the file should be there

10. Configure PI to pick the files and send it to ECC

For XML format:

Define a xsd which will define the structure of your destination side.

You need to define the xsd in Console in the table XML Schemas

Connect to syndicator

File -> New

Select the XSD you declared here

Next -.> Map the fields and save the map

Then, syndicate.

Create Remote system, port . Assign map tp the port.

You can have the scenario: MDM -> PI-> ECC

Refer this link for step by step procedure: /people/harrison.holland5/blog/2006/11/27/mdm-syndication

Please refer the below links for complete understanding of the scenarios:

http://help.sap.com/saphelp_nwmdm71/helpdata/en/42/c89fc0c84e136ce10000000a1553f7/frameset.htm

http://help.sap.com/saphelp_nwmdm71/helpdata/en/43/1346e6ca856f40e10000000a422035/frameset.htm

http://help.sap.com/saphelp_nwmdm71/helpdata/en/5c/73b2429da4c511e10000000a1550b0/frameset.htm

Try it out and let us know what errors you face.

Thanks,

Priti

Edited by: Priti Rani Patnaik on Sep 21, 2010 12:26 PM

[Former Member]

Hi,

Refer Following link

http://help.sap.com/saphelp_nwmdm71/helpdata/en/index.htm

Thanks,

Jignesh Patel

[Former Member]

Hi,

Thankyou so much.But i couldnt find anything on syndication of data to a flat file.Please guide me in that since I am new to MDM.Thanks in advance.