cancel
Showing results for 
Search instead for 
Did you mean: 

Can same R/3 extractor be used for extraction to oracle DB also?

Former Member
0 Kudos

Hello,

Say, for example, we talk of extracting one table from R/3 to BW, there is one extractor. Okay. But can this same R/3 extractor be used for extraction to oracle database also?

There can be few things to consider:

1. SAPI vs DB Connect

2. Another layer of ETL tool between R/3 and Oracle DB

3. Delta Management

Please advice.

Regards

Manish

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I feel there should be different method of extraction available for R3 to ORACLE. Coz, how our standard extractor will work, it will replacate the data source and the same transfer structure should be available in the BW system and throw info package, we are sending the data.

These objects (info source, transfer structure,info package, data source) are standard BW objects. This will not be applicable for ORACLE database. The database will contain only tables, views, structures etc.,

So i fell, in R3 we can create connection to ORACLE throw SM59 and throw table to table mapping, we can transfer data.

Sorry for misunderstand the question previously.

Regards,

Vivek V

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

If you want to extract the data from ORACLE to BW, normally companies will select either one way of the below two ways:

1. DB Connect:

If you will extract the data directly from ORACLE, then you have to create source system for connect the external system.

Using this you can extract the data. It is little hard to use delta in this connectivity. Check out the last para of the below link:

Normally if one side extractor is R3, then people will go with DB Connect. Coz they will maintain the info source like standard.

http://help.sap.com/saphelp_nw04/helpdata/en/ab/1955b58ad19e4bb0e5249a4be475d7/content.htm

1. Throw ETL:

If you have very huge amount of data and in ORACLE query itself delta records will come, then the easy way to extract the data is extract throw one intermediate tool like Ascential.

In my company, we are extracting very huge data from ORACLE database by using third party tool as Ascential.

Regards,

Vivek V

Former Member
0 Kudos

Thanks Vivek.

However, there is a gap. The case is NOT Oracle to BW. It is R/3 to Oracle.

Question is, R/3 sending same data to two systems, BW and Oracle. Can I use the same extractor? Of course, method of connection will be different, and that is taken. Just wish to know if same extractor can 'supply' data to BW as well one Oracle DB.