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

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

    Login

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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