COPA Extraction need to switch between two BW systems.

[snehal_kharmate2]

Hi All,

We have two BW systems , one is BW on Oracle[ 7.0 ] and other is BW on HANA [7.3]. For now we are using oracle for daily operational support. In Oracle we are loading COPA extraction as a Delta and in HANA we are loading COPA Extraction as a Full from ECC PRD system.

We are trying to switch this extraction , meaning we need to make BW HANA COPA Extraction as a Delta and in future we need to load data from HANA to BW oracle.

I am in my initial stage,and need any help kind or suggestion on this request.

Is it possible to switch the deltas between two systems ?

Can we make one system as a delta and can bring records from HANA to BW as a delta ?

Will it impact on extraction process from ECC ?

[oliver_uy2 · Accepted solution]

you can switch the loading from ECC to BW on Hana to delta mode while BW on Oracle is still on delta. just initialize the loading from ECC to Hana during the cut-over activity. I'm assuming ECC is connected to both oracle and hana servers. you can still leave the delta from ECC to oracle in case there will be some issues with Hana. you may have to do some selective deletions on both Hana and Oracle to avoid duplicates unless your DSOs in Oracle and Hana are exactly the same.

for hana to oracle, create connections and DTP transfers from the 2 bw servers.

[maggie_yi]

Dear snehal K,

I don't quite understand your question.

"We are trying to switch this extraction , meaning we need to make BW HANA COPA Extraction as a Delta and in future we need to load data from HANA to BW oracle."

So you'd like to switch to the following scenario:

1. Delta extracted data from 1 ECC to 2 BWs (both Oracle and HANA)

2. The load data from BW on HANA to Oracle

The the 1st one is what you're concerning currently. If my understanding is correct, please refer to the central note about the parallel extraction:

1932459 - DataSource: Data loading to multiple SAP BW or SAP BW/4HANA target systems is not supported

In which it mentions OLTPSOURCE = 1_CO_PA_*. You may read this note carefully.

Best regards,
Maggie