Ask the Expert

Can multiple instances of SAP BW run multiple data mart components?

Is it possible to implement an SAP data warehouse and BW solution and host it on distributed database servers? I ask this question because I have concerns about response times if the data and Info Cubes are all located on a single server.

We were considering a multiple implementation of data marts -- 11 in all -- but this has flexibility issues, so we are looking at SAP BW for a solution. Ideally, we would like have all of the organizations' data on one server (24gb) and then allocate a server to each country to hold InfoCubes on which they can run their reports, etc.

    Requires Free Membership to View

It is possible to have multiple instances of SAP BW running multiple data mart components. This model is recommended if you have an ultra-high volume warehouse (ranging into tens of terabytes). Such a high volume EDW (Enterprise Data Warehouse) system comes with its share of challenges.

a) Separate BW license purchase
b) Very high network traffic
c) Landscape synchronization issues

These days the database engines are highly optimized at the Kernel Level. You should look at single-server installations first, along with logical and physical partitioning implemented. Multi-server data mart scenarios should only be evaluated after evaluating single-server data marts.

This was first published in November 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: