Skip to Content
Former Member
May 05, 2011 at 11:59 AM

Want to extract data from a SAP BW system via Informatica ... Please help


Hi Everyone,

After doing a lot of reasearch on SAP front I am still not very sure regarding this topic. So, I am opting for the safest as well as the fastest way of knowledge gathering.

Question in details: I want to extract data from SAP BW system using third party tool (Informatica). I created an Open Hub Destination (OHD), source for the OHD is DataStore. After that, I created Transformation and Data Transfer Process (DTP) on the OHD. Then, I created a Process chain (which internally contains START Process, ABAP program and the DTP program) all linked in the same manner as mentioned above. Informatica is provided as an RFC destination in the OHD and also in the ABAP Program wherein the Program Name is "ZPMSENDSTATUS" and the Program Variant includes the Informatica Workflow information (folder and workflow name).

Problem: When I am running the process chain the data is not getting transferred to the target defined in Informatica.

Please help me out with the steps as described above. If anything is wrong above then please drop a comment stating the correct way. If anyone want to suggest some better technique for the same result, I will be more than happy to listen to it.

I am not very familiar with SDN. So, if after reading anyone feels like I have posted this question in a incorrect forum, please mention that in the comments. I will do the neccesary changes.

Thanks in advance.


Edited by: amit191980 on May 5, 2011 2:02 PM