Excel upload from Iview

[jean-philippe_pain2]

Hello all,

I have a scenario where the business upload their own excel files (with multiple tabs) through SAP Portal Iview.

Today, after uploading these datas, the client use a specific developement to "prepare" datas before putting it in MDIS repositories. Indeed, it seems it was to complicate to put directly the file in MDIS for MDM loading.

Now, they want something standard process, which can monitor from the upload to the end of the loading in MDM.

I would like to propose to use DQM add-on thru enrichment controller in order to eliminate specific development and clean datas. What do you think about that ? Or is there an easier way to upload a multiple tab excel file to MDM ? SAP PI can be a solution no ?

Better solution could be : uploadin form iview -> DQM -> PI - MDM ?

For the DQM, what do i need ? All Data services suite ? Do you have some documentation on it plz ?

Thank you.

[Former Member · Accepted solution]

as per my understanding there would be two different tab in excel sheet with different set of data and fields.

you can create import map by joining to two sheet(two diffrent tabs) under single map through MDM Import Manager

hope this may resolved your problem

Thanks,

Jignesh Patel

[Former Member]

Hi

If you are using uploading form iview -> DQM -> PI - MDM ?

- Then you have Enhance Inbound adapter for excel and then feed MDM with XML via PI.

- Another option Excel map new port.

- Or another Create API Update data in MDM

Thanks

SD

[jean-philippe_pain2]

Sorry for the delay.

I am still looking for informations on this sybject, especially since SP05. It seems there are specific iview for retail.

That's what i am interested in so if you links please....