ETL - How do we extract SAP data Using Informatica? What is ABAP? What are IDOCS?

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 20 of 65

How do we extract SAP data Using Informatica? What is ABAP? What are IDOCS?

Total Answers and Comments: 3

Last Update: June 10, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 08, 2006 00:44:43

prasoon

RE: How do we extract SAP data Using Informatica? What...

hi!
to extract SAP DATA.

Go to source analser click on source now u will get option 'Import from SAP'

click on this now give your SAP access user client password and filter criteria as table name(so it will take lessertime).Afetr connecting import the sap source.

Now one important thing after finishing the map save it and generate ABAP Code for the map.Then only workflow will be running fine.

Is this answer useful? Yes | No

April 03, 2008 00:54:28

rasmi

Member Since: June 2007 Contribution: 20

RE: How do we extract SAP data Using Informatica? What is ABAP? What are IDOCS?

Hi

We can extract SAP data by using informatica with the powerConnect option.
We need to install and configure the powerConnect tool . 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 Informatice can be pull the data from SAP.

-regards
rasmi

Is this answer useful? Yes | No

June 09, 2009 14:19:47

dtennes

Member Since: June 2009 Contribution: 2

RE: How do we extract SAP data Using Informatica? What is ABAP? What are IDOCS?

You cannot use Informatica to extract data from SAP via ABAP. Only the SAP/Business Objects Data Integrator product can do this.

Informatica uses a data dictionary interface with clear SQL instructions example...

select BUKRS BELNR GJAHR BUZEI from BSEG;

...to get at SAP transactional data.

The problem is that the above query will not produce an extract because BSEG is a 'clustered' table in SAP and clear SQL cannot extract from clustered table types... only ABAP can do that.

Data Integrator dynamically generates ABAP which means that you can extract from any table type in SAP.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank