Skip to Content
avatar image
Former Member

Integrate different source systems using sap MDM.

Hi everyone,

I have a scnerio where we are trying to integrate the product information from different source systems using sap MDM.

My source systems are SAP R/3, ORACLE and some other 3rd party.

Now my question is what should be my approach, how the data form R/3 and ORACLE is getting extracted . I read some blogs

where it says R3 data can be imported into MDM using IDOCS like matmas ........ how is it done w.r.t ORACLE.(and how this data is getting consolidated and syndicated)

could anyone please provide me some clear info about this.

(PLZz ...I am a bit new to the MDM area )

best regards,

vee.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 13, 2010 at 03:57 PM

    Hi,

    You can directly Import data into MDM from Oracle (*without any middle ware). Please Check the document [ Step by Step Importing data from Database (SQL/ORACLE) into MDM|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/908a69fc-8cda-2b10-90b5-8e462bccccdb?quicklink=index&overridelayout=true].

    I agree with Mandeep. You can also introduce PI as Middle ware between Oracle and MDM. So, PI will fetch data from Oracle using JDBC adapter and will transfer this data in form of file on MDM port using MDM or File Adapter. This will definitely introduce end to end monitoring, validations, Data Format conversion/mappin capabilities of PI. But in this case from MDM side, it will be just like MDM is importing data from File. Also, this will introduce cost of an additional interface.

    For Integration of other systems like R/3, CRM and SRM with MDM is done using PI interfaces. Standard data extractor programs and PI content for interfaces is available and can be utilized for this purpose. Normally communication between R/3 and PI is using IDocs/Proxy and between CRM/SRM to MDM is using Proxy. PI communicates with MDM using File.

    Detailed documents of each Master Data object like customer, vendor etc. are available on Service Market place as attachments of below mentioned notes. These documents also contains details of integration of different SAP systems with MDM.

    • MDM Business Partner Content (SAP Note 1035773)

    • MDM 5.5 Customer Content (SAP Note 1252884)

    • MDM 7.1 Customer Content (SAP Note 1412742)

    • MDM Employee Content (SAP Note 1268212)

    • MDM 5.5 Material Content (SAP Note 1255401)

    • MDM 7.1 Material Content (SAP Note 1355137)

    • MDM Product Content (SAP Note 1252846)

    • MDM 5.5 Vendor Content (SAP Note 1252883)

    • MDM 7.1 Vendor Content (SAP Note 1318478)

    Also, check this wiki page [SAP Remote system integration with MDM|http://wiki.sdn.sap.com/wiki/display/SAPMDM/SAPRemoteSystem+Integration] which is very quick and informative.

    Hope this will help you

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 10:55 AM

    You can export data from R/3 using IDOCs, Proxy etc and then using PI (Middleware) convert this data to XML file format and then data can be imported into MDM using XML file format. Now when you have to syndicate data out of MDM you can export it in the form of Text file, XML file which then through PI (Middleware) get converted into IDOC, Proxy structure of R/3 system and then can imported into R/3 systems.

    Oracle can export and import data in the form of External file, you can either use this File format to import data into MDM or you can directly connect to Oracle database through Import Manager. Now during syndication data out of MDM you can send this data in the form of text files and then can import data into Oracle or you can also make use of PI (Middleware) to convert your MDM data Flat/XML file into Oracle structure (using JDBC Adapter) and then import data into Oracle.

    Note: Data is imported into MDM using MDM Import Manager where you can select type as XML file, flat file etc, you can also

    select there Type as Oracle directly to import data into MDM using MDM import Manager.

    Regards,

    Mandeep Saini

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 06:25 PM

    Thanks for all your quick responses.

    Add comment
    10|10000 characters needed characters exceeded