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=SAP_IDOC_REDEAR
TYPE=A
ASHOST=pc001.con.com
SYSNR=01
RFC_TRACE=0

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.
         
            
             

10 comments:

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

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

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

    SAP OS DB MIGRATION ONLINE TRAINING

    ReplyDelete
  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

    ReplyDelete
  5. Below is the path for PWX SAP
    $INFA_HOME\Client\bin

    Below is the path for the saprfc.ini file
    C:\windows\system64\saprfc.ini

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

      Maybe is
      C:\Informatica\9.0.1\clients\PowerCenterClient\client\bin?

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

    ReplyDelete
  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 http://www.saphana.com/community/blogs/blog/2014/04/17/does-sap-hana-replace-bw-hint-still-no to gain knowledge on why do we need SAP BW service.

    Thanks

    Shiv

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

    ReplyDelete

Featured Post

Cloud : A Trendsetter Technology