WebFOCUS allows you to build data marts and data warehouses optimized for reporting, while still accessing real-time operational data when required. Click image for more details.
Data Warehousing (Data Warehouse)
A data warehouse is a consolidated view of your enterprise data, optimized for reporting and analysis. Basically it's an aggregated, sometimes summarized copy of transaction and non-transaction data specifically structured for dynamic queries and analytics. In data warehousing, data and information are extracted from heterogeneous production data sources as they are generated, or in periodic stages, making it simpler and more efficient to run queries over data that originally came from different sources. Data is turned into high-quality information to meet all enterprise reporting requirements for all levels of users. Interactive content can be delivered to anyone in the extended enterprise – customers, partners, employees, managers, and executives – anytime, anywhere.
Information Builders offers comprehensive solutions for developing, managing, and optimizing a flexible data architecture that efficiently supports key enterprise information initiatives. Our data management and ETL solutions meet the widest range of information needs by enabling direct access to data in operational systems, staged data in warehouses or marts, and as detail data via drill-throughs.
WebFOCUS employs different access techniques to produce high-quality data, a reusable infrastructure, and comprehensive metadata. Access techniques, which vary according to need, can include:
- Using ETL to extract, transform, and load data directly into a data warehouse or mart
- Transparently drilling and joining data warehouses to operational data
- Using operational systems' own application functions to access data
- Trickle-feeding a data warehouse to populate and refresh it, using real-time transformations
iWay Software, a subsidiary of Information Builders, accelerates business integration by simplifying it dramatically – eliminating custom integration code and replacing it with the straightforward assembly and configuration of off-the-shelf components. iWay's Enterprise Integration Suite provides everything necessary to achieve real-time, near-real time, or batch integration more quickly and easily than competing tools and the roll-your-own approach.
Glossary of Related Terms
