SAP MDM and Informatica ETL as Integration Tool

[Former Member]

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.

[rajesh_chavan · Accepted solution]

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

[Former Member · Accepted solution]

Hi RC,

We are using Informtatica as a Middleware, but the problem is that we are not able to place the file in MDM Inbound folder. as it says that access denied to informatica user. We have SAP MDM in differnt server and Informatica in differrent one so can we place file in MDM inbound folder through informatica ETL without FTP ? If yes then how and do you have any ppt or pdf doc where it mentiones all the steps required to carry out this type of connections ?

Help in this regard would be highly appriciated.

Thanks in advance.

Regards

Praful.

[Former Member · Accepted solution]

>>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

[Former Member]

Thanks a lot for your help and support.