on 03-04-2011 10:45 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
>>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
Thanks a lot for your help and support.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.