cancel
Showing results for 
Search instead for 
Did you mean: 

Possibility of connecting multiple BW systems to single ECC system

Former Member
0 Kudos

Hi all,

I have a requirement in my company to connect multiple BW systems to single ECC system. Would like to confirm whether this may not be supported by all BW extractors in particular the delta mechanism?

For logistics extractor in ECC side in RSA7 it stores BW System as target which shows they support multiple BW systems as target, but for FI extractors which keeps delta timestamps in BWOM2_TIMEST table, it doesn't store the target system. I'm afraid if we connect multiple BW systems to single ECC system, some of the delta records might go to one BW system and some others go to the other BW system when we execute delta load in both BW systems.

Thank you very much in advance.

regards,

arie

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Thank you all. I found the official explanation from SAP regarding this in OSS Note 844222 - Two OR more BW systems against one OLTP system.

Thanks once again.

regards,

arie

MartinMaruskin
Active Contributor
0 Kudos

MULTIPLE BW system connected to one ECC is possible scenario. No issue with it not even with extractors.

former_member188080
Active Contributor
0 Kudos

Hi,

Yes it is possible

Thanks and regards

Former Member
0 Kudos

Hi,

Yes, You can connect multiple BW system to single ECC system. In case of FI related data sources different delta queues are created for different target systems.

Navesh

Former Member
0 Kudos

Hi,

You can very well connect multiple BW systems to single ECC system and you will not miss any delta as well. In the source system for each delta data source a delta queue is maintained for each target system.

for e.g. I have two BW systems ABW and BBW connected to AEC system then for 0FI_AP_4 data source we will have DQ1_ABW and DQ2_BBW as two different delta queues (I am not following any naming conventions, actual names will be as per the target system logical name).

The settings maintained in BWOM2_TIMEST table are across the system and they define some global settings e.g. till what time the FI data should be extracted in BW system, for e.g. the time maintained is 2.00 AM then though you do extraction from multiple systems same data will be extracted till next time interval occurs.

In summery you can very well connect multiple BW systems to a single ECC system.

Regards,

Durgesh.

Former Member
0 Kudos