prasoon

• Aug 8th, 2006

 

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.

rasmi

 Profile Answers by rasmi Questions by rasmi

• Apr 3rd, 2008

 

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

dtennes

 Profile Answers by dtennes 

• Jun 9th, 2009

 

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.