topic Re: How to use data transfer and data mapping using Informatica (Datawarehouse) in Application Development and Automation Discussions

How to use data transfer and data mapping using Informatica (Datawarehouse)

Former Member — Wed, 09 Jul 2008 18:08:52 GMT

Using Inforamatica people are trying to pull data from SAP tables. How?

Re: How to use data transfer and data mapping using Informatica (Datawarehouse)

shivhare — Thu, 10 Jul 2008 05:35:25 GMT

Hi,

check follwoing link

https://www.sdn.sap.com/irj/sdn/bpx-banking?rid=/business_maps/guid/eg1slxvyat1odhrwoi8vzxn3b3jrcgxhy2uuc2fwlmnvbs9zb2nvdmlldy9ty3bnzxquyxnw%0d%0ap3bhy2thz2vpzd0mdmlldz1zbwnyzw5kzxiyjmlkpuiynjq4mthdmem5mtrbrthcnzzcqky5rdy2%0d%0aouncqjzbjiz4c2wtymfzzt1odhrwoi8vzxn3b3jrcgxhy2uuc2fwlmnvbs9zb2nvdmlldy9ty3bn%0d%0azxrfbwltzs5hc3a/dxjspxnkbl9uzxcvjiz3zwitdxjspwh0dhbzoi8vzxn3b3jrcgxhy2uuc2fw%0d%0almnvbs9zb2nvdmlldy9ty3bnzxrfbwltzs5hc3a/dxjspsymehnslwxpc3q9c2rux2dlbmvyywxf%0d%0acmvuzgvylnhzbhq7c2rux2xpbmtyzxdyaxrpbmcuehnsddtnzw5lcmf0zuhutuxfu0rolnhzbhqm%0d%0ajnbhy2thz2utawq9jizyzxnvdxjjzxr5cgu9c2rux3nvbhv0aw9ux2nvbxbvc2vyx2z1bgxwywdl%0d%0ajizwyxjlbnrssuq9l3dlymnvbnrlbnqvd2vicgfnzxmvynb4lzqwieluzhvzdhjpzxmvqmfua2lu%0d%0azy9cyw5raw5nifnvbhv0aw9uie1hccymdgl0bgu9u0fqienvbnzlcnnpb24gqwdlbnqgynkgsw5m%0d%0ab3jtyxrpy2emjnzpcnr1yww9dhj1zq==&prtmode=default

for pulling data from table you can also use IDOC - and with the help of SAP XI you can integrate -

thanks

Amit Shivhare

Re: How to use data transfer and data mapping using Informatica (Datawarehouse)

Former Member — Thu, 10 Jul 2008 08:13:15 GMT

Hi,

I don't think informatica has the capability to pull the data directly from the sap tables, you should pass the data to informatica system by some means, ie either by a flat file or idoc's to the informatica system.

What sort of data do you want to transfer to informatica, depending upon your type of data we can decide whether we have standard idoc type for that or not, if not we need to go ahead with the custom stuff.

Thanks,

Mahesh.

Re: How to use data transfer and data mapping using Informatica (Datawarehouse)

Former Member — Thu, 10 Jul 2008 09:44:20 GMT

Hi Gowri,

Informatica can diretlcy connect to SAP Server and can Pull the table data .But for Pushing the the data Custom RFC or Bapi will serve the purpose . Informatica can give the IDocs also.

Regards

Sreedhar M