Pages

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

25 comments:

  1. Informatica Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/informatica-online-training-31.html 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 - contact@21cssindia.com
    Visit: http://www.21cssindia.com/courses.html"

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

    http://www.dwbiadda.com/course/informatica-online-training/

    --
    Thanks and Regards
    Your Best Online Training Partner
    Team DWBIADDA.com,
    www.dwbiadda.com
    http://dwbiadda.blogspot.in/
    Call +91-720-720-9005
    Mail:dwbiadda@gmail.com
    Skype: DWBIADDA

    ReplyDelete
  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, info@ambrot.com

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

    ReplyDelete
  5. Fantastic Blog..!!
    Thanks for sharing such a good information
    We Provide INFORMATICA ONLINE TRAINING

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

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

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

    Advanced informatica online training!

    ReplyDelete
  9. Nice blog..
    http://www.informaticaonlinetraining.co/

    ReplyDelete
  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

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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete

  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

    ReplyDelete
  16. I really appreciate for your efforts to make things easy to understand. I was really many students struggling to understand certain concepts but you made it clear and help me bring back my confidence.

    Data science Online training in hyderabad
    Data science Online training in usa
    Data science Online training in

    ReplyDelete
  17. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic. iOS App Development Company in India

    ReplyDelete
  18. This was so useful and informative. The article helped me to learn something new. Security alarm in Chennai

    ReplyDelete
  19. Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving..

    Home Spa Services in Mumbai

    ReplyDelete
  20. Nice Blog. Thank you for sharing nice information about Informatica. Nice Article

    Online Informatica Training
    Online Informatica Training in Hyderabad

    ReplyDelete
  21. There are lots of information about latest technology and how to get trained in them, like this have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies. By the way you are running a great blog. Thanks for sharing this.

    MSBI Training in Chennai

    Informatica Training in Chennai

    ReplyDelete
  22. Great stuff provided by the Admin here… look into this for informatica online training

    ReplyDelete
  23. It’s really amazing that we can record what our visitors do on our site. Thanks for sharing this awesome guide. I’m happy that I came across with your site this article is on point,thanks again and have a great day. Keep update more information..

    Informatica Training in Chennai

    Dataware Housing Training in Chennai

    ReplyDelete