How to connect to SAP sources from Informatica

Informatica Uses Remote Function Calls to connect to SAP systems. In order to connect to SAP systems.
  •  PowerExchange for SAP Net Weaver needs to installed on SAP server. 
  • PowerExchange for SAP Net Weaver Client needs to be installed on client machine $INFA_HOME\Client\bin on windows machine.
  •  SAP Remote Function Call saprfc.ini file needs to be placed on informatica server binary path $INFA_HOME/server/bin path
  •  On client machine as C :/WINDOWS/SYSTEM32/saprfc.ini add the below entry in the saprfc.ini file.
  •           Add the below entry in the saprfc.ini file.


DEST            =    <destination in RfcO pen>
TYPE             =     <A: RFC server is a specific R/3  application server>
ASHOST        =      <host name of a specific R/3 application server>
SYSNR          =     <SAP R/3 system number>
RFC_TRACE  =       It will be some numeric number (0 0r 1) default would be 0 in case if you want to generate the trace file mark it as 1.

  • After importing the source from source analyzer, the SAP access user id and password need to be given and filter criteria as Table name (so it will take less time) need to be mentioned.
  • Once the connectivity is established import the source.
  • Create the mapping and save it.
  • Generate the ABAP code after saving the mapping, refresh the mapping,validate the sessions and save it and run the workflow.
  • The number of times any modifications are made in the mapping, the same number of times the ABAP code need to be generated.


  1. Thanks, it was short, easy to understand and very informative

    1. IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Projects for CSE It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

      Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.

      Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

  2. Hi Shiva,can you explain how to use tibco system as informatica source and target

  3. SAP OS DB Migration Check minimizes technical risk involved in an operating system and/or database migration and avoids unforeseen costs that can occur during the SAP OS DB MIGRATION ONLINE TRAINING.


  4. hi, can i help me? i have a windows 7 with 64 bits machine. what is the root to PowerExchange for SAP Net Weaver Client? $INFA_HOME\Client\bin

  5. Below is the path for PWX SAP

    Below is the path for the saprfc.ini file

    1. tnks Shivakumar, but i have:
      C:\Informatica\9.0.1\clients within it: DeveloperClient, java, PowerCenterClient and tool.

      Maybe is

  6. when do we use SAP bw service to connect, or why do we set up SAP bw service in some cases?

  7. Hi Abhishesk

    We use Informatica vnedor provided power exhange to connect to SAP systems since there are no native connectors. You might need to go through to gain knowledge on why do we need SAP BW service.



  8. Hi,
    from where I can install PowerExchange for SAP Net Weaver Client. Informatica team told its already embedded in powercenter. PLease help?

  9. Thank you so much for providing such a necessary information about Informatica and its related products.Informatica and its components are the best when it comes to knowing about solutions.

    Informatica Read JSON


Featured Post

Cloud : A Trendsetter Technology