Multi-database servers with Business Warehouse?
I want to use multiple database servers (exp: MSSQL) that contains different portions of my all data. I am interested in combining and integrating those database servers with a data warehouse solution in a way that I can benefit SAP backbone while accessing and managing data. Solution should give me power to combine results of any queries to any integrated database server. This solution also should give me necessary connection tools in order to query data from web applications or at least from applications that are developed for Enterprise Portal.
Is Business Data Warehouse solution suitable for these needs? All help will be appreciated.