Tuesday, March 26, 2013

How do we extract SAP data Using Informatica?

  1. We can extract SAP data by using informatica with the powerConnect option.
  2. We need to install and configure the PowerConnect tool .
  3. Import the Source in to the Source Analyzer. Here PowerConnect is the gateway between SAP & Informatica. Then develop the mapping in the mapping designer. Next we need to generate the ABAP code for that mapping,then only the Informatica can be pull the data from SAP.
  4. Power Connect is used to connect and import sources from external systems like for example Mainframe(IMS, DB2, VSAM) or ERP or MQ Series etc. 
  5. Earlier we had connectivity to Applciations and Mainframes called as "Powerconnect" and "PowerExchange" respectively. 
  6. Going forward all connectivity to databases and other applications/mainframes are now all referred to as "PowerExchange".


  1. Informatica Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Informatica Online Training, Informatica Training, Informatica, Informatica Online Training| Informatica Training| Informatica| "Courses at 21st Century Software Solutions
    Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 -

  2. Informatica Online Training very less prices only at by real time Employee

    Thanks and Regards
    Your Best Online Training Partner
    Call +91-720-720-9005
    Skype: DWBIADDA

  3. Best Informatica Training by TOP Industry Experts in Delhi/NCR with 100% Job Oriented & Placement Record.

    Free 1st Demo Class, Fresh Batch Start from Nov-2014 Call to Book Your Seat Now : 08447037614/09910840204,

  4. It was really a nice article and I was really impressed by reading this article. We are also giving all software Course Online Training. The Informatica Online Training is one of the leading Online Training institute in the world.

  5. Fantastic Blog..!!
    Thanks for sharing such a good information

  6. Thanks for given Very nice information about informatica.................... Informatica online training

  7. Thanks for posting about informatica. It is very usefull to us.... Informatica online training

  8. thank you for your wonderful information on informatica keep sharing thank you
    visit our site to learn

    Advanced informatica online training!

  9. Nice blog..

  10. I have readied at least eight posts on your website and let me tell you, your website provides the most fascinating information. Thanks for sharing. Suppose if you want to learn more about Informatica, then just has a look: informatica-training

  11. Very good information thank you for sharing. Know more about Informatica Data Quality Training

  12. Your sap information is really very well done and i have got more information it is very much nice and interesting.

    Best Informatica Training Institute in Chennai

  13. This blog helps me to extract the SAP data using Informatica. You explained with set-up-set manner. If you infographical image, then your blog will be more clearly understandable for the users.
    Informatica Training in Chennai

  14. i was spent lot of time to give the best reality of things to do best questions for my candidates. from your blog my burden was very simply decreased. keep sharing more updated information with us.
    informatica training in chennai


  15. There are many interesting information included and i can easily understand all given information.I post something on my blog to post something, or wait to post something worth saying. Keep update more information....

    Informatica Training in Chennai