Contract data from ECC to MDM

[Former Member]

HI all,

We have standard setup to push Contract data to catalog from ECC using MECCM transaction from ECC... and Via PI we use the standard way to FTP the file... we use standard mapping interface in PI - CatalogueUpdateNotification_Out... which in turn pushes the Data from PI to FTP server. Where the MDM picks it and upload it.

Everything works fine.... But I need to understand how the MDM recogize the File and how the PORT and XML schemas upload the FIle into MDM database???

Need to Identify whether it can be modified???

regards,

Prabhu

[Former Member]

Hi Prabhu,

You can upload the xsd from PI into MDM. To get the schema go to your message type and click on xsd tab and copy and paste in notepad and save as .xsd and upload. Else you need to create the schema in external tools like altova xml spy or stylus studio etc.

There is option in MDM whether to load that file from the port automatically or manually. If automatic it will load immediate else you need to run manaully the file.

Need to Identify whether it can be modified???

I did not understand this. Do you mean to change something in the file once written from PI. If yes then try to go to MDM console and open the port and load it manually. So the file will be sitting there and you can modify and upload manually through Import Manager. But this is not advisable in production.

If PI is sending a csv or tab delimited file then you dont need to have a schme for that. You can load it manually.

Regards,

---Satish

[Former Member]

HI Prabhu,

MDM integrates with external systems through Port.

Ports are hub which are logical connection points.They can be inbound/outbound.XML schemas are linked with ports,at the time of port definintion.

There are Remote systems defined in MDM,the systems which send/receive data from MDM.

XML Schemas are defined in MDM Console tells the MDM system what format of data is and how parsing can be done.

Now,once you have a port for a Remote system "ECC" (say) and it has XML schema linked in console,the only thing you have to know is the field mappings of the data coming in MDM,this is done in Import Map.This map is defined in Import manager and linked to the port.It holds user level settings,Field Mappings,Configurations,Conversions,Value Mappings etc.

Once this is done and your port is set to automatic,you are ready to go for automated import.

Hope this helps!

Thanks,

Ravi