cancel
Showing results for 
Search instead for 
Did you mean: 

DS to BW load balancing

Former Member
0 Kudos

Dear all,

I have a doubt regarding load balancing in PRD. Our team is loading data through DS 12.2.2.3 to SAP BW Master / transaction Infosources.

SAP BW system has five Application Servers / instances to balance the load. BW target data store is configured to connect to the Central Instance of SAP BW.

Since we are connected to the Central instance / application server of BW system from DS, will BW system be able to balance the load across multiple instances?

Since BW Server has multiple instances to balance the load, is there any way we can utilise these BW multiple instances from Data Services?

Can you share your thoughts on this? Appreciate your responses.

Regards,

Suneer.

Accepted Solutions (0)

Answers (1)

Answers (1)

Jan_van_Ansem
Contributor
0 Kudos

Hi Suneer,

There are several ways how DS and BW can interact, so it might depend on what scenario you are using.

I can think of the following scenario's:

1. A DS job is executed from admin console and loads into a BW target datasource.

This should use any available server, according to load balancing settings. It is not possible to force the process to use a specific server.

2. A process chain starts an infopackage, which in turn starts a DS job

BW will use the server chosen at the time of scheduling, if everything is configured correctly and scheduled correctly it will use any avaialble server conform load balancing settings. You can set this to run on a specific server (but I would only recommend this in very special circumstances).

3. DS triggers a process chain

Again, BW will use the settings on the process chain.

4. BW runs an execution command, which starts a DS job

Well, this is not a relevant scenario as it does not update anything on BW - unless the execution command then runs a job which loads data into BW, which is described in scenario 1.

I hope this makes sense. Let me know if you have any other scenario's or concerns.

Can I just ask why you are concerned about this load balancing? I have not have load balancing problems with DS/BW but I have had plenty of problems around concurrent use of the RFC connection between DS/BW. 'Multithreading' was not supported until 12.2.3.2 and you mentioned you run on 12.2.2.3, so potentially this is a problem for you.

Jan.