Skip to Content
avatar image
Former Member

SAP MDM and Informatica ETL as Integration Tool

HI Expert's

We have a Scenario where i want to use Informatica ETL as a Middle ware. Informatica will pull the data from legacy and will post a tab delimited file in MDM inbound folder.

can any one guide me how to achieve this ? what all steps need to be defined at Informatica ETL Level does any one know ?

I wont be using FTP for this activity si is there any other way for this?

Thanks in advance to all of you.

Regards

Praful.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 04, 2011 at 03:16 PM

    Hi Praful,

    You are free to use any middleware as long as it gives data in required format to MDM 😊

    It depends what data you want to pull from source system using middleware. for Main table data (records) I am sure Middleware like informatica can place data in MDM inbound folder directly, then you don't need to Make it as FTP enabled. If NOT then you need tomake FTP enabled.

    About reference data you need to decide how will you pull that from source system. Since it is not very frequent activity and if you have less number look-ups then even we can prepare data in spreadsheet and pull in MDM. Also check with Informatica if they can pull reference data from source system and place in MDM inbound folder of respective ports. If possible then you don't need to make it FTP enabled.

    Having Informatica as middleware will also be helpful to carry your cleasing actvity. Update us on your views.

    Cheers,

    Rc

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      >>access denied to informatica user

      Make sure that the user is created in MDM Console and has "Admin" authorization.If you have created a windows/Unix user, it won't work.

      >>can we place file in MDM inbound folder through informatica ETL without FTP

      Not sure what exactly you mean by this,even Informatica is doing FTP, it is getting files from a source system and dropping in "Ready" folder of MDM.

      Thanks

      Aamir

      Edited by: Aamir Suhail on Mar 7, 2011 4:20 PM

  • avatar image
    Former Member
    Mar 09, 2011 at 07:04 AM

    Thanks a lot for your help and support.

    Add comment
    10|10000 characters needed characters exceeded