Enterprise Data Warehousing

One of the major challenges BI customers face today is to integrate various source systems into one single enterprise data warehouse. This involves interfacing heterogeneous technical platforms and consolidating different master and transaction data semantics.

An enterprise data warehouse must also 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. It also allows businesses to report in real time, to integrate heterogeneous systems and to 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 and manage a highly flexible, reliable, robust and scalable BI solution.

Benefits of Enterprise Data Warehousing with SAP NetWeaver

Enterprise Data Warehousing offers a significant number of benefits:

• Data modeling
  • Reduced effort, improved flexibility
  • High flexibility provided by layers
• Data provisioning
  • 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 clean-up
• Metadata and document management
  • Integration of multiple BI systems
  • Generated documentation
• Data flow control
  • Enabling operational reporting through real-time data acquisition
  • Reduced administration costs (TCO) through transparent design and control of the data flow
• Administration & monitoring
  • Reduced administration costs (TCO)
  • Assured data quality
• Performance optimization
  • High scalability: Increases 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 administration of end-user and standard authorizations ensures that the various security standards in your organization are adhered to