SAP and Informatica PowerCentre

[Former Member]

hi,

If anyone here has used this adapter from Informatica to connect to SAP, I will appreciate any help in:

1. identification of the SAP tables required to browse to meet Informatica powerconnect’s information quality.

2. Identification of the various Bapi's that Informatica Powerconnect reads.

3. Identification of the various IDOCS's that Informatica Powerconnect reads.

Thanking you.

[Former Member]

Thank you so much Agasthuri Doss.

It was definitely useful.

To eloborate on the issue:

i am building an adapter (much like informatica powerConnect), which will connect to a star schema datawarehouse. it will retract data in form of tables, idocs from the SAP R/3 OR SAP BW into it.

1. The tables- are they listed in Transparent table DD02L.

2. The BAPI'S- must be public (do you mean remote enabled?)

3. The IDOC's- are they taken from Tables- EDIDD, EDIDS and EDIDD?

Hope this also helps rekha. Any input is appreciated.

[Former Member]

Hi,

Is there any documentation that i could get which could give me information on loading data for a new R/3 implementation for Logictics modules using informatica and testing for quality purposes.

Would really appreciate for any help.

Thanks

[agasthuri_doss]

Hi,

For you First Question .

As Meta Data the SAP TABLES is available in the Powerconnect

For you Second & third Question .

See that the BAPI is Public

To Know what BAPI to be used :

Get into the System with Tcode - BAPI,

Then you can look for the specified area. Where search for the specified object.

Even from SE37 ( list of BAPIs) you can see their documentation to understand the use of the BAPI.

Regards

Agasthuri Doss

[Former Member]

Hi Agasthuri,

Could you please elaborate more what advantages XI has over the Powerconnect.Can the powerconnect also connect with differnt systems like XI(file,JDBC,Soap,HTTP,Mail).

Thanks,

Rekha.

[agasthuri_doss]

Hi,

Can you Eloborate your Scenerio and What all Systems you are going to Use in your Scenerio.

Regards

Agasthuri Doss