Q

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.

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.

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

Dig deeper on SAP business warehouse

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close