Enterprise Data Warehousing
One of the major challenges BI customers face today is to integrate different source systems into one enterprise data warehouse. Not only does this involve interfacing heterogeneous technical platforms, different master and transaction data semantics have to be consolidated.
In addition, an enterprise data warehouse must provide flexible structures and layers in order to adapt quickly to new business challenges (such as changed objectives, mergers, acquisitions).
Beyond these design-time aspects, enterprise data warehousing should facilitate the administration and monitoring of all processes (such as load processes and distribution of data) and proactively support the handling of possible performance issues. This is particularly relevant with regard to the increasingly sophisticated requirements necessitated by larger volumes of data.
The Enterprise Data Warehousing (EDW) IT scenario allows you to create and operate a data warehouse in an enterprise-wide environment. EDW combines strategic analyses and operational reporting. In addition, it allows businesses to report in real time, integrate heterogeneous systems and improve the design time and runtime of BI models and processes.
EDW covers all the steps that have to be performed in system administration in order to set up a highly flexible, reliable, robust and scalable BI solution and easily administrate it.
Benefits of Enterprise Data Warehousing with SAP NetWeaver
You benefit from enterprise data warehousing in many respects:
● Data modeling
○ Reduced effort, improved flexibility
○ High flexibility provided by layers
● Data acquisition
○ Integration of large, complex, heterogeneous system landscapes
○ Data integration across the whole enterprise
○ Enabling remote data access (no additional replication which means low TCO, real-time data access)
● Transformation
○ Data integration, consolidation and cleansing
● Metadata and document management
○ Integration of several BI systems
○ Generated documentation
● Data flow control
○ Enabling operational reporting through real-time data acquisition
○ Reduced administration costs (TCO) through transparent data-flow design and control
● Administration & monitoring
○ Reduced administration costs (TCO)
○ Assured data quality
● Performance optimization
○ High scalability leads to strong end user acceptance
○ Enabling use of large Enterprise Data Warehouses
● Information lifecycle management
○ TCO and performance improvement through reduction of ‘online’ data volume
● User management
○ Flexible management of end-user and standard authorizations allows you to adhere to the various security standards within your organization
Required or Optional Installable Units
To use this IT scenario you require the following installable units:
System with activated usage types:
● Business Intelligence (BI)
● BI Java components (BI Java)
● Enterprise Portal (EP)
● Application Server ABAP (AS ABAP)
● Application Server ABAP (AS ABAP)
● Process Integration (PI)
and the standalone engine:
● TREX
For more information about the required system landscape, see the Master Guide:
Integration with Other IT Scenarios
Data that is integrated into the enterprise data warehouse is available to the Enterprise Reporting, Query, and Analysis and Business Planning and Analytical Services IT scenarios.
Scenario Variants
The IT scenario consists of two variants that cover the design-time aspects (modeling) and runtime aspects of a flexible, reliable, robust, and scalable BI solution:
Variants |
Description |
This variant describes how you optimally define your data model for the purpose of strategic analysis or operational reporting, integrate and consolidate data in the data warehouse, and distribute it to additional data warehouses. |
|
This variant describes how you run your data warehouse to optimize its performance and how you can administrate and monitor it. |
More Information
The following role-specific guides contain further information about this IT scenario:
User Roles and Tasks |
Guide |
Planning the installation of the IT scenario |
For more information, see the Master Guide – SAP NetWeaver available on SAP Service Marketplace at service.sap.com/instguidesnw70 → Installation. |
Planning the upgrade to the IT scenario |
For more information, see the Upgrade Master Guide – SAP NetWeaver available on SAP Service Marketplace at service.sap.com/instguidesnw70 → Upgrade. |
Installation and upgrade |
|
Configuration |
SAP Solution
Manager or Technology Consultant’s Guide:
|
Administration |
Technical
Operations Manual for SAP NetWeaver:
|
Security |
Security Guide:
|
Development |
Developer’s
Guide:
|
Technology
Consultant's Guide